PM27827: SUPPORT for SQL PA v4.1

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Placeholder
  Additional Symptom:
  1.  SQL Performance Analyzer Enhanced Explain Report is not
      correctly generated, user may see:
      SQL PA Analysis: EXPLAIN Output
      *-EXPLAIN   B-QLIMIT    C-QTRACE    D-SYSPRINT  E-ANLSQL
      KO2O1948I NO REPORT OUTPUT GENERATED FOR ANLREP   (OSQPSQPO)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 -   Classic Interface                        *
  *                 -   ICAT                                     *
  *                 -   Performance Warehouse users              *
  ****************************************************************
  * PROBLEM DESCRIPTION: - SQL PA v4.1 is not supported by       *
  *                        OMEGAMON XE for DB2PE.                *
  *                      - Existing SQL PA configuration cannot  *
  *                        be reused. It must be redefined in    *
  *                        ICAT.                                 *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF to add support.               *
  *                                                              *
  ****************************************************************
  PROBLEM SUMMARY:
  Add support of SQL PA v4.1 in Classic, PWH and ICAT.
  Reuse existing SQL PA configuration when submitting SQLPA Batch
  job.
  
  PROBLEM CONCLUSION:
  Ability to specify the SQL PA version to use in Classic,
  support for SQL PA v4.1 in ICAT.
  Ability to specify an existing SQLPA configuration instead of
  setting all the parameters in the ICAT panels.
  

Problem conclusion

Temporary fix

Comments

• Ability to specify the SQL PA version to use in Classic,
  support for SQL PA v4.1 in ICAT.
  Ability to specify an existing SQLPA configuration instead of
  setting all the parameters in the ICAT panels.
  
  KEYWORDS :
  VTAM CLASSIC SQLPA V4.1 PWH ICAT EXISTING CONFIGURATION
  

APAR Information

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

  PM27802

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

  UK63395

Modules/Macros

• DGO@SQPA DGOVMDSP DGOVPP0  DGOVPP1  DGOVPP2
  DGOVPP3  DGOVPP4  DGOVPP5  DGOZSQPA KDBZC07  KD2BHELP KD2CVAR2
  KD2DDICT KD2SBATO KD261HK  KD261HKA KD261HKB KD261PQ  KD261PR
  KD261SB2
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R510 PSY UK63395

     UP10/12/23 P F012

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.