IBM Support

PM52463: 200MS DELAY AFTER THE RETURN FROM SYNCH WRITE OF LOB PAGES AND BEFORE STARTING UNLOCKS

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Customer reported 200ms NOT ACCOUNT TIME, this 200ms wait is for
    LOB write serialization (see details in PQ90075 ). We should
    classified as some category, instead of NOT ACCOUNT.
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 users in data sharing using LOBs.    *
    ****************************************************************
    * PROBLEM DESCRIPTION: 200 milliseconds wait during concurrent *
    *                      INSERTs into a LOB table space.         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    When concurrent applications update a LOB table space, 200
    milliseconds wait showed up under "NOT ACCOUNTED" category.
    

Problem conclusion

  • DB2 has been changed to reduce the wait time to 100 microseconds
    and categorize the wait time under "WAIT FOR OTHER I/O" using
    IFCID 127 & 128.
    

Temporary fix

  • *********
    * HIPER *
    *********
    

Comments

APAR Information

  • APAR number

    PM52463

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-11-17

  • Closed date

    2012-01-17

  • Last modified date

    2012-03-01

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

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

    UK75500 UK75501

Modules/Macros

  •    DSNB5SCM
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK75500

       UP12/02/02 P F202

  • R910 PSY UK75501

       UP12/02/02 P F202

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.



Document information

More support for: DB2 for z/OS

Software version: 910

Reference #: PM52463

Modified date: 01 March 2012


Translate this page: