PM72526: NEW FUNCTION

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• New Function.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 10 for z/OS users of XML.            *
  ****************************************************************
  * PROBLEM DESCRIPTION: Processing of the deletion of unneeded  *
  *                      XML document versions is not directed   *
  *                      to be executed on an available zIIP.    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  For XML columns that support multiple XML versions, after a
  SQL UPDATE or DELETE, rows for multiple XML versions
  exist in the XML table space.  There is an asynchronously
  running SRB that deletes the rows for XML versions that
  are no longer needed.
  

Problem conclusion

Temporary fix

Comments

• With this APAR applied, DB2 10 for z/OS will direct z/OS to
  have the asynchronous processing to delete rows for XML
  versions, when running in an SRB enclave, executed on an
  available zIIP.**
  
  ** This provides only a general description of the type
  and portions of workloads that are eligible for execution
  on a zIIP Specialty Engine(SE). IBM authorizes
  customers to use the zIIP SE only to execute the
  processing of Eligible Workloads of specific Programs
  expressly authorized by IBM as specified in the  Authorized
  Use Table for IBM Machines  provided at
  www.ibm.com/systems/support/machine_warranties/machine_code/aut
  .html  ("AUT").   No other workload processing is
  authorized for execution on an SE.   IBM offers SEs at a
  lower price than General Processors/Central Processors
  because customers are authorized to use SEs only to
  process certain types and/or amounts of workloads as
  specified by IBM in the AUT.
  
  Additional keywords: XMLALL XMLUPDATE XMLDELETE XMLVERSION
  

APAR Information

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

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

  UK91203

Modules/Macros

•    DSNNOCLN DSNNXCMT DSNXINIT
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK91203

     UP13/02/12 P F302

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.