DB2 - Problembeschreibung
Problem IC79713 | Status: Geschlossen |
IF A LOG FULL IS HIT BY LOAD, BLANK PAGES COULD REMAIN IN BUFFER POOL CAUSING DATABASE TO BE MARKED BAD IF REUSED BY LOAD RESTART | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
If LOAD operation hits log full situation, it can leave some blank data pages in bufferpool after it rollback transaction. When subsequent LOAD RESTART operation reuses them, bad data page is encountered and database is marked as bad. The db2diag.log can have the following message showing blank PAGE HEADER: 20xx-xx-xx-xx.xx.xx.xxxxxx-xxx xxxxxxxxxxxxxxx LEVEL: Severe PID : 24000 TID : 47390123878720PROC : db2sysc 2 INSTANCE: xxxxxxxx NODE : 002 DB : xxxxxx APPHDL : 1-10058 APPID: xx.xxx.xx.xxx.xxxx.xxxxxxxxxxxx AUTHID : xxxxxxx EDUID : 67082 EDUNAME: db2linit 2 FUNCTION: DB2 UDB, data management, sqldReadTableInfo, probe:9416 RETCODE : ZRC=0x87040001=-2029780991=SQLD_BADPAGE "Bad Data Page" DIA8500C A data file error has occurred, record id is "". .................. 20xx-xx-xx-xx.xx.xx.xxxxxx-xxx xxxxxxxxxxxxxxx LEVEL: Severe PID : 24000 TID : 47390123878720PROC : db2sysc 2 INSTANCE: xxxxxxxx NODE : 002 DB : xxxxxx APPHDL : 1-10058 APPID: xx.xxx.xx.xxx.xxxx.xxxxxxxxxxxx AUTHID : xxxxxxx EDUID : 67082 EDUNAME: db2linit 2 FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging func, probe:0 MESSAGE : SQD PAGE HEADER DATA #1 : Hexdump, 22 bytes 0x00002B16758DC030 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00002B16758DC040 : 0000 0000 0000 ...... ............. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 LUW Version 9.7 Fix Pack 6 * **************************************************************** | |
Local-Fix: | |
The page is only corrupted in bufferpool and not on disk. Terminating all connections to the database, deactivating, and reactivating the database should make the problem go away. | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows | |
Lösung | |
Problem was first fixed in Version 9.7 Fix Pack 6 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 09.11.2011 11.06.2012 11.06.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP6 | |
Problem behoben lt. FixList in der Version | |
9.7.0.6 |