2008-06-26-02.30.26.503000+480 I651705345H542 LEVEL: Error
PID : 2588 TID : 852 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : ORIONDB
APPHDL : 0-224 APPID: *LOCAL.DB2.080625183005
FUNCTION: DB2 UDB, database utilities, sqluCommitLoadEntryInHistoryFile, probe:20
MESSAGE : LOADID: 852.2008-06-26-02.30.06.051000.0 (2;804) Unable to update Load History File Entry rc =
DATA #1 : Hexdump, 4 bytes
0x490B48F0 : 8FF7 FFFF ....
2008-06-26-02.30.26.503000+480 I651705889H458 LEVEL: Error
PID : 2588 TID : 852 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : ORIONDB
APPHDL : 0-224 APPID: *LOCAL.DB2.080625183005
FUNCTION: DB2 UDB, database utilities, sqluCommitLoadEntryInHistoryFile, probe:21
MESSAGE : LOADID: 852.2008-06-26-02.30.06.051000.0 (2;804) Load History File Entry left in non-committed state.
/*在CLP下 LIST HISTORY 檢示過去LOAD歷程, 並出現下列錯誤訊息 */
C:\>db2 list history load since 20080625 for ORIONDB
sql2161n 無法修正損壞的回復歷程檔,指定動作失敗
/*處理方式 */
0) db2stop
1) 從DB存放的實體路徑下,找DB2RHIST.ASC
ex:
C:\DB2\NODE0000\SQL00002\
2) 將DB2RHIST.ASC及DB2RHIST.BAK全部rename
3) db2start
