急急急,表空间无法访问
你好:
最近实施了一个项目,今天因为某些原因,想备份一下数据库,我备份的时候无断开了连接,然后进行备份。备份完之后,再连接数据库的时候就连接不上了,提示“访问表空间容器出差,SQLSTATE=57048”我现在是根本就连不上数据库。
错误日志:
2011-05-20-13.12.43.437000+480 I1094875H512 LEVEL: Error
PID : 644 TID : 3156 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : APS2
APPHDL : 0-42 APPID: 127.0.0.1.3067.110520051242
AUTHID : APS2
EDUID : 3156 EDUNAME: db2agent (APS2) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbinit, probe:590
MESSAGE : ZRC=0x8402001E=-2080243682=SQLB_CONTAINER_NOT_ACCESSIBLE
"Container not accessible"
2011-05-20-13.12.43.468000+480 I1095389H517 LEVEL: Severe
PID : 644 TID : 3156 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : APS2
APPHDL : 0-42 APPID: 127.0.0.1.3067.110520051242
AUTHID : APS2
EDUID : 3156 EDUNAME: db2agent (APS2) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:125
DATA #1 : Hexdump, 4 bytes
0x7A7BAFF0 : DBFE FFFF ....
2011-05-20-13.12.43.531000+480 E1095908H476 LEVEL: Event
PID : 644 TID : 3156 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : APS2
APPHDL : 0-42 APPID: 127.0.0.1.3067.110520051242
AUTHID : APS2
EDUID : 3156 EDUNAME: db2agent (idle) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::TermDbConnect, probe:2000
STOP : DATABASE: APS2 : DEACTIVATED: NO
2011-05-20-13.13.16.843000+480 I1096386H752 LEVEL: Warning
PID : 644 TID : 3156 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-43
EDUID : 3156 EDUNAME: db2agent () 0
FUNCTION: DB2 UDB, Connection Manager, sqleUCgetDirInfo, probe:1012
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1013 sqlerrml: 4
sqlerrmc: ASP2
sqlerrp : SQLEUCCM
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:
2011-05-20-13.13.24.390000+480 I1097140H650 LEVEL: Error
PID : 644 TID : 3156 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : APS2
APPHDL : 0-44 APPID: 127.0.0.1.3069.110520051322
AUTHID : APS2
EDUID : 3156 EDUNAME: db2agent (APS2) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSDoContainerOp, probe:810
MESSAGE : ZRC=0x8402001E=-2080243682=SQLB_CONTAINER_NOT_ACCESSIBLE
"Container not accessible"
后来我想还原,然后我发现我备份的数据是损坏的。各位大哥大姐帮帮忙啊,客户20多台设备等着服务器用,不然的话要闹翻天了!