Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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
DB2 Version 10.5 Fix Pack 9 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 FixList