PH66702: SQLPA V5.2 INCLUDES INTERNAL-ONLY CODE IN ANLADMIN CLIST THAT SHOULD BE REMOVED.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• SQLPA V5.2 includes internal-only code in ANLADMIN Clist. This
  fix will remove it.
  
  SQL PA  PANEL MAY SHOW A VALUE INCONSISTENT WITH THE ONE SAVED
  IN THE PARM FILE FOR THE PARM (REPORTS) - LEVEL OF SQLPA
  REPORT
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 SQL Performance Analyzer        *
  ****************************************************************
  1. Performance degradation observed in SQL PA V5.2 compared to
  previous versions.
  2. Missing test report entries for temporal tables when
  EXPANSION_REASON is set to SB.
  3. Internal-use-only logic remained in the ANLADMIN CLIST.
  4. ISPF panel fields may show outdated or inconsistent values
  compared to saved PARM member.
  5. Condensed index report not displayed in some cases.
  6. "No statements found" when explaining a view after using
  "Tables" command on a package (FASTTBL=YES, VIEW).
  7. Missing help text for handling views in the TABLE Display
  panel (FASTTBL=YES).
  

Problem conclusion

• 1. Performance issues in SQL PA V5.2 were analyzed; decision was
  made to revert to a previous compiler version to ensure stable
  response times.
  2. Test report generation was corrected to properly include
  temporal tables when EXPANSION_REASON='SB'.
  3. Obsolete internal code was removed from ANLADMIN CLIST.
  4. ISPF panel logic was aligned with PARM file values to ensure
  consistency after update or redisplay.
  5. Logic for displaying the condensed index report was corrected
  to ensure consistent output.
  6. Resolved an issue where no SQL statements were shown when
  explaining a view after invoking the "Tables" command on a
  package.
  7. Added missing help text describing the behavior when working
  with views in the TABLE Display panel (FASTTBL=YES).
  

Temporary fix

Comments

• ×**** PE25/08/19 FIX IN ERROR. SEE APAR PH67813  FOR DESCRIPTION
  

APAR Information

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

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

  UO04240

Modules/Macros

• ANL$$PRM ANL04    ANLADMIN ANLBATCH ANLBPAM  ANLCAT   ANLCHECK
  ANLCLOB  ANLCMACR ANLCONV  ANLCSV   ANLDB2X  ANLDPRM  ANLEEE
  ANLGPRM  ANLGPST  ANLICRE8 ANLITST  ANLMAIN  ANLNUXD  ANLPADMN
  ANLPHI02 ANLPHPE2 ANLPICP  ANLPIDD  ANLPIQLR ANLPITP  ANLPLAN
  ANLPLIN  ANLPPRMU ANLPRCR  ANLPRER  ANLPTBLF ANLPTCM  ANLPTEX
  ANLPTLD  ANLPTRP  ANLPTSM  ANLPUOPT ANLQMF   ANLSERV  ANLSQ2M
  ANLSQLPA ANLSTER  ANLSTPR  ANLTABS  ANLTOHEX ANLTSO   ANLUNIC
  ANLUOPT  ANLVER8  ANLWIF   ANLWIFF
  

Fix information

• Fixed component name

  DB2 SQL PERF AN

• Fixed component ID

  5697F5701

Applicable component levels

• R520 PSY UO04240

     UP25/07/30 P F507

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.