Db2 Error Sql0290n
Contents |
trying to connect to database.
Access Not Allowed. Tblspc Backup Pend.
Technote (troubleshooting) Problem(Abstract) Trying to connect to database, may sometime
0x2001100
hit with "SQL0290N Table space access is not allowed", even though tablespace containers path table space access not allowed are accessible and exists and container permissions are correct. Symptom Following error may be thrown in this case: $ db2 connect to sample http://www.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.messages.sql.doc/doc/msql00290n.html SQL0290N Table space access is not allowed. SQLSTATE=55039 Cause Any of the following could be the reason: 1) Database's file system not mounted. 2) root file system is full. Diagnosing the problem Check the following: 1) Check db2diag.log file to see if there are http://www-01.ibm.com/support/docview.wss?uid=swg21608111 any error messages stating something like database's path and files are not accessible. 2) "df" command to check if root file system is full. For Example : $df 3) Run "lsvg -l rootvg" command to check if database's file system are in closed/sync state For Example :$lsvg -l rootvg Resolving the problem Mount database's file system and enlarge root file system size then retry operation again. Related information SQL0290N : Table space access is not allowed. Document information More support for: DB2 for Linux, UNIX and Windows Database Objects/Config - Tablespaces Software version: 9.1, 9.5, 9.7, 10.1, 10.5, 11.1 Operating system(s): AIX, HP-UX, Linux, Solaris, Windows Reference #: 1608111 Modified date: 2016-07-19 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility
is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to http://www.dbforums.com/showthread.php?794279-SQL0290N-Table-space-access-is-not-allowed-SQLSTATE-55039 visit from the selection below. Results 1 to 14 of 14 Thread: SQL0290N Table space access is not allowed. SQLSTATE=55039 Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 05-23-03,12:43 #1 mixxalot View Profile View Forum Posts Registered User Join Date May 2003 Posts 369 Unanswered: SQL0290N Table space access is not allowed. SQLSTATE=55039 One of our development DB2 UDB not allowed 7.1 boxes crashed this morning and after the unix sysadmin rebooted the system I cannot connect to our DB2 database, get the following errors: db2 connect to database SQL0290N Table space access is not allowed. SQLSTATE=55039 How can I resolve this problem so that I can reconnect to our database? Thanks! Scott Reply With Quote 05-23-03,12:54 #2 Marcus_A View Profile View Forum Posts Registered User Join Date May 2003 Location USA Posts 5,737 SQL0290N Table space access is table space access not allowed. Explanation: A process attempted to access a table space which is in an invalid state for which the intended access is not allowed. - If the table space is in a quiesced state, only processes which also hold the table space in a quiesced state are allowed access to the table space. - If the table space is in any other state, only the process which is performing the action specified is allowed access to the table space. - A system or user temporary table space cannot be dropped which contains active system or declared temporary tables. - The SET CONTAINER api cannot be used to set the container list unless the table space is in a "restore pending" state. Details can be found in the system error log and/or the database manager error log. User Response: Possible actions include: - If the table space is in a quiesced state, attempt to acquire a quiesced share or quiesced update state on the table space. Or, attempt to quiesce reset the table space. - If the table space is in any other state, wait until the table space has returned to normal state before attempting to access the table space. Refer to the Administration Guide for further information about the table space states. sqlcode: -290 sqlstate: 55039 Reply With Quote 05-23-03,12:58 #3 sathyaram_s View Profile View Forum Posts Visit Hom