2007-6-10 16:48
xppdx
紧急求救,服务器掉电后,出现58004错误
[size=13px]服务器意外掉电,重启后连接数据库时出现如下提示"SQL1042C 发生意外的系统错误 SQLSTATE=58004"
下面是日志中的内容:
2007-06-10-16.38.15.843000 Instance:DB2 Node:000
PID:1472(db2syscs.exe) TID:3268 Appid:*LOCAL.DB2.0117C0083815
base sys utilities sqledint Probe:30 [/size]
[size=13px]Crash Recovery is needed. [/size]
[size=13px]2007-06-10-16.38.15.859000 Instance:DB2 Node:000
PID:1472(db2syscs.exe) TID:3268 Appid:*LOCAL.DB2.0117C0083815
recovery manager sqlpresr Probe:410 Database:JSRUN[/size]
[size=13px]Crash recovery started. LowtranLSN 00000109B1BB9118 MinbuffLSN 00000109B1BB78AE[/size]
[size=13px]2007-06-10-16.38.15.875001 Instance:DB2 Node:000
PID:1472(db2syscs.exe) TID:3268 Appid:*LOCAL.DB2.0117C0083815
recovery manager sqlprecm Probe:125 Database:JSRUN[/size]
[size=13px]Using parallel recovery with 5 agents 4 QSets 28 queues and 2 chunks[/size]
[size=13px]
2007-06-10-16.38.18.109000 Instance:DB2 Node:000
PID:1472(db2syscs.exe) TID:3352 Appid:*LOCAL.DB2.0117C0083815
data protection sqlpgrlgRedo Probe:1270 Database:JSRUN
recLsn: 0000 0109 b204 1fb4 ... ....
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\14723352.000 Data:SQLP_DBCB
2007-06-10-16.38.18.125001 Instance:DB2 Node:000
PID:1472(db2syscs.exe) TID:3352 Appid:*LOCAL.DB2.0117C0083815
data protection sqlpgrlgRedo Probe:0 Database:JSRUN
Error -2045771763 when reading LSN 00000109B2041FB4 from log file S0000003.LOG, dpsAcbFlags 30, setSkipOutputBuf 0
2007-06-10-16.38.18.125002 Instance:DB2 Node:000
PID:1472(db2syscs.exe) TID:3352 Appid:*LOCAL.DB2.0117C0083815
recovery manager sqlpPRecReadLog Probe:1280 Database:JSRUN
DIA8414C Logging can not continue due to an error.
ZRC=0x8610000D
2007-06-10-16.38.18.140000 Instance:DB2 Node:000
PID:1472(db2syscs.exe) TID:3268 Appid:*LOCAL.DB2.0117C0083815
recovery manager sqlpresr Probe:640 Database:JSRUN
Crash recovery failed with rc -2045771763
LowtranLSN 00000109B2041D78 MinbuffLSN 00000109B1E704EA
Recovery started on log file S0000003.LOG.
2007-06-10-16.38.18.156000 Instance:DB2 Node:000
PID:1472(db2syscs.exe) TID:3268 Appid:*LOCAL.DB2.0117C0083815
base sys utilities recover Probe:16 Database:JSRUN
DiagData
0d00 1086 ....
2007-06-10-16.38.18.156001 Instance:DB2 Node:000
PID:1472(db2syscs.exe) TID:3268 Appid:*LOCAL.DB2.0117C0083815
base sys utilities recover Probe:16 Database:JSRUN
0d00 1086 ....
2007-06-10-16.38.18.156002 Instance:DB2 Node:000
PID:1472(db2syscs.exe) TID:3268 Appid:*LOCAL.DB2.0117C0083815
base sys utilities recover Probe:60 Database:JSRUN
ADM1532E Crash recovery has failed with SQLCODE "-1042".
2007-06-10-16.38.18.156003 Instance:DB2 Node:000
PID:1472(db2syscs.exe) TID:3268 Appid:*LOCAL.DB2.0117C0083815
base sys utilities sqleMarkDBad Probe:10 Database:JSRUN
ADM7518C "JSRUN " marked bad.
2007-06-10-16.38.18.171000 Instance:DB2 Node:000
PID:1472(db2syscs.exe) TID:3268 Appid:*LOCAL.DB2.0117C0083815
base sys utilities sqleInitEngineComponents Probe:202 Database:JSRUN
If 'DATALINK: file server not registered' appears above and DATALINKS=NO, set DATALINKS=YES and try RESTART again
2007-06-10-16.38.18.187000 Instance:DB2 Node:000
PID:1472(db2syscs.exe) TID:3268 Appid:*LOCAL.DB2.0117C0083815
base sys utilities sqlesrsu Probe:140 Database:JSRUN
DIA0001E An internal error occurred. Report the following error code :
"ZRC=0xFFFFFBEE".
2007-06-10-16.38.18.187001 Instance:DB2 Node:000
PID:1472(db2syscs.exe) TID:3268 Appid:*LOCAL.DB2.0117C0083815
data protection sqlpthrd Probe:440 Database:JSRUN
DIA0001E An internal error occurred. Report the following error code : "ZRC=0x
0".
2007-06-10-16.38.18.187002 Instance:DB2 Node:000
PID:1472(db2syscs.exe) TID:3268 Appid:*LOCAL.DB2.0117C0083815
buffer pool services sqlbTerminateAgent Probe:837 Database:JSRUN
DIA8427C The database has been marked as being damaged.
ZRC=0x8602001A
2007-06-10-16.38.18.203000 Instance:DB2 Node:000
PID:1472(db2syscs.exe) TID:3268 Appid:*LOCAL.DB2.0117C0083815
base sys utilities sqleAgentDissociate Probe:90 Database:JSRUN
DIA0001E An internal error occurred. Report the following error code : "ZRC=0x
6000000".
2007-06-10-16.38.18.203001 Instance:DB2 Node:000
PID:1472(db2syscs.exe) TID:3268 Appid:*LOCAL.DB2.0117C0083815
base sys utilities sqleTermDbConnect Probe:110
DIA0001E An internal error occurred. Report the following error code :
"ZRC=0xFFFFFBF6".
2007-06-10-16.38.18.234000 Instance:DB2 Node:000
PID:1472(db2syscs.exe) TID:3268 Appid:*LOCAL.DB2.0117C0083815
base sys utilities sqlelost Probe:40
DIA0001E An internal error occurred. Report the following error code :
"ZRC=0xFFFFFBEE".
[/size]