DB2 - Problembeschreibung
Problem IC99403 | Status: Geschlossen |
POSSIBLE CRASH (PANIC) OF DB2 IN SQLBREMOVEPAGEFROMTHISDIRTYLIST WITH MESSAGE "DEQUEUE W/0 PAGES ON DL" | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
Under rare timing conditions, DB2 database might abend (panic) with error message similar to the following one: 2014-01-01-12.00.00.000000-240 I2688414A4008 LEVEL: Severe PID : 21954944 TID : 213569 PROC : db2sysc INSTANCE: db2inst1 NODE : 001 DB : SAMPLE APPHDL : 1-001 APPID: 172.0.0.1.35071.140101110419 AUTHID : DB2INST1 EDUID : 213569 EDUNAME: db2agent (SAMPLE) FUNCTION: DB2 UDB, buffer pool services, sqlb_deq, probe:642 DATA #1 : String, 179 bytes ASSERTION FAILED!!! ASSERTION EXPRESSION: (curDL->num_dirty > 0) [...] MESSAGE : dequeue w/0 pages on DL Last function on the stack will be: sqlbRemovePageFromThisDirtyList | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 version 10.5 and Fix Pack 4 or higher. * **************************************************************** | |
Local-Fix: | |
Enable alternative page cleaning: db2set DB2_USE_ALTERNATE_PAGE_CLEANING=ON | |
verfügbare FixPacks: | |
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows | |
Lösung | |
Problem was first fixed in DB2 version 10.5 and Fix Pack 4. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 17.02.2014 08.09.2014 08.09.2014 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.4 |