Unable to connect to BigSQL, getting error “SQL0290N Table space access is not allowed. SQLSTATE=55039”

After an improper shutdown, I am no longer able to connect to BigSQL.

[bigsql] $ db2 connect to bigsql
SQL0290N Table space access is not allowed. SQLSTATE=55039

A `db2 list tablespaces show detail` shows tablespace TEMPSPACE1 is in an offline state.


Tablespace ID = 1
Name = TEMPSPACE1
Type = System managed space
Contents = System Temporary data
State = 0x4000
Detailed explanation:
Offline

The db2diag.log shows the cause:

While restarting the database, BigSQL was not able to access the container of the TEMPSPACE1 tablespace in /var/ibm/bigsql/database/bigsql/NODE0000/BIGSQL/T0000001/C0000000.TMP. The cause on this occasion was a user who deleted this container in error.

2017-01-18-11.28.15.320720+000 I85320004E713 LEVEL: Error
PID : 2019205 TID : 140721117980416 PROC : db2sysc 0
INSTANCE: bigsql NODE : 000 DB : BIGSQL
APPHDL : 0-132 APPID: 172.31.24.73.48733.170118112812
AUTHID : BIGSQL HOSTNAME: tizzy1.ibm.com
EDUID : 90 EDUNAME: db2agent (BIGSQL) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbSMSDoContainerOp, probe:815
MESSAGE : ZRC=0x8402001E=-2080243682=SQLB_CONTAINER_NOT_ACCESSIBLE
“Container not accessible”
DATA #1 :
Error checking container 0
(/var/ibm/bigsql/database/bigsql/NODE0000/BIGSQL/T0000001/C0000000.TMP) for tbsp 1. Rc = 870F0011
As this is a temporary tablespace, can I do anything to avoid a restore?

Related:

Leave a Reply