A fix is available
APAR status
Closed as program error.
Error description
ABEND04E RC00E70005 DSNXEIST OFFEST0F86 due to a mismatching DMHE token during a SHTE LRU process .
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: DB2 10 for z/OS users of PREPARE statements * * with DB2 Dynamic Statement Cache and * * IFCID 316 or class 29 monitor trace. * **************************************************************** * PROBLEM DESCRIPTION: ABEND04E RC00E70005 * * at DSNXGRDS . DSNXEIST +F82 * * on a Dynamic Statement Cache * * LONG PREPARE. * **************************************************************** * RECOMMENDATION: * **************************************************************** When DB2 Dynamic Statement Cache (DSC) is active, the DSC LONG PREPARE process inserts the dynamically PREPARed statement in the global cache. When there is not enough space to insert a new statement, DB2 drives the LRU process to remove an old statement in the cache to have space for the new statement. When a statement is being removed from the cache, DB2 may write the IFCID 316 trace record. While tracing the IFCID 316 record, an SQLCODE can occur (such as a conversion error). This negative SQLCODE can affect the LONG PREPARE process of a new statement, which results in undoing the PREPARE of the statement. However, this statement is still advertently inserted in the cache without valid dependency information. The internal control block of the dependency information can be reused for another cached statement later. This inconsistency is detected on a subsequent statement invalidation process resulting in the reported abend.
Problem conclusion
DB2 code has been modified to not insert a statement in the cache, if an error was hit during the LRU process. RELATED KEYWORDS: 04E AB04E IFCID316 0316 OFFSETF82 STMTCACHE SQLDYNSTMTCACHE
Temporary fix
Comments
APAR Information
APAR number
PM77114
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-14
Closed date
2013-02-11
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:
UK91560
Modules/Macros
DSNGEGBK DSNGEPIS DSNXEDS1 DSNXESX
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RA10 PSY UK91560
UP13/02/27 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.
[{"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 March 2013