IBM Support

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

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error 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()
    

Local fix

  • Disabling APC (setting DB2_USE_ALTERNATE_PAGE_CLEANING to NO)
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 10.1 Fix Pack 1                       *
    ****************************************************************
    

Problem conclusion

  • First fixed in Version 10.1 Fix Pack 1.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC84499

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-06-14

  • Closed date

    2012-11-13

  • Last modified date

    2012-11-13

  • APAR is sysrouted FROM one or more of the following:

    IC81831

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RA10 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
13 November 2012