IBM Support

PM31487: XML INSERT PAGE LATCH CONTENTION RELIEF

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as new function.

Error description

  • XML insert page latch contention relief
    

Local fix

  • No Work Around
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 users who create tables with XML     *
    *                 columns.                                     *
    ****************************************************************
    * PROBLEM DESCRIPTION: PM31487 adds new subsystem parameter    *
    *                      XML_RANDOMIZE_DOCID which specifies     *
    *                      that the DOCIDs for tables that         *
    *                      are created with XML columns can        *
    *                      be generated in random order            *
    *                      instead of sequentially.                *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    PM31487 adds new subsystem parameter XML_RANDOMIZE_DOCID
    which indicates whether the DOCIDs for tables that are created
    with XML columns are to be generated in random order instead of
    sequentially.
    
    Tables with XML columns and DOCIDs generated in random order
    may have a performance benefit when concurrent users are
    inserting XML simultaneously.
    
    The new function takes effect when the DSNZPARM module is
    reassembled with XML_RANDOMIZE_DOCID=YES and put into effect.
    
    Tables created after XML_RANDOMIZE_DOCID is set to YES will
    get DOCIDs generated in random order.  Table created prior
    to applying this PTF, and tables created with
    XML_RANDOMIZE_DOCID set to NO will continue to have DOCIDs
    generated in sequential order.
    
    The default value of XML_RANDOMIZE_DOCID is NO, which
    provides the same behavior for generating DOCIDs that DB2
    has without applying this PTF.  In other words, applying
    this PTF will have no effect unless XML_RANDOMIZE_DOCID
    is set to YES.
    
    APAR PM31486 provides pre-conditioning support for PM31487.
    Users who create tables with XML columns in a data-sharing
    environment may be affected.
    
    Users who are affected are those who will be creating tables
    with XML columns in a data-sharing environment, and who also
    intends to use new function delivered in PM31487 that is
    enabled through a new system parameter (ZPARM):
    XML_RANDOMIZE_DOCID.
    
    Users who are affected by PM31486/PM31487 must apply
    pre-conditioning APAR PM31486 to all data-sharing
    members before this new function enabling APAR PM31487
    is applied to any data-sharing member.
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PM31487

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-01-28

  • Closed date

    2011-06-17

  • Last modified date

    2011-08-01

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

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

    UK68902

Modules/Macros

  • DSN@XAZP DSNDQWPZ DSNTIDXA DSNTIDXB DSNTIJUZ
    DSNTINST DSNTIP8  DSNTXAZH DSNTXAZP DSNWZIFA DSN6SYSP
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK68902

       UP11/07/06 P F107

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: 10.1

Reference #: PM31487

Modified date: 01 August 2011