因为电源不稳定,一天发生了几次断电,数据库启动后报错,数据库处于不一致状态,sqlstate=5502.后面进行恢复时,还原卡住了,一值没有进度,具体信息如下
部分错误日志,详细可查看附件
2015-06-16-10.43.05.817000+480 I105157209F627 LEVEL: Event
PID : 3300 TID : 1216 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : DMPAS
APPHDL : 0-26 APPID: *LOCAL.DB2.150616024232
AUTHID : PAS
EDUID : 1216 EDUNAME: db2agent (DMPAS) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::MarkDBBad, probe:10
STOP : AUTOMATIC FODC : DBMarkedBad : success
IMPACT : None
DATA #1 : String, 110 bytes
Check C:PROGRAMDATAIBMDB2DB2COPY1DB2FODC_BadPage_2015-06-16-10.42.51.262000 for diagnostic information.
2015-06-16-10.43.05.817000+480 I105157838F565 LEVEL: Severe
PID : 3300 TID : 1216 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : DMPAS
APPHDL : 0-26 APPID: *LOCAL.DB2.150616024232
AUTHID : PAS
EDUID : 1216 EDUNAME: db2agent (DMPAS) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::RestartDatabase, probe:202
MESSAGE : If 'DATALINK: file server not registered' appears above and
DATALINKS=NO, set DATALINKS=YES and try RESTART again
2015-06-16-10.43.05.817000+480 I105158405F456 LEVEL: Severe
PID : 3300 TID : 1216 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : DMPAS
APPHDL : 0-26 APPID: *LOCAL.DB2.150616024232
AUTHID : PAS
EDUID : 1216 EDUNAME: db2agent (DMPAS) 0
FUNCTION: DB2 UDB, base sys utilities, sqeApplication::AppStartUsing, probe:140
RETCODE : ZRC=0xFFFFFBEE=-1042
2015-06-16-10.43.05.817000+480 I105158863F491 LEVEL: Warning
PID : 3300 TID : 1216 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : DMPAS
APPHDL : 0-26 APPID: *LOCAL.DB2.150616024232
AUTHID : PAS
EDUID : 1216 EDUNAME: db2agent (DMPAS) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbCleanupBeforeTerm, probe:4930
DATA #1 : String, 41 bytes
Recovery failed, dirty pages not flushed.
附件:
db2diag.rar (1.95 MB)
db2diag.rar (1.86 MB)
日志文件.rar (34.22 KB)