A fix is available
APAR status
Closed as program error.
Error description
Running ANLPGME7 to relink ANLPGME7 into the SANLLOAD library as ANLPGM22, gets IEW2646W 4B07 ESD RMODE(24) CONFLICTS WITH USER-SPECIFIED RMODE(ANY) FOR SECTION ANLBPAM. This occurs because the job does not specify RMODE/AMODE, and the resulting ANLPGM22 module ends up with an RMODE 24.( 08646 ) MSGCEE0813S Insufficient storage. Also, under SQLPA using TSO the COST, EXPLAIN, LIMIT and TRACE reports may contain no data. The CEE0813S will show in the ISPF log in these cases. ADDITIONAL SYMPTOMS: Other external symptoms of the same storage shortage can be abends U4038 and / or U4039.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 SQL Performance Analyzer. * **************************************************************** * PROBLEM DESCRIPTION: Running ANLPGME7 to relink ANLPGME7 * * into the SANLLOAD library as ANLPGM22, * * gets IEW2646W 4B07 ESD RMODE(24) * * CONFLICTS WITH USER-SPECIFIED * * RMODE(ANY) FOR SECTION ANLBPAM. This * * occurs because the job does not specify * * RMODE/AMODE, and the resulting * * ANLPGM22 module ends up with an RMODE * * 24.( 08646 ) * * MSGCEE0813S Insufficient storage. * * Also, under SQLPA using TSO the COST, * * EXPLAIN, LIMIT and TRACE reports may * * contain no data. The CEE0813S will show * * in the ISPF log in these cases. * * ADDITIONAL SYMPTOMS: * * 1. erratic behavior of DBRMKEY per * * RMODE * * 2. Correct internal overlay of variable * * used to test for synonyms when corr * * name is also present. * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** Code has been changed to correct this condition.
Problem conclusion
APPLY the PTF.
Temporary fix
Comments
APAR Information
APAR number
PK24422
Reported component name
DB2 SQL PERF AN
Reported component ID
5697F5701
Reported release
220
Status
CLOSED PER
PE
NoPE
HIPER
YesHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2006-05-03
Closed date
2006-06-09
Last modified date
2006-07-10
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK15295 UK15296
Modules/Macros
ANLBPAM ANLPGME7 ANLPGME8 ANLPGM3N ANLPGM31 ANLPRC3C ANLPRC3R ANLPRE3C ANLPRE3R ANLPROCC ANLPROCR ANLQMF22 ANLQMF31
Fix information
Fixed component name
DB2 SQL PERF AN
Fixed component ID
5697F5701
Applicable component levels
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":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Platform":[{"code":"PF054","label":"z\/OS"}],"Version":"220"}]
Document Information
Modified date:
04 January 2021