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:
收起