DB2 - Problembeschreibung
Problem IC82358 | Status: Geschlossen |
After a crash during shutdown while truncating a log file, crash recovery may fail due to truncated log. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 | |
Problembeschreibung: | |
Due to a timing hole where the log file is truncated during a crash the LFH with the SQLPG_HFLAG2_GHCK_TRUNC_LOGFILE flag is not written. Errors produced in the db2diag.log should be similar to the following 2012-03-16-04.52.29.626688-240 I2164616A373 LEVEL: Error PID : 373150 TID : 1 PROC : db2loggr (DB2INST1) 0 INSTANCE: db2inst1 NODE : 000 FUNCTION: DB2 UDB, data protection services, sqlpgInitRecoverable, probe:5520 DATA #1 : <preformatted> Unexpected size for S0012345.LOG, PageCount 4074 ExtSize 7000 actualFileSize 16687104 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Users are only affected if the system crashes. * **************************************************************** * PROBLEM DESCRIPTION: * * Due to a timing hole where the log file is truncated during * * a * * crash the LFH with the SQLPG_HFLAG2_GHCK_TRUNC_LOGFILE flag * * is * * not written. * * * * Errors produced in the db2diag.log should be similar to the * * following * * * * 2012-03-16-04.52.29.626688-240 I2164616A373 LEVEL: Error * * PID : 373150 TID : 1 PROC : db2loggr (DB2INST1) 0 * * INSTANCE: db2inst1 NODE : 000 * * FUNCTION: DB2 UDB, data protection services, * * sqlpgInitRecoverable, probe:5520 * * DATA #1 : <preformatted> * * Unexpected size for S0012345.LOG, PageCount 4074 ExtSize * * 7000 * * actualFileSize 16687104 * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 LUW' version 9.1 fp12 * **************************************************************** | |
Local-Fix: | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC83245 IC83247 IC87852 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 29.03.2012 24.07.2012 24.07.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.1.FP12 | |
Problem behoben lt. FixList in der Version | |
9.1.0.12 |