PH48614: PROPER ERROR HANDLING FOR PROMPT PANEL FOR SELECTING COLLECTION AND VERSION ON REMOTE LOCATION

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• There is an unhandled error on the panel 'ANLPSELC' (Prompt
  panel for selecting collection/package/version in Option 1.1).
  It happens for a prompt panel for the remote package location.
  If there is some problem on the remote site then SQLPA abends
  with the message - ISPS107 Required parm missing Not all
  required parameters were found for the TBTOP service. It has to
  be a proper error message and should not lead to exiting from
  SQLPA to the TSO screen.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: IBM Db2 SQL Performance Analyzer users       *
  *                 of components:                               *
  *                 - ISPF Process packages from the Db2 system  *
  *                 catalog                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1) The problem with error handling on   *
  *                      the prompt panel for selecting          *
  *                      collection id on a remote location      *
  *                      2) The problem with sorting on the      *
  *                      prompt panel for selecting a            *
  *                      collection id                           *
  *                      3) Wrong Db2 version in plan table      *
  *                      report for 'host var' section           *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  1) The problem with error handling on the prompt panel for
  selecting collection id on a remote location
  2) The problem with sorting on the prompt panel for selecting a
  collection id
  3) Wrong Db2 version in plan_table report for 'host var'
   section
  

Problem conclusion

• Code logic was corrected to fix the issues described.
  

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:

  UI83006

Modules/Macros

• ANL14    ANLEEE   ANLMAIN
  

Fix information

• Fixed component name

  DB2 SQL PERF AN

• Fixed component ID

  5697F5701

Applicable component levels

• R510 PSY UI83006

     UP22/10/28 P F210

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.