昨晚delete大数据,早上挂起,后来force掉了,strat后connect to 实例没反应
之后用restart 命令,diag显示正在做crash recovery,完成后,出现next lsn...就一直不动了,具体日志见下面
现在是不是只能等它完成...??
请帮忙诊断一下,谢谢
2011-12-07-14.42.43.531000+480 I61204H361 LEVEL: Warning
PID : 816 TID : 2380 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : GYPAS
APPHDL : 0-8 APPID: *LOCAL.DB2.111207064243
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:30
MESSAGE : Crash Recovery is needed.
2011-12-07-14.42.43.765000+480 I61567H425 LEVEL: Warning
PID : 816 TID : 2380 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : GYPAS
APPHDL : 0-8 APPID: *LOCAL.DB2.111207064243
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:410
MESSAGE : Crash recovery started. LowtranLSN 0000016B07CCF7CE MinbuffLSN
0000016C7FBD8210
2011-12-07-14.42.43.765000+480 I61994H405 LEVEL: Warning
PID : 816 TID : 2380 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : GYPAS
APPHDL : 0-8 APPID: *LOCAL.DB2.111207064243
FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:2000
MESSAGE : Using parallel recovery with 3 agents 10 QSets 30 queues and 62 chunks
2011-12-07-14.44.24.843000+480 I62401H292 LEVEL: Warning
PID : 816 TID : 380 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgarl, probe:99
MESSAGE : INFO ONLY: Found an old page in the log file