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
收起