A fix is available
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