A fix is available
APAR status
Closed as new function.
Error description
DB2 SQLPA Support
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: User's of OMEGAMON XE for DB2 PE/DB2PM V310 * * Classic Interface (VTAM) with * * enabled PerformanceWarehouse * **************************************************************** * PROBLEM DESCRIPTION: OMEGAMON XE for DB2 PE/DB2PM provides * * an interface to SQL PA, which lets you * * analyze former and current SQL queries * * on DB2 subsystems being monitored by * * OMEGAMON XE for DB2 PE/DB2PM. * * The analysis results are available * * as SQL Enhanced Explain report, * * SQL Query Limits report, * * and SQL Query Trace information. * * * * More Details see Technote: * * Support for DB2 SQL Performance * * Analyzer for z/OS (SQL PA) * **************************************************************** * RECOMMENDATION: * ****************************************************************
Problem conclusion
Temporary fix
Comments
SYSMOD TITLE: Support for DB2 SQL Performance Analyzer KEYWORDS: SQL PA
APAR Information
APAR number
PK19027
Reported component name
OM XE DB2PE/PM/
Reported component ID
5655OPE00
Reported release
310
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2006-02-03
Closed date
2006-08-25
Last modified date
2006-09-05
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK17458
Modules/Macros
BPOMAB00 BPOMAXA0 BPOMGIO0 DGO@BTCH DGO@CHKB DGO@CONV DGO@CRDP DGO@DTA1 DGO@DTA2 DGO@DTA3 DGO@DTA4 DGO@DTA5 DGO@DTA6 DGO@DTA7 DGO@EXCP DGO@LOAD DGO@MAIN DGO@MIG1 DGO@MIG2 DGO@MT1 DGO@MT1I DGO@MT2 DGO@MT2I DGO@MT2J DGO@MT2K DGO@MT3 DGO@MT3I DGO@MT4 DGO@MT4I DGO@MT5 DGO@MT5I DGO@MT5J DGO@PC1 DGO@PC2 DGO@PC3 DGO@PC4 DGO@PRV1 DGO@PRV2 DGO@SAPI DGO@SCRD DGO@SP DGO@SQPA DGO@TBL DGO@TRG DGO@VW1 DGO@VW2 DGO@WRPA DGO@WRP2 DGO@WR2C DGO@WSTE DGOACMER DGOACREC DGOADYNA DGOASAVE DGOBMAIN DGOBMODL DGOBSELL DGODIDAT DGOEINIT DGOFPCRS DGOFPECO DGOFPE35 DGOFPSIC DGOFP000 DGOMAXA0 DGOMEDSN DGOMERPL DGOMGIO0 DGOPMICO DGOPMIC1 DGOSSAVE DGOSSWSR DGOVEEDI DGOVEEDT DGOVEPAI DGOVEXCP DGOVHMCD DGOVHM00 DGOVMSTR DGOVMTEX DGOVMTI DGOVPP3 DGOVSQLI DGOVUM00 DGOVWRPA DGOVWRP2 DGOVWR2C DGOYA100 DGOYMAIN DGOZBIND DGOZBTCH DGOZBTC2 DGOZCHKB DGOZCONV DGOZCOPY DGOZCRD DGOZCRDP DGOZCRDW DGOZDMDB DGOZDTA1 DGOZDTA2 DGOZDTA3 DGOZDTA4 DGOZDTA5 DGOZDTA6 DGOZDTA7 DGOZFL1 DGOZFL2 DGOZFL3 DGOZLOAD DGOZMIG1 DGOZMIG2 DGOZMTI DGOZMT1 DGOZMT1I DGOZMT2 DGOZMT2I DGOZMT2J DGOZMT2K DGOZMT3 DGOZMT3I DGOZMT4 DGOZMT4I DGOZMT5 DGOZMT5I DGOZMT5J DGOZPC1 DGOZPC2 DGOZPC3 DGOZPC4 DGOZPRV1 DGOZPRV2 DGOZRSDS DGOZSAPI DGOZSCRD DGOZSP DGOZSQLI DGOZSQPA DGOZSUB1 DGOZTBL DGOZTRG DGOZVW1 DGOZVW2 DGOZWFE DGOZWJE DGOZWSTE FPECHE35 FPECMAIN FPECQE35 FPECSORT FPECVCRS FPECVDDO FPECVICM FPECVOJS FPECVRMP FPECVRTZ FPECVSRD FPECVVCD FPECVVFN FPEMMAIN FPEUCBLD FPEUCXDL FPEUFIOI FPEUFIO2 FPEUFIXE FPEUFI24 FPEUFOCR FPEUFOC2 FPEUFUIS FPEUFUIT FPEUFWMX FPEUFYDY FPEUFYD2 FPEUHUGO FPEUPRNT FPEUT100 HKDB310J KD2DDICT KD260CV1 KD260HK KD260HOE KD260HSA KD260HSD KD260HX KD260H2 KD260MC2 KD260OS KD260PQ KD260SO3 KD5DDICT KD5SBATO KD531CCU KD531CUP KD531HUB KD531P4 KD5310RN KD5310SP KO2ALPHB KO2CALLI KO2CTHIS KO2CTHI2 KO2DQPIH KO2DQPII KO2DSQPI KO2EDD3I KO2ENU2I KO2HWLMB KO2MSQPO KO2OCMDB KO2ODINB KO2OEDSB KO2OEVCB KO2OINTB KO2OMGCB KO2OSQPB KO2OTCCB KO2OTHDB KO2OZM2B KO2PO00H KO2PO00I KO2PO01I KO2PO02I KO2PO03I KO2PO04I KO2PO05I KO2PWHCB KO2QPO00 KO2QPO01 KO2QPO02 KO2QPO03 KO2QPO04 KO2QPO05 KO2SQPIH KO2SQPII KO2SQPLH KO2SQPLI KO2TCALL KO2TQPIH KO2TQPII KO2TSQPI KO2VD KO2WGETB KO2XSY2S KO2XSY22 KO2ZEDD3 KO2ZMENU KO2ZSQL KO2ZSQLI KO2ZSQPI KO2ZSQPL
Fix information
Fixed component name
OM XE DB2PE/PM/
Fixed component ID
5655OPE00
Applicable component levels
R310 PSY UK17458
UP06/08/29 P F608
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":"310","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":"310","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
05 September 2006