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 | |
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 | |
10.5.0.1 |