PM72526: NEW FUNCTION

A fix is available

Subscribe

You can track all active APARs for this component.

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 number

    PM72526

  • 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

    2012-09-10

  • Closed date

    2013-01-25

  • Last modified date

    2013-03-04

  • 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.



Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for z/OS

Software version:

A10

Reference #:

PM72526

Modified date:

2013-03-04

Translate my page

Machine Translation

Content navigation