home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC84499 Status: Closed

DB2 PAGE CLEANERS MAY RECEIVE SIG 11 WHEN 'DB2_USE_ALTERNATE_PAG
E_CLEANING=ON' AND 'SET WRITE SUSPEND/RESUME' IS USED

product:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problem description:
While the cleaner was handling the pages list, a 'set write 
suspend' came in and prevented pages to be written. 
This sent the cleaner into sleep. When it resumes after a 'set 
write resume' has been issued, it assumes the current list can 
only be a dirty list. 
Such that the page cleaner will trap with invalid pointer 
access. 
 
The trap file would show a stack trace similar to the one below 
 
.sqlbClnrCheckAndPause.fdpr.clone.1805__FP12SQLB_CLNR_CBPb + 
0x2B8 
sqlbClnrEntryPoint__FP12sqbPgClnrEdu + 0xD28 
sqlbClnrEntryPoint__FP12sqbPgClnrEdu + 0x24 
RunEDU__12sqbPgClnrEduFv + 0x34 
__9sqzEDUObjFv + 0x1F0 
sqloEDUEntry + 0x260 
 
It might vary because of the way the compiler generated the 
code. The real stack, however, should be the following (only 
showing the top part): 
 
sqlbClnrCheckAndPause() 
sqlbClnrFindWork() 
sqlbClnrEntryPoint() 
sqbPgClnrEdu::RunEDU()
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.1 Fix Pack 1                       * 
****************************************************************
Local Fix:
Disabling APC (setting DB2_USE_ALTERNATE_PAGE_CLEANING to NO)
available fix packs:
DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

Solution
First fixed in Version 10.1 Fix Pack 1.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
14.06.2012
13.11.2012
13.11.2012
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.1.0.1 FixList
10.5.0.1 FixList