db2 connect to DB
SQL0293N Error accessing a table space container. SQLSTATE=57048
。
查看了db2diag.log, 问题是不是在这里?
ADM6023I The table space "SYSCATSPACE" (ID "0") is in state 0x"0".
The table space cannot be accessed. Refer to the documentation for
SQLCODE -290
请教遇到这种问题,要如何进行解决呢?谢谢大家~~
2016-02-02-05.31.52.538208+060 I88256751A474 LEVEL: Severe
PID : 29032458 TID : 76080 PROC : db2sysc 0
INSTANCE: insttop NODE : 000 DB : XMETA
APPHDL : 0-5604 APPID: 10.3.9.35.58492.160202043152
AUTHID : XMETA
EDUID : 76080 EDUNAME: db2agent (XMETA) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbContainerTagIsValid, probe:900
DATA #1 : String, 31 bytes
sqloHasSameVnode returned false
2016-02-02-05.31.52.538327+060 I88257226A667 LEVEL: Error
PID : 29032458 TID : 76080 PROC : db2sysc 0
INSTANCE: insttop NODE : 000 DB : XMETA
APPHDL : 0-5604 APPID: 10.3.9.35.58492.160202043152
AUTHID : XMETA
EDUID : 76080 EDUNAME: db2agent (XMETA) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSDoContainerOp, probe:840
MESSAGE : ZRC=0x8402001E=-2080243682=SQLB_CONTAINER_NOT_ACCESSIBLE
"Container not accessible"
DATA #1 :
Error checking container 0 (/db/insttop/db2data/xmeta/insttop/NODE0000/XMETA/T0000000/C0000000.CAT) for tbsp 0. Rc = 8402001E
2016-02-02-05.31.52.538476+060 I88257894A563 LEVEL: Error
PID : 29032458 TID : 76080 PROC : db2sysc 0
INSTANCE: insttop NODE : 000 DB : XMETA
APPHDL : 0-5604 APPID: 10.3.9.35.58492.160202043152
AUTHID : XMETA
EDUID : 76080 EDUNAME: db2agent (XMETA) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSStartPool, probe:800
MESSAGE : ZRC=0x8402001E=-2080243682=SQLB_CONTAINER_NOT_ACCESSIBLE
"Container not accessible"
DATA #1 :
Tablespace 0 (SYSCATSPACE)
2016-02-02-05.31.52.538603+060 E88258458A586 LEVEL: Info
PID : 29032458 TID : 76080 PROC : db2sysc 0
INSTANCE: insttop NODE : 000 DB : XMETA
APPHDL : 0-5604 APPID: 10.3.9.35.58492.160202043152
AUTHID : XMETA
EDUID : 76080 EDUNAME: db2agent (XMETA) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:30
MESSAGE : ADM6023I The table space "SYSCATSPACE" (ID "0") is in state 0x"0".
The table space cannot be accessed. Refer to the documentation for
SQLCODE -290.
2016-02-02-05.31.52.538763+060 I88259045A508 LEVEL: Error
PID : 29032458 TID : 76080 PROC : db2sysc 0
INSTANCE: insttop NODE : 000 DB : XMETA
APPHDL : 0-5604 APPID: 10.3.9.35.58492.160202043152
AUTHID : XMETA
EDUID : 76080 EDUNAME: db2agent (XMETA) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:30
MESSAGE : ZRC=0x8402001E=-2080243682=SQLB_CONTAINER_NOT_ACCESSIBLE
"Container not accessible"
2016-02-02-05.31.52.538981+060 I88259554A508 LEVEL: Error
PID : 29032458 TID : 76080 PROC : db2sysc 0
INSTANCE: insttop NODE : 000 DB : XMETA
APPHDL : 0-5604 APPID: 10.3.9.35.58492.160202043152
AUTHID : XMETA
EDUID : 76080 EDUNAME: db2agent (XMETA) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:30
MESSAGE : ZRC=0x8402001E=-2080243682=SQLB_CONTAINER_NOT_ACCESSIBLE
"Container not accessible"
2016-02-02-05.31.52.539095+060 I88260063A503 LEVEL: Error
PID : 29032458 TID : 76080 PROC : db2sysc 0
INSTANCE: insttop NODE : 000 DB : XMETA
APPHDL : 0-5604 APPID: 10.3.9.35.58492.160202043152
AUTHID : XMETA
EDUID : 76080 EDUNAME: db2agent (XMETA) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbinit, probe:590
MESSAGE : ZRC=0x8402001E=-2080243682=SQLB_CONTAINER_NOT_ACCESSIBLE
"Container not accessible"
2016-02-02-05.31.52.590931+060 I88260567A839 LEVEL: Severe
PID : 29032458 TID : 76080 PROC : db2sysc 0
INSTANCE: insttop NODE : 000 DB : XMETA
APPHDL : 0-5604 APPID: 10.3.9.35.58492.160202043152
AUTHID : XMETA
EDUID : 76080 EDUNAME: db2agent (XMETA) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:4520
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -293 sqlerrml: 0
sqlerrmc:
sqlerrp : SQL09079
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
进程尝试访问一个处于无效状态的表空间,处于该状态的表空间不允许进行预期的访问。
如果表空间处于停顿状态(“Quiesced: SHARE”、“Quiesced: UPDATE”或“Quiesced: EXCLUSIVE”),那么仅允许使表空间处于停顿状态的进程访问表空间。如果表空间处于其他任何状态,那么仅允许正在执行导致当前表空间状态操作的进程访问表空间。不能删除包含活动的系统临时表、已创建的临时表或者已声明的临时表的系统或用户临时表空间。除非表空间处于“复原暂挂”状态,否则不能使用 SET CONTAINER API 来设置容器列表。可能的操作包括:
如果表空间处于停顿状态,那么尝试获得表空间的停顿共享或停顿更新状态。或者,尝试停顿重置表空间。如果表空间处于其他任何状态,那么在尝试访问表空间之前,请先等待表空间返回正常状态。请参阅《管理指南》,以了解有关表空间状态的更多信息。
sqlcode:-290
sqlstate:55039
FYI
收起