IBM Support

IZ63678: SET WRITE SUSPEND ON A BUSY DATABASE CAN HANG FOR A VERY LONG TIME, WAITING ON THE PAGECLEANERS GETTING PAUSED

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The SET WRITE SUSPEND session is waiting in the following stack:
    
    (6)  0xc00000000032f310  _semtimedop_sys + 0x30
    [/usr/lib/hpux64/libc.so.1]
    (7)  0xc00000000033d870  _semtimedop + 0xb0
    [/usr/lib/hpux64/libc.so.1]
    (8)  0xc00000000915ce10  sqloWaitEDUWaitPost + 0x350
    [/opt/IBM/db2/V8.1/lib64/libdb2e.so]
    (9)  0xc00000000a125170  _Z21sqlbPauseCleanerGroupP20SQ + 0x5f0
    [/opt/IBM/db2/V8.1/lib64/libdb2e.so]
    (10) 0xc00000000a125e50  _Z20sqlbPauseAllCleanersP12SQLB + 0x170
    [/opt/IBM/db2/V8.1/lib64/libdb2e.so]
    (11) 0xc00000000a1f6ae0  _Z16sqlbSuspendWritetP12SQLB_GLOBALS +
    0x350  [/opt/IBM/db2/V8.1/lib64/libdb2e.so]
    (12) 0xc00000000a1fc990  _Z17sqlbSetPoolChangeP5sqldaS0_P5sqlca
    + 0x1150  [/opt/IBM/db2/V8.1/lib64/libdb2e.so]
    ...
    
    Page cleaners still can need a long time to be paused on busy
    databases and bufferpools. This is a continuation of APAR
    IZ25687.
    

Local fix

  • Do not run SET WRITE SUSPEND, while there is load on the
    database.
    

Problem summary

  • USERS AFFETCED:
    All
    
    PROBLEM DESCRIPTION:
    See ERROR DESCRIPTION
    
    PROBLEM SUMMARY:
    See ERROR DESCRIPTION
    

Problem conclusion

  • Problem was first fixed in Version 9.1 Fix Pack 9.
    

Temporary fix

  • See LOCAL FIX.
    

Comments

APAR Information

  • APAR number

    IZ63678

  • Reported component name

    DB2 UDB ESE HP-

  • Reported component ID

    5765F4103

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-10-26

  • Closed date

    2010-04-16

  • Last modified date

    2010-04-16

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

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

    IZ63747 IC64170

Fix information

  • Fixed component name

    DB2 UDB ESE HP-

  • Fixed component ID

    5765F4103

Applicable component levels

  • R810 PSN

       UP

  • R820 PSN

       UP

  • R910 PSN

       UP

  • R950 PSN

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 April 2010