home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
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