Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2010-08-31
5
Medium Priority
?
11,262 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 1500 total points
ID: 33568424
0
 

Author Closing Comment

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

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

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 (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Suggested Courses

636 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