实例不能connect to
昨晚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
2011-12-07-14.44.29.812000+480 I62695H382 LEVEL: Warning
PID : 816 TID : 376 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : GYPAS
FUNCTION: DB2 UDB, data protection, sqlpgasn2, probe:2790
DATA #1 : <preformatted>
Incomplete log record at end, tailLsn 0000016C85B15FD8 recoveryLastPageLsn 0000016C85B15FFB
2011-12-07-14.44.30.031000+480 I63079H435 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:4000
MESSAGE : DIA2051W Forward phase of crash recovery has completed. Next LSN is
"0000016C85B15FD9".