Solved

DB2 SQL error: SQLCODE: -290, SQLSTATE: 55039, SQLERRMC: null  Message: Table space access is not allowed.

Posted on 2010-08-31
5
10,431 Views
Last Modified: 2012-05-10
When i am trying updating/inserting data in table i am getting below error message

DB2 SQL error: SQLCODE: -290, SQLSTATE: 55039, SQLERRMC: null
 Message: Table space access is not allowed.
0
Comment
Question by:partminer
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 37

Expert Comment

by:momi_sabag
ID: 33565974
0
 

Author Comment

by:partminer
ID: 33567815
Dear Greg,

This problem happened of below reason.
I was loading the data into the table in prod using load command.I have cancelled the load.After that i have terminated the load.

I am able to access the table but.not the table space.

can you please help me how can I solve this issue.

Your help is greatly appreciated.Thank you.
0
 

Author Comment

by:partminer
ID: 33567831
Hi Greg, I am sorry this request is for Momi.

Dear Momi, Can you please help me to solve this.
0
 
LVL 37

Accepted Solution

by:
momi_sabag earned 500 total points
ID: 33568424
0
 

Author Closing Comment

by:partminer
ID: 33594878
he is not provided exact solution to my problem
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question