紧急求救,服务器掉电后,出现58004错误 - DB2 & Informix - LoveUnix -- 最强AIX小机技术论坛,UNIX,Linux,存储,数据库,中间件,开发,管理 -- 蓝色的IBM技术天堂 --bbs.LoveUnix.net

xppdx

LU新生

UID 5330
精华 0
积分 12
帖子 23
活跃指数 2
LU金币 2012 个
LU金条 0 个
阅读权限 10
注册 2003-12-10

大中小

使用道具

发表于 2007-6-10 16:48 资料个人空间短消息加为好友

紧急求救,服务器掉电后,出现58004错误

服务器意外掉电,重启后连接数据库时出现如下提示"SQL1042C 发生意外的系统错误 SQLSTATE=58004"

下面是日志中的内容:

2007-06-10-16.38.15.843000 Instance

B2 Node:000
PID:1472(db2syscs.exe) TID:3268 Appid:*LOCAL.DB2.0117C0083815
base sys utilities sqledint Probe:30
Crash Recovery is needed.
2007-06-10-16.38.15.859000 Instance

B2 Node:000
PID:1472(db2syscs.exe) TID:3268 Appid:*LOCAL.DB2.0117C0083815
recovery manager sqlpresr Probe:410 Database:JSRUN
Crash recovery started. LowtranLSN 00000109B1BB9118 MinbuffLSN 00000109B1BB78AE
2007-06-10-16.38.15.875001 Instance

B2 Node:000
PID:1472(db2syscs.exe) TID:3268 Appid:*LOCAL.DB2.0117C0083815
recovery manager sqlprecm Probe:125 Database:JSRUN
Using parallel recovery with 5 agents 4 QSets 28 queues and 2 chunks

2007-06-10-16.38.18.109000 Instance

B2 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

B2 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

B2 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".

beginner-bj

版主

UID 9471
精华 15
积分 1400
帖子 2409
活跃指数 186
LU金币 4404 个
LU金条 0 个
阅读权限 210
注册 2004-1-16

大中小

使用道具

发表于 2007-6-11 10:35 资料个人空间短消息加为好友

硬盘故障，先从操作系统层面看看能否解决。

不行的话，只有RESTORE了。

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

我的博客：http://blog.chinaunix.net/index.php?blogId=739欢迎访问，并请多多批评指正。