A fix is available
APAR status
Closed as program error.
Error description
DB2 11 exploitation and other enhancements and fixes
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All users of SQL Performance Analyzer v4.2 * * * **************************************************************** * PROBLEM DESCRIPTION: * * 1- Forward fit of SQLPA v4.1 APARs: * * PM86179, * * PM96470, * * PM91793, * * PM93074, * * PI05372, * * PI05547. * * 2- Added confirmation prompt for drop * * of a real index. * * 3- New option for creation of real * * index for INCLUDE NULL KEYS. * * 4- Addition of ISPF message suffixes * * and minor message wording changes. * * 5- Title of the EEE Report was changed * * to the Plan Table Report. * * 6- Shortened some CLISTS and REXX * * executables to not extend past * * column 72 * * 7- New user parameters and system * * parameters panels. * * 8- Correction of potential error * * message when using ANLCSPA with * * corrupted profile variables * * * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** Code has been changed to correct this condition.
Problem conclusion
Apply the PTF for problem resolution.
Temporary fix
Comments
APAR Information
APAR number
PM97648
Reported component name
DB2 SQL PERF AN
Reported component ID
5697F5701
Reported release
420
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2013-09-23
Closed date
2014-01-27
Last modified date
2014-02-05
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI14536
Modules/Macros
ANL$$PRM ANLCBTCH ANLCDBRM ANLCHECK ANLCIGO ANLCLIMT ANLCMACR ANLCMIGR ANLCNUX ANLCORPT ANLCPARM ANLCRNS1 ANLCRNT1 ANLCSQLI ANLCSRCE ANLCSTA1 ANLCSYST ANLDCRE8 ANLDPRM ANLEEE ANLGPRM ANLICRE8 ANLMAIN ANLPAPPL ANLPBTCH ANLPCOLL ANLPCOL2 ANLPCONT ANLPDBRM ANLPDLST ANLPDRIX ANLPDYNE ANLPFILE ANLPHA1A ANLPHA17 ANLPHA2A ANLPHA20 ANLPHA23 ANLPHA27 ANLPHE00 ANLPHE10 ANLPHE11 ANLPHE12 ANLPHE13 ANLPHE14 ANLPHE15 ANLPHG20 ANLPHG21 ANLPHPE0 ANLPHPE1 ANLPHPE2 ANLPHPE3 ANLPHPE4 ANLPHPE5 ANLPHPE6 ANLPHPE7 ANLPHR00 ANLPHR01 ANLPHR02 ANLPHR03 ANLPHR04 ANLPHR05 ANLPHR06 ANLPHR07 ANLPHR08 ANLPHR09 ANLPHR10 ANLPHR11 ANLPHR12 ANLPHR13 ANLPHR14 ANLPHR15 ANLPHR16 ANLPHR17 ANLPHR18 ANLPHR19 ANLPHR20 ANLPHR21 ANLPHR22 ANLPHR23 ANLPHR25 ANLPHR26 ANLPHR28 ANLPHR29 ANLPHR31 ANLPHS00 ANLPHS01 ANLPHS02 ANLPHS03 ANLPHS04 ANLPHS05 ANLPHS06 ANLPHS07 ANLPHS08 ANLPHS09 ANLPHS10 ANLPHS11 ANLPHS12 ANLPHS13 ANLPHS14 ANLPHS15 ANLPHS16 ANLPHS17 ANLPHS18 ANLPHS19 ANLPHS20 ANLPHS21 ANLPHS22 ANLPHS23 ANLPHS24 ANLPHS25 ANLPHS26 ANLPHS27 ANLPHS28 ANLPHS29 ANLPHS30 ANLPHS31 ANLPHU00 ANLPHU01 ANLPHU02 ANLPHU03 ANLPHU04 ANLPHU05 ANLPHU06 ANLPHU07 ANLPHU08 ANLPHU09 ANLPHU10 ANLPHU11 ANLPHU12 ANLPHU13 ANLPHU14 ANLPHU15 ANLPHU16 ANLPHU17 ANLPHU18 ANLPHU19 ANLPHU20 ANLPHU21 ANLPHU22 ANLPHU23 ANLPHU24 ANLPHU25 ANLPIDX1 ANLPIDX2 ANLPJCL ANLPLAN ANLPLIM1 ANLPLIM2 ANLPMAIN ANLPNUXR ANLPNUXV ANLPNUX1 ANLPNUX2 ANLPORPT ANLPPARM ANLPPKGE ANLPPLAN ANLPPRME ANLPPRMS ANLPPRMU ANLPPRM1 ANLPPRM2 ANLPQMF ANLPQNO ANLPRCR ANLPREPT ANLPRER ANLPREST ANLPSPA ANLPSQLD ANLPSRCE ANLPSYST ANLPTAB1 ANLPTAB2 ANLPTBLS ANLPUPRM ANLQMF ANLSERV ANLSQLPA ANLTABS ANLTSO ANLWIF ANL00 ANL01 ANL02 ANL03 ANL04 ANL05 ANL06 ANL07 ANL08
| SC19414501 |
Fix information
Fixed component name
DB2 SQL PERF AN
Fixed component ID
5697F5701
Applicable component levels
R420 PSY UI14536
UP14/01/30 P F401
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":"4.2.0"}]
Document Information
Modified date:
04 January 2021