DB2 - Problembeschreibung
Problem IC85449 | Status: Geschlossen |
LOG RETRIEVAL DOES NOT CHECK THE FORMAT VERSION AND CAN CAUSE ERROR DURING LATER CHECKING | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
When database starts retrieval of log we do not check the Format Version to make sure it is the same as the current. This can result in various error when we try and check the size of the log or further along, due to mismatch in the structures. The tool db2cklog should also check for this. db2diag.log: 2012-04-19-12.45.30.158090+120 I134579A369 LEVEL: Warning PID : 495636 TID : 2571 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 EDUID : 2571 EDUNAME: db2logmgr (SAMPLE) 0 FUNCTION: DB2 UDB, data protection services, sqlpgRetrieveLogFile, probe:4130 MESSAGE : Started retrieve for log file S0005686.LOG. 2012-04-19-12.45.32.422286+120 E134949A611 LEVEL: Error PID : 495636 TID : 2571 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 EDUID : 2571 EDUNAME: db2logmgr (SAMPLE) 0 FUNCTION: DB2 UDB, data protection services, sqlpgRetrieveLogVendor, probe:2516 DATA #1 : String, 107 bytes The actual log file size did not match the expected file size, retrying retrieve. Actual / Expected / File: DATA #2 : signed integer, 8 bytes 1245184 DATA #3 : signed integer, 8 bytes 8192 DATA #4 : String, 51 bytes /ap/fh/fhdba03/fh0310bh/sqlog/NODE0000/S0005686.TMP 2012-04-19-12.45.32.422678+120 E135561A562 LEVEL: Error PID : 495636 TID : 2571 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 EDUID : 2571 EDUNAME: db2logmgr (SAMPLE) 0 FUNCTION: DB2 UDB, data protection services, sqlpgRetrieveLogVendor, probe:2533 MESSAGE : ZRC=0x870F000A=-2029060086=SQLO_FEXS "file already exists" DIA8722C A file already exists. DATA #1 : String, 107 bytes An error was encountered moving the mismatched sized logfile to a saved file on the first retrieve attempt. 2012-04-19-12.45.32.422976+120 I136124A606 LEVEL: Warning PID : 495636 TID : 2571 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 EDUID : 2571 EDUNAME: db2logmgr (SAMPLE) 0 FUNCTION: DB2 UDB, data protection services, sqlpgRetrieveLogVendor, probe:2697 MESSAGE : ZRC=0x8710001D=-2028994531=SQLP_LERR "Fatal Logic Error" DIA8526C A fatal error occurred in data protection services. DATA #1 : String, 84 bytes An error was encountered in first retrieve attempt. Retry will be attempted. errId: DATA #2 : signed integer, 8 bytes 3778 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All Platforms * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to v9.7 Fixpack 7 or Higher * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows | |
Lösung | |
First Fixed in v9.7 Fixpack 7 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC88339 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 20.07.2012 30.10.2012 30.10.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP7 | |
Problem behoben lt. FixList in der Version | |
9.7.0.7 |