PH29911: SQL/PA HAVING FCSVCOMP Y WITHOUT THE CORRESPONDING DDNAME ANLCSVCF ABENDS WITH 4038.

Obtain the fix for this APAR.

APAR status

• Closed as unreproducible in next release.

Error description

• SQL/PA having FCSVCOMP Y without the corresponding ddname
  ANLCSVCF abends with 4038.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: IBM Db2 SQL Performance Analyzer             *
  *                 users of component                           *
  *                 - ISPF  COMPARE/TEST                         *
  *                 - BATCH COMPARE/TEST                         *
  *                 - ISPF Process package                       *
  *                 - ISPF Change the DB2 SQL PA parameters      *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1.Filters to TEST don't work;           *
  *                      2.Unexpected "Maximum reached" when     *
  *                        explaining packages;                  *
  *                      3.SQL/PA having FCSVCOMP Y without the  *
  *                        corresponding ddname ANLCSVCF abends  *
  *                        with 4038                             *
  *                      4.COST filters and percent change       *
  *                        doesn't work in TEST and COMPARE for  *
  *                        exponential values;                   *
  *                      5.Pressing enter on any parameter       *
  *                        panels jump back the navigation       *
  *                        to ANLPMAN3.                          *
  *                      6.DELIMIT=QUOTE doesn't work in         *
  *                        subselect                             *
  *                      7.COMPARE help panel doesn't contain    *
  *                        info for all fields.                  *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  1.Filters to TEST don't work;
  2.Unexpected "Maximum reached" when
    explaining packages;
  3.SQL/PA having FCSVCOMP Y without the
    corresponding ddname ANLCSVCF abends
    with 4038
  4.COST filters and percent change doesn't
    work in TEST and COMPARE for exponential
    values;
  5.Pressing enter on any parameter panels
    jump back the navigation to ANLPMAN3.
  6.DELIMIT=QUOTE doesn't work in subselect
  7.COMPARE help panel doesn't contain info
    for all fields.
  

Problem conclusion

Temporary fix

Comments

• Code logic was corrected to fix the issues described.
  
  
  Search Keywords:
  ANLCSVCF abends with 4038 ;
  Pressing enter on any parameter panels jump back the navigation
  to ANLPMAN3;
  message "Maximum reached" when  explaining packages.
  

APAR Information

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

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

  UI72296

Modules/Macros

• ANLBATCH ANLEEE   ANLMAIN  ANLPH028 ANLPICP  ANLPITP  ANLPPARM
  ANLPTCM  ANLPTRP  ANLSQLPA ANLTSO
  

Fix information

• Fixed component name

  DB2 SQL PERF AN

• Fixed component ID

  5697F5701

Applicable component levels

• R510 PSY UI72296

     UP20/10/29 P F010

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.