DB2 - Problem description
Problem IC99216 | Status: Closed |
POSSIBLE CRASH (PANIC) OF DB2 IN SQLBREMOVEPAGEFROMTHISDIRTYLIST WITH MESSAGE "DEQUEUE W/0 PAGES ON DL" | |
product: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problem description: | |
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 Summary: | |
**************************************************************** * USERS AFFECTED: * * All platforms * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 version 10.1 Fix Pack 4 or higher. * **************************************************************** | |
Local Fix: | |
Enable alternative page cleaning: db2set DB2_USE_ALTERNATE_PAGE_CLEANING=ON | |
available fix packs: | |
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows | |
Solution | |
First fixed in DB2 version 10.1 Fix Pack 4. | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC99403 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 06.02.2014 02.06.2014 02.06.2014 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
10.1.0.4 |