A fix is available
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 number
PM27827
Reported component name
OM XE DB2PE/PM
Reported component ID
5655OPE00
Reported release
510
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
YesSpecatt / New Function
Submitted date
2010-12-01
Closed date
2010-12-22
Last modified date
2011-03-16
APAR is sysrouted FROM one or more of the following:
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSAV2B","label":"IBM Db2 Buffer Pool Analyzer for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCT4H5","label":"IBM Tivoli OMEGAMON XE for Db2 PE \/ PM \/ BPA"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
16 March 2011