A fix is available
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
01 August 2011