PM44216: XML INSERT PAGE LATCH CONTENTION RELIEF FOR DB2 9 FOR Z/OS

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• XML INSERT PAGE LATCH CONTENTION RELIEF FOR DB2 9 FOR Z/OS
  

Local fix

• (none)
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 users who create tables with XML     *
  *                 columns.                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: PM44216 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:                                              *
  ****************************************************************
  In DB2 9 for z/OS, PM44216 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.  Tables 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.
  
  In DB2 10 for z/OS, APAR PM31487 adds the XML_RANDOMIZE_DOCID
  subsystem parameter but requires DB2 10 for z/OS new-function
  mode in order to create table with DOCIDs that are generated in
  random order.  APAR PM44216 allows tables with DOCIDs that are
  generated in random order to be created in DB2 10 for z/OS
  conversion mode after migration from DB2 9 for z/OS.
  
  PRECONDITIONING APAR CONSIDERATIONS:
  This APAR requires support from one or more preconditioning
  APARs according to the DB2 version and whether the environment
  is data sharing.
  
  * DB2 9 for z/OS: A prerequisite for this APAR is UK72542,
  the PTF for preconditioning APAR PM44210.  On DB2 for z/OS
  data sharing systems, apply PTF UK72542 to -all- V9 members
  of the group before applying the fix for this APAR to -any-
  member if all of the following are true:
  - DB2 is running in V9 new-function mode
  - You will set the XML_RANDOMIZE_DOCID parameter to YES
  - You will be creating tables with XML columns
  
  * DB2 10 for z/OS: A prerequisite for this APAR is UK68722,
  the PTF for preconditioning APAR PM31486.  On DB2 for z/OS
  data sharing systems, apply PTF UK68722 to -all- V10 members
  of the group before applying the fix for this APAR to -any-
  member if all of the following are true:
  - DB2 is not running in V10 new-function mode
  - You have set or will set the XML_RANDOMIZE_DOCID parameter
    to YES
  - You will be creating tables with XML columns
  
  * DB2 data sharing systems that are in coexistence mode during
  migration from DB2 9 for z/OS to DB2 10 for z/OS:  Apply PTF
  UK72542 to -all- V9 members of the group and apply PTF UK68722
  to -all- V10 members of the group before applying the fix for
  this APAR to -any- member if all of the following are true:
  - You have set or will set the XML_RANDOMIZE_DOCID parameter
    to YES
  - You will be creating tables with XML columns
  

Problem conclusion

Temporary fix

Comments

APAR Information

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

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

  UK73137 UK73138

Modules/Macros

• DSN@XAZP DSNDQWPZ DSNTIDXA DSNTIJUZ DSNTINST
  DSNTXAZP DSNWZIF9 DSNXICQ1 DSN6SYSP
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK73137

     UP11/11/08 P F111

• R910 PSY UK73138

     UP11/11/08 P F111

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.