db2 数据库不能连接 58004

db2 数据库重起后不能连接了,报错信息SQL1042N An unexpected system error occurred. . SQLSTAT=58004查了下db2diag文件2015-12-07-12.27.44.765001   Instance:DB2   Node:000PID:1644(db2syscs.exe)   TID:3588   Appid:*LOC...显示全部

db2 数据库重起后不能连接了,报错信息

SQL1042N An unexpected system error occurred. . SQLSTAT=58004

查了下db2diag文件

2015-12-07-12.27.44.765001   Instance:DB2   Node:000

PID:1644(db2syscs.exe)   TID:3588   Appid:*LOCAL.DB2.151207042737

recovery_manager  sqlprInitQCB   Probe:40   Database:GJCH

DIA3841C The index key could not be found, the value was "".

ZRC=0xFFFFF92C

2015-12-07-12.27.44.812000   Instance:DB2   Node:000

PID:1644(db2syscs.exe)   TID:3588   Appid:*LOCAL.DB2.151207042737

recovery_manager  sqlpresr   Probe:160   Database:GJCH

DIA3907W In-doubt transaction(s) exists at the end of crash recovery.

2015-12-07-12.27.44.828000   Instance:DB2   Node:000

PID:1644(db2syscs.exe)   TID:3588   Appid:*LOCAL.DB2.151207042737

recovery_manager  sqlpresr   Probe:10   Database:GJCH

DIA3910W Crash recovery completed. Return Code = "-1748"

2015-12-07-12.27.44.843000   Instance:DB2   Node:000

PID:1644(db2syscs.exe)   TID:3588   Appid:*LOCAL.DB2.151207042737

recovery_manager  sqlpresr   Probe:10   Database:GJCH

Recovery started on log file: 5330 3030 3030 3030 2e4c 4f47                 S0000000.LOG               

2015-12-07-12.27.44.890000   Instance:DB2   Node:000

PID:1644(db2syscs.exe)   TID:3588   Appid:*LOCAL.DB2.151207042737

base_sys_utilities  sqlesrsu   Probe:16   Database:GJCH

DiagData

2cf9 ffff                                     ,...               

2015-12-07-12.27.44.937000   Instance:DB2   Node:000

PID:1644(db2syscs.exe)   TID:3588   Appid:*LOCAL.DB2.151207042737

base_sys_utilities  sqlesrsu   Probe:16   Database:GJCH

RIDS/sqlesrsu MS/UNK_REC_ERR PRCS/162cf9 ffff                                     ,...               

2015-12-07-12.27.44.984000   Instance:DB2   Node:000

PID:1644(db2syscs.exe)   TID:3588   Appid:*LOCAL.DB2.151207042737

base_sys_utilities  sqlesrsu   Probe:110   Database:GJCH

Restart failed with sqlcode: eefb ffff                                     ....               

2015-12-07-12.27.45.015000   Instance:DB2   Node:000

PID:1644(db2syscs.exe)   TID:3588   Appid:*LOCAL.DB2.151207042737

base_sys_utilities  sqlesrsu   Probe:202   Database:GJCH

String Title: PID:1644 Node:000

If 'DATALINK: file server not registered' appears above and DATALINKS=NO, set DATALINKS=YES and try RESTART again

2015-12-07-12.27.45.031000   Instance:DB2   Node:000

PID:1644(db2syscs.exe)   TID:3588   Appid:*LOCAL.DB2.151207042737

buffer_pool_services  sqlbTerminateAgent   Probe:837   Database:GJCH

DIA3727C The database has been marked as being damaged.

ZRC=0xFFFFE11A

2015-12-07-12.27.45.062000   Instance:DB2   Node:000

PID:1644(db2syscs.exe)   TID:3588   Appid:*LOCAL.DB2.151207042737

base_sys_utilities  sqleTermDbConnect   Probe:5   Database:GJCH

DIA3727C The database has been marked as being damaged.

ZRC=0xFFFFE11A


不是很懂db2 ,求助各位给个解决方法,谢谢了,windows下db2 7

收起
参与5

返回xray的回答

xrayxray系统工程师inspur

DIA3727C The database has been marked as being damaged.

数据库标记损坏。

重启之前干嘛了?

如果数据库不大,可以做下db2dart看看报告。

互联网服务 · 2015-12-08
浏览1657

回答者

xray
系统工程师inspur

xray 最近回答过的问题

回答状态

  • 发布时间:2015-12-08
  • 关注会员:2 人
  • 回答浏览:1657
  • X社区推广