IBM Support

PM77016: D163370, D155628. SQLCODE -904 ISSUED FOR UTILITY REORG WHEN AN INVALID LOB IS ENCOUNTERED.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • D163370, D155628. SQLCODE -904 issued for utility REORG when
    an invalid LOB is encountered.
    RC00C900D0 shrlevel change reorg of directory lobspace sysdbdxa.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 10 for z/OS users of LOBs (Large     *
    *                 Objects) and the XML publishing functions.   *
    ****************************************************************
    * PROBLEM DESCRIPTION: This apar addresses the following two   *
    *                      problems.                               *
    *                                                              *
    *                      1. DB2 issued an SQLCODE -904 with      *
    *                         reason code rc00C900D0 for an        *
    *                         invalid LOB when the REORG Utility   *
    *                         is in progress reading a LOB.        *
    *                                                              *
    *                      2. An ABEND04E RC00E70005 can occur at  *
    *                         location DSNXRBND m666 when DB2      *
    *                         performs processing for the XML      *
    *                         publishing functions with LOBs.      *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    This apar addresses the following two problems.
    
    1. DB2 issues an SQLCODE -904 (SQLCODE904) with reason code
       rc00C900D0 indicating "an invalid LOB" when the REORG
       utility is reading a LOB.
    
    There are some situations when LOG records are not available to
    recover a LOB object during the log apply process.  During this
    time, DB2 can mark the LOB as being invalid and can issue an
    SQLCODE -904 when the LOB is referenced.  While the SQLCODE -904
    can be informative to some given application, it can prevent the
    the REORG utility from performing a diagnosis as it still needs
    to request an IFCID(340) record SQLCODE dump to proceed further.
    
    Therefore, on behalf of DB2 utilities, instead of issuing an
    SQLCODE -904 for this case, DB2 will generate a dump so that
    diagnosis can proceed immediately.
    
    
    2. An ABEND04E RC00E70005 can occur at location DSNXRBND M666
       when DB2 performs processing for an XML publishing function
       with LOBs.
    
    An ABEND04E RC00E70005 can occur at location DSNXRBND m666 while
    performing processing for an XML publishing function that is
    referencing a LOB object and encounters a "resource unavailable"
    condition.  For example, this can occur when DB2 attempts to
    open a LOB auxiliary index data set and encounters a "resource
    unavailable" with a rc00C20113 reason code (which indicates
    that the maximum number of open data sets has been reached).
    
    The abend occurs because DB2 fails to route the "resource
    unavailable" condition case correctly to the proper error
    handling routine to format the SQLCODE -904 in response.
    

Problem conclusion

  • For the first problem, the code in DB2 is modified to generate a
    dump instead of issuing an SQLCODE -904.  For the second
    problem, the code in DB2 is modified to avoid producing a dump.
    
    Additional Keywords: SQLCODE904 SQLLOB
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM77016

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-11-13

  • Closed date

    2013-01-15

  • Last modified date

    2013-02-04

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

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

    UK90961

Modules/Macros

  • DSNONLLE DSNOTCSO DSNXXGEN
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK90961

       UP13/01/30 P F301

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:
04 February 2013