PK59885: STARTUP CLIST (ANLCANLI) HANGS WHEN MEMBER <SSID>ISPF IS MISSINGFROM THE SANLSAMP LIBRARY, WHERE, <SSID> IS THE DB2 SSID NAME.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The startup CLIST (ANLCANLI) hangs when the member <ssid>ISPF is
  missing from the SANLSAMP library, where, <ssid> is the DB2
  subsystem id.
  ADDITIONAL SYMPTOM:
  1. When selecting primary command TABLES to display all the DB2
     tables referenced the last column (STM) which is the total
     number of SQL statements is displayed incorrectly.
  2. ISPF table showing the DB2 tables used shows an incorrect
     total number of statements (original symptom)
  3. ISPF hangs when SANLSAMP member <ssid>ISPF is missing. This
     APAR prevents ISPF from hanging and instead provides a
     message to the user in respect to the missing member.
  4. In BATCH mode the Easy Explain function terminated with
     errors when either the PREDICATE and/or COST explain tables
     are missing. The Easy Explain function no longer terminates
     if the PREDICATE and/or COST explain tables are missing
     instead the process continues and a message is given.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of SQL Performance Analyzer.           *
  ****************************************************************
  * PROBLEM DESCRIPTION: The startup CLIST (ANLCANLI) hangs when *
  *                      the member <ssid>ISPF is  missing from  *
  *                      the SANLSAMP library, where, <ssid> is  *
  *                      the DB2 subsystem id.                   *
  *                      ADDITIONAL SYMPTOM:                     *
  *                      1. When selecting primary command       *
  *                         TABLES to display all the DB2 tables *
  *                         referenced the last column (STM)     *
  *                         which is the total number of SQL     *
  *                         statements is displayed incorrectly. *
  *                      2. ISPF table showing the DB2 tables    *
  *                         used shows an incorrect total number *
  *                         of statements (original symptom)     *
  *                      3. ISPF hangs when SANLSAMP member      *
  *                         <ssid>ISPF is missing. This APAR     *
  *                         prevents ISPF from hanging and       *
  *                         instead provides a message to the    *
  *                         user in respect to the missingg      *
  *                         member.                              *
  *                      4. In BATCH mode the Easy Explain       *
  *                         function terminated with errors when *
  *                         either the PREDICATE and/or COST     *
  *                         explain tables are missing. The Easy *
  *                         Explain function no longer terminate *
  *                         if the PREDICATE and/or COST explain *
  *                         tables are missing instead the       *
  *                         process continues and a message      *
  *                         is given.                            *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• Apply the PTF.
  

Temporary fix

Comments

APAR Information

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

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

  UK33957

Modules/Macros

•    ANLCIGO  ANLMAIN  ANLSQ2M
  

Fix information

• Fixed component name

  DB2 SQL PERF AN

• Fixed component ID

  5697F5701

Applicable component levels

• R320 PSY UK33957

     UP08/02/27 P F802

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.