数据库异常关闭了以后,执行db2start正常,连接数据库时作crash recovery。开始还正常,但在Forward phase of creash recovery has completed后,迟迟没有出现crash recovery completed的消息,数据库也连不上,IO使用率也一直很高。我就不知道他在干什么。谁能给点帮助啊??
2007-12-13-14.52.58.363918+480 I9503981C352 LEVEL: Severe
PID : 548888 TID : 1 PROC : db2wdog 0 0
INSTANCE: db2inst3 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleCleanupResources, probe:20
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x2FF21810 : 870F 0042 ...B
2007-12-13-14.55.30.102285+480 I9504334C1505 LEVEL: Event
PID : 618510 TID : 1 PROC : db2start
INSTANCE: db2inst3 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 34 bytes
/home/db2inst3/sqllib/adm/db2star2
DATA #2 : Hexdump, 256 bytes
0x2FF1D7F8 : 2F68 6F6D 652F 6462 3269 6E73 7433 2F73 /home/db2inst3/s
0x2FF1D808 : 716C 6C69 622F 6164 6D2F 6462 3273 7461 qllib/adm/db2sta
0x2FF1D818 : 7232 004E 4F4D 5347 0000 0000 0000 0000 r2.NOMSG........
0x2FF1D828 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x2FF1D838 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x2FF1D848 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x2FF1D858 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x2FF1D868 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x2FF1D878 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x2FF1D888 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x2FF1D898 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x2FF1D8A8 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x2FF1D8B8 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x2FF1D8C8 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x2FF1D8D8 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x2FF1D8E8 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
2007-12-13-14.55.31.784422+480 E9505840C428 LEVEL: Warning (OS)
PID : 446686 TID : 1 PROC : db2spmrsy 0
INSTANCE: db2inst3 NODE : 000
APPHDL : 0-6
FUNCTION: DB2 UDB, oper system services, sqloopenp, probe:80
CALLED : OS, -, unspecified_system_function
OSERR : EEXIST (17) "Do not specify an existing file."
DATA #1 : File name, 39 bytes
/home/db2inst3/sqllib/spmlog/SPMLOG.LCF
2007-12-13-14.55.31.843506+480 E9506269C1028 LEVEL: Event
PID : 393406 TID : 1 PROC : db2star2
INSTANCE: db2inst3 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911
MESSAGE : ADM7513W Database manager has started.
START : DB2 DBM
DATA #1 : Build Level, 124 bytes
Instance "db2inst3" uses "32" bits and DB2 code release "SQL08024"
with level identifier "03050106".
Informational tokens are "DB2 v8.1.1.104", "s060120", "U805924", FixPak "11".
DATA #2 : System Info, 220 bytes
System: AIX P570_C6D_AIX1 3 5 00C6EC6D4C00
CPU: total:18 online:8 Threading degree per core:2
Physical Memory(MB): total:15872 free:7802
Virtual Memory(MB): total:37376 free:29300
Swap Memory(MB): total:21504 free:21498
Kernel Params: msgMaxMessageSize:4194304 msgMaxQueueSize:4194304
shmMax:2147483648 shmMin:1 shmIDs:131072 shmSegments:16
semIDs:131072 semNumPerID:65535 semOps:1024 semMaxVal:32767
semAdjustOnExit:16384
2007-12-13-14.55.42.279887+480 I9507298C368 LEVEL: Warning
PID : 430294 TID : 1 PROC : db2agent (CMISDB) 0
INSTANCE: db2inst3 NODE : 000 DB : CMISDB
APPHDL : 0-7 APPID: *LOCAL.db2inst3.071213065542
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:30
MESSAGE : Crash Recovery is needed.
2007-12-13-14.55.43.561833+480 I9507667C431 LEVEL: Warning
PID : 430294 TID : 1 PROC : db2agent (CMISDB) 0
INSTANCE: db2inst3 NODE : 000 DB : CMISDB
APPHDL : 0-7 APPID: *LOCAL.db2inst3.071213065542
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:410
MESSAGE : Crash recovery started. LowtranLSN 0000008072E6AA13 MinbuffLSN
00000082836222F2
2007-12-13-14.55.43.563698+480 I9508099C412 LEVEL: Warning
PID : 430294 TID : 1 PROC : db2agent (CMISDB) 0
INSTANCE: db2inst3 NODE : 000 DB : CMISDB
APPHDL : 0-7 APPID: *LOCAL.db2inst3.071213065542
FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:2000
MESSAGE : Using parallel recovery with 9 agents 7 QSets 56 queues and 187 chunks
2007-12-13-15.02.09.340681+480 I9508512C383 LEVEL: Warning
PID : 413906 TID : 1 PROC : db2loggw (CMISDB) 0
INSTANCE: db2inst3 NODE : 000 DB : CMISDB
FUNCTION: DB2 UDB, data protection, sqlpgasn2, probe:2790
DATA #1 : <preformatted>
Incomplete log record at end, tailLsn 000000828E37EFF7 recoveryLastPageLsn 000000828E37EFFB
2007-12-13-15.02.09.350687+480 I9508896C441 LEVEL: Warning
PID : 430294 TID : 1 PROC : db2agent (CMISDB) 0
INSTANCE: db2inst3 NODE : 000 DB : CMISDB
APPHDL : 0-7 APPID: *LOCAL.db2inst3.071213065542
FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:4000
MESSAGE : DIA2051W Forward phase of crash recovery has completed. Next LSN is
"000000828E37EFF8".