IBM Support

IZ83001: TRANSACTIONS ON PRIMARY ARE BLOCKED LONGER THAN NORMAL WHEN STANDBY REUSES A PARTIAL LOG FILE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • On HADR standby, if a partial log needs to be reused, then
    transactions on primary are blocked longer than normal.
    
    These transactions on primary are blocked in "Commit Active"
    state until the log extention finishes.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * HADR users on all platforms                                  *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Without this APAR, customer is exposed to the issue as       *
    * described in the "ERROR DESCRIPTION" section.                *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 9.1, Fixpack 10.                      *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 Version 9.1, Fixpack 10.
    
    With the fix, slowness will not happen when standby is reusing
    
    a partial log file.
    

Temporary fix

Comments

  • the Release of this APAR should be 910. But the PMR set this
    field incorrectly, and I made this mistake after getting these
    
    
    data from PMR.
    I am going to reopen another one.
    

APAR Information

  • APAR number

    IZ83001

  • Reported component name

    DB2 UDB ESE SOL

  • Reported component ID

    5765F4102

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-08-17

  • Closed date

    2011-06-15

  • Last modified date

    2011-06-15

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

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

    IZ84688 IC71335

Fix information

  • Fixed component name

    DB2 UDB ESE SOL

  • Fixed component ID

    5765F4102

Applicable component levels

  • R910 PSN

       UP

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

Document Information

Modified date:
06 October 2021