PI88329: IMPROVEMENTS FOR TEST AND COMPARE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Utilize BIND EXPLAIN(ONLY) for TEST.
  Allow two collection ids for COMPARE.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM DB2 SQL Performance             *
  *                 Analyzer z/OS.                               *
  ****************************************************************
  * PROBLEM DESCRIPTION: Enhancements for TEST and COMPARE:      *
  *                      - Utilize BIND EXPLAIN(ONLY) for TEST.  *
  *                      - Allow two collection ids for COMPARE. *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• Apply the PTF to enable the enhancements.
  

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:

  UI52137

Modules/Macros

•    ANLBATCH ANLBNDGR ANLCFILE ANLCIGO  ANLCMIGR
  ANLCRNT1 ANLDPRM  ANLEEE   ANLGPRM  ANLGPST  ANLH03   ANLH04
  ANLH05   ANLH09   ANLJB001 ANLJB002 ANLJB003 ANLJCRE8 ANLMAIN
  ANLNUXD  ANLPH027 ANLPH028 ANLPICP  ANLPIDD  ANLPIQLR ANLPITP
  ANLPRCR  ANLPRER  ANLPTCM  ANLPTCMP ANLPTEX  ANLPTLD  ANLPTRP
  ANLPTSM  ANLPTTST ANLQMF   ANLSQLPA ANLTSO   ANL13    H1D0510J
  

Fix information

• Fixed component name

  DB2 SQL PERF AN

• Fixed component ID

  5697F5701

Applicable component levels

• R510 PSY UI52137

     UP17/12/02 P F712

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.