db2 error sql0290n
290 0290 55039 Technote (troubleshooting) Problem(Abstract) ADM6023I The table access not allowed. tblspc backup pend. space "
Table Space Access Not Allowed -290 Symptom Tklm starts with errors Cause Table space is missing Resolving the problem After doing a successful restore on a TKLM server, TKLM http://www.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.messages.sql.doc/doc/msql00290n.html starts with the following errors in systemOut.log and in db2diag.log: 2012-08-22-10.52.24.142383-300 E2796012A592 LEVEL: Info PID : 3080672 TID : 13148 PROC : db2sysc INSTANCE: tklmdb2 NODE : 000 DB : TKLMDB APPHDL : 0-48 APPID: 127.0.0.1.43424.120822155222 AUTHID : TKLMDB2 EDUID : 13148 EDUNAME: db2agent (TKLMDB) FUNCTION: DB2 UDB, buffer pool http://www-01.ibm.com/support/docview.wss?uid=swg21609130 services, sqlbStartPools, probe:20 MESSAGE : ADM6023I The table space "SYSTOOLSPACE" (ID "11") is in state 0x"2001100". The table space cannot be accessed. Refer to the documentation for SQLCODE -290. 2012-08-22-10.52.24.142715-300 I2796605A521 LEVEL: Error PID : 3080672 TID : 13148 PROC : db2sysc INSTANCE: tklmdb2 NODE : 000 DB : TKLMDB APPHDL : 0-48 APPID: 127.0.0.1.43424.120822155222 AUTHID : TKLMDB2 EDUID : 13148 EDUNAME: db2agent (TKLMDB) FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:20 MESSAGE : ZRC=0x80020035=-2147352523=SQLB_NOT_ALLOWED_RECOVERY_P "Access not allowed. Tblspc Recovery Pend." Same errors as above in db2diag.log plus more: 2012-08-22-10.55.39.039322-300 E2798617A521 LEVEL: Error PID : 5898744 TID : 1029 PROC : db2acd INSTANCE: tklmdb2 NODE : 000 APPID : *LOCAL.tklmdb2.120822155541 EDUID : 1029 EDUNAME: db2acd FUNCTION: DB2 UDB, Automatic Table Maintenance, atmRefreshInfoTable, probe:320 DATA #1 : String, 11 bytes AutoStats: DATA #2 : String, 90 bytes [IBM][CLI Driver][DB2/AIX64] SQL0290N Table space access is not allowed. SQLST
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn http://dba.stackexchange.com/questions/36480/db2-server-table-space-locked more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills https://bytes.com/topic/db2/answers/530017-tablespace-restore-pending-state and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top not allowed DB2 Server Table Space Locked up vote 2 down vote favorite At work we keep receiving the following DataException seemingly at random when one of our processes tries to write/access a table for one of our clients: com.ibm.db.DataException: A database manager error occurred. : [IBM][CLI Driver][DB2/NT64] SQL0290N Table space access is not allowed. SQLSTATE=55039 Has anyone encountered this? I'm not the person who primarily does administrative tasks on our databases, but even they seem to be having table space access difficulty finding the root of this problem. Any suggestions? Anyone encounter this before? This error comes up for only one of our clients at a time, and it generally seems to rotate. We have Rackspace service but they wont be of much help unless we can provide screenshots, etc at the exact moment this occurs. Apologies if this post may be too vague, please let me know what information to supply to clarify things more. I'm one of the developers in my office, but I don't primarily handle the administrative tasks on our databases. edit: We spoke with IBM and this could possibly be caused by some sort of virus scan being run by IBM/Rackspace as a part of maintenance? They said this kind of dubiously though, so I am doubting this is the culprit because tables remained locked for variable amounts of time. db2 error-handling tablespaces share|improve this question edited Mar 12 '13 at 21:11 Chris Aldrich 3,62041847 asked Mar 11 '13 at 13:29 SMT 11826 migrated from stackoverflow.com Mar 12 '13 at 13:45 This question came from our site for professional and enthusiast programmers. Is this a Microsoft SQL Server error or a DB2 error? –alroc Mar 11 '13 at 13:32 @alroc A DB2 error. –SMT Mar 11 '13 at 13:44 1 What you are experiencing doesn't happen on healthy DB2 setups. What
your question and get tips & solutions from a community of 418,478 IT Pros & Developers. It's quick & easy. Tablespace in RESTORE PENDING state P: n/a satish mullapudi Hi All, I am using Db2 UDB v 8.2 on RHEL . I have performed a load operation on a table. Now that tablespace has been switched into RESTORE PENDING state. Now I can only read the data in the table. I can't modify the data in the table as it is giving me an error saying "Tablespace Access denied". How can I bring the tablespace out of RESTORE PENDING state? Please help me out Thnak you in Advance....... Aug 31 '06 #1 Post Reply Share this Question 7 Replies P: n/a Mark A "satish mullapudi"