LoveUnix » DB2 & Informix » 紧急求救,服务器掉电后,出现58004错误
让LU留住您的每

一天 让LU博客留住您的每一天
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]

2007-6-11 10:35 beginner-bj
硬盘故障,先从操作系统层面看看能否解决。

不行的话,只有RESTORE了。

RESTORE前,一定要导出部分数据的话,用DB2DART

页: [1]


Powered by Discuz! Archiver 5.5.0  © 2001-2006 Comsenz Inc.