Direct links to fixes
db2pe.agent.v5.5.0.0.zLinux.E9205.tar.gz
db2pe.agent.v5.5.0.0.win.E9205.zip
5.5.0-TIV-KD5-LP0004.zip
5.5.0-TIV-KD5-LP0004.tar
5.5.0-TIV-KD5-FP0015.zip
5.5.0-TIV-KD5-FP0015.tar.gz
5.5.0-TIV-KD5-FP0015.README
5.5.0-TIV-KD5-FP0014.tar.gz
5.5.0-TIV-KD5-FP0014.zip
5.5.0-TIV-KD5-FP0014.README
db2pe.client.v5.5.0.0.8710.win64.OpenJRE11.0.24.8.zip
5.5.0-TIV-KD5-FP0013.zip
5.5.0-TIV-KD5-FP0013.tar.gz
5.5.0-TIV-KD5-FP0013.README
5.5.0-TIV-KD5-FP0012.zip
5.5.0-TIV-KD5-FP0012.tar.gz
5.5.0-TIV-KD5-FP0012.README
db2pe.client.v5.5.0.0.8709.win64.zip
5.5.0-TIV-KD5-FP0011.zip
5.5.0-TIV-KD5-FP0011.tar.gz
5.5.0-TIV-KD5-FP0011.README
db2pe.client.v5.5.0.0.8708.win64.zip
5.5.0-TIV-KD5-FP0010.zip
5.5.0-TIV-KD5-FP0010.tar.gz
5.5.0-TIV-KD5-FP0010.README
db2pe.client.v5.5.0.0.8707.win64.zip
5.5.0-TIV-KD5-FP0009.zip
5.5.0-TIV-KD5-FP0009.tar.gz
5.5.0-TIV-KD5-FP0009.README
db2pe.client.v5.5.0.0.8706.win64.zip
5.5.0-TIV-KD5-FP0008.zip
5.5.0-TIV-KD5-FP0008.tar.gz
5.5.0-TIV-KD5-FP0008.README
db2pe.client.v5.5.0.0.8705.win64.zip
5.5.0-TIV-KD5-FP0007.README
5.5.0-TIV-KD5-FP0007.zip
5.5.0-TIV-KD5-FP0007.tar.gz
5.5.0-TIV-KD5-LP0003.zip
5.5.0-TIV-KD5-LP0003.tar
5.5.0-TIV-KD5-FP0006.zip
5.5.0-TIV-KD5-FP0006.tar.gz
5.5.0-TIV-KD5-FP0006.README
db2pe.client.v5.5.0.0.8704.win64.zip
5.5.0-TIV-KD5-LP0002.zip
5.5.0-TIV-KD5-LP0002.tar
5.5.0-TIV-KD5-FP0005.zip
5.5.0-TIV-KD5-FP0005.tar.gz
5.5.0-TIV-KD5-FP0005.README
APAR status
Closed as program error.
Error description
OMPE V550 Q4 Enhancements
Local fix
na
Problem summary
**************************************************************** * USERS AFFECTED: - Enhanced 3270 User Interface. * * - Batch RECTRACE report * * - Batch STATISTICS report * * - Batch SYSPARMS report * * - Performance Database (PDB) * * - Spreadsheet Input Data Generator (CSV) * * - Batch Collect Report Data (CRD) * * - Classic Interface * * - Tivoli Enterprise Portal (TEP) * **************************************************************** * PROBLEM DESCRIPTION: Major enhancements: * * 1. Support for new IFCID 3 data section * * QLLL (Longest lock/latch waiter) in * * Batch ACCOUNTING and additional * * QLLL currency in RECTRACE reports. * * 2. Missing support for IRLM fields * * in Batch STATISTICS report. * * 3. IRLM locking data fields from * * DSNDQTGS and DSNDQTXA macro are * * missing in Batch RECTRACE report. * * 4. Missing support for Log Manager * * ASYNC Lock Duplexing metrics in * * Batch STATISTICS report. * * 5. Missing support for new IFCID 1 * * DBAT counters in Batch RECTRACE and * * STATISTICS reports. * * 6. Batch CRD does not support mixed * * case values (e.g. CORRID). * * * * Other enhancements and fixes: * * 1. Abort count missing from KDPCPTDI * * 2. Db2 message display missed last row * * 3. Missing E3270UI 2023 help KDPHLP23. * * 4. Missing Db2 fields from Thread * * History detail workspaces. * * 5. Log manager counters from DSNDQJST * * macro missing in Batch RECTRACE * * report. * * 6. New Db2 13 PACKAGE_DEPENDENCY_LEVEL * * ZPARM not displayed on Classic and * * E3270UI. * * 7. N/P displayed for E3270UI SQL Cache * * displays with 0 executions. * * 8. Missing explanation for classic * * panel ZSQL. * * 9. E3270UI Interval Statistics reset * * situation misbehaving. * * 10. Abort field is missing in threads * * display. * * 11. Incorrout E3270UI DDF workspaces * * KDPQLST and KDPDQDST. * * 12. Various ZPARMs missing in * * Batch SYSPARMS report. * * 13. Description of QLSTCNVT has not * * been updated. * **************************************************************** * RECOMMENDATION: Apply the provided PTF. * **************************************************************** Major enhancements: 1. Support for new IFCID 3 data section QLLL (Longest lock/latch waiter) in Batch ACCOUNTING reports, PDB and CSV. Furthermore Wait type, ACE addresses and Rollup ID are added to Batch RECTRACE report for QLLL data section. 2. Batch STATISTICS report, PDB and CSV support missing IRLM metrics as per Db2 PI93817/UI54732. 3. New counters are added to IFCID 2 Data sharing locking data and IFCID 2 and 3 Locking data Batch RECTRACE report blocks. 4. Batch STATISTICS reports,PDB and CSV components do not support the following Log Manager ASYNC Lock Duplexing counters: QJSTDPXT, QJSTDPXN, QJSTCDDS, QJSTSYCW, QJSTSYCF. 5. Batch RECTRACE and STATISTICS reports as well as PDB/CSV components do not support the following new DBAT counters: QDSTDBPQ, QDSTMDPQ. Batch RECTRACE is not showing the serviceability fields QWP4POOLCONTRACTION and QWP4PRLD. 6. Batch CRD job abends with syntax error when values for TRACE commands are entered in the mixed case letters. Other enhancements and fixes: 1. Thread Abort count field is not displayed on CICS/Db2 embedded workspace KDPCPTDI. 2. E3270UI Db2 messages shows 999 rows instead of 1000 rows. 3. KDPHLP23 for E3270UI 2023 enhancements is missing. 4. Missing Db2 QWAC and QWAX fields from Thread History detail workspaces. 5. New counters are added to IFCID 1 Log manager report block in Batch RECTRACE report. 6. New Db2 V13 ZPARM PACKAGE_DEPENDENCY_LEVEL has to be shown in Classic ZPAPP and E3270UI workspaces. 7. N/P displayed on E3270UI SQL cache when execution is 0, thus not allowing proper filtering/sorting. 8. No explanation for DBRM and stmtno from previous commit. 9. Interval reset situation is not triggered when 1 Hour value is used in the situation. 10. Need to add Abort field to threads display in TEP 11. No data when MORE button is pressed on E3270UI DDF detail workspace KDPQLST or KDPDQDST with 24x80 screen size 12. Following Zparm counters are missing in Batch SYSPARMs report: QWP4QAFNAT, QWP4QADUCE, QWP4QAWBAL, QWP4RTNP, QWP4STPGS, QWP4IXMCS, QWP4MFAT, QWP4LIRO, QWP4PKGDEPLVL 13. Due to new DDF processing, the description of QLSTCNVT has to be changed.
Problem conclusion
Major enhancements: 1. Support for IFCID 3 data section QLLL (Longest lock/latch waiter) in Batch ACCOUNTING reports, PDB and CSV. Furthermore Wait type, ACE addresses and Rollup ID are added to Batch RECTRACE report for QLLL data section. 2. Added support in Batch STATISTICS, PDB and CSV components for IRLM metrics added by PI93817/UI54732. 3. Additional IRLM locking data counters are now displayed in RECTRACE report. 4. Added Log Manager ASYNC Lock Duplexing counter support in Batch STATISTICS and RECTRACE reports as well as PDB and CSV components. Subject Db2 fields: QJSTDPXT, QJSTDPXN, QJSTCDDS, QJSTSYCW, QJSTSYCF. 5. Added support in Batch RECTRACE, Batch STATISTICS, PDB and CSV components for new DBAT counters QDSTDBPQ, QDSTMDPQ. Added serviceability fields QWP4POOLCONTRACTION, QWP4PRLD to Batch RECTRACE report. 6. Batch CRD is now supporting mixed case letters for Trace parameters. Other enhancements and fixes: 1. Display abort count in KDPCPTDI workspace. 2. Fixed Db2 message display. 3. Add KDPHLP23 workspace. 4. add QWAC and QWAX new fields to thread detail workspaces. 5. Additional zHyperlinklog and Asynchronous duplexing counters are now displayed in Batch RECTRACE report. 6. Added Db2 V13 ZPARM PACKAGE_DEPENDENCY_LEVEL to Classic and E3270UI ZPARM display. 7. Display 0 instead of N/P when execution is 0. 8. Added explanation for possible incorrect DBRM and stmtno on classic call detail ZSQL. 9. Fix Interval statistics reset and optimize Interval statistics by removing requirement of Snapshot History setup. 10. Abort field added to 'Plans' and 'All Threads Connected to DB2' summary workspaces on TEP. 11. Fixed incorrout from E3270UI DDF System Statistics and DDF Location detail workspaces. 12. Missing Zparm counters are added to Batch Sysparm report. 13. Description of QLSTCNVT has been updated. Besides the enhancements and fixes mentioned above, this PTF delivers the forward-fit of the OMEGAMON Db2 PE 5.4.0 functions shipped with UI82806/PH47423. Keywords: KCPTASDI DSNDQTGS DSNDQTXA Rectrace DSNDQLLL KDPMSGS KDPHACCT KDPHLP23 KDPHLWAT KDPHWAIT KDPTHDA2 KDPTHRD3 QWAC_WORKFILE_MAX QWAC_WORKFILE_CURR QWACWCUR QWAC_PROFMON_PID QWAC_PROFMON_TYPE QWACPTYP QWAC_ACCEL_ELIG_ELA QWAC_ACCEL_ELIG_CP QWAC_ACCEL_ELIG_SE QWACAECP QWACAESE QWAX_PIPE_WAIT QWAX_PIPEWAIT_COUNT QWAX_LOBCOMP_WAIT QWAX_LOBCOMP_COUNT QWAXPIPC QWAXLOBW QWAXLOBC QLLLTYP QLLLRUID QLLLRACE QLLLSACE QLLLPIACE QJSTDPXT QJSTDPXN QJSTCDDS QJSTSYCW QJSTSYCF ZPAPP ZPAPPH KDPPZAPP KDPPZPRM KDPZAPPL KDPZPARM ZSQLH KDPDSQLS KDPSSQLS KDPDYNST KDPSTAST Interval Statistics TEP Abort field IRLM QTXA QTGS PI93817 UI54732 QJSTDPXT QJSTDPXN QJSTCDDS QJSTSYCW QJSTSYCF QDSTDBPQ QDSTMDPQ QWP4POOLCONTRACTION QWP4PRLD QWP4QAFNAT QWP4QADUCE QWP4QAWBAL QWP4RTNP QWP4STPGS QWP4IXMCS QWP4MFAT QWP4LIRO QWP4PKGDEPLVL
Temporary fix
Comments
APAR Information
APAR number
PH48556
Reported component name
OM XE DB2PE/PM
Reported component ID
5655OPE00
Reported release
550
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2022-08-09
Closed date
2023-01-18
Last modified date
2023-02-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI90100
Modules/Macros
BPOQSRGB DGOAACUM DGOABFGE DGOABFGP DGOABLOG DGOABORD DGOABORE DGOABSGE DGOABSGP DGOACALC DGOACFGE DGOACFGP DGOACMER DGOACOMP DGOACREC DGOACREP DGOACSGE DGOACSGP DGOACTFT DGOADFGE DGOADFGP DGOADNOR DGOADSGE DGOADSGP DGOAEX20 DGOAEXIT DGOAFGBP DGOAFGEN DGOAFILE DGOAFLAT DGOAFORM DGOAIREC DGOAIREP DGOALFGE DGOALFGP DGOALSGE DGOALSGP DGOALUMP DGOAMSEP DGOAMTRC DGOAPARC DGOAQKEY DGOARCAL DGOAREDB DGOAREDC DGOAREDD DGOAREDG DGOAREDI DGOAREDM DGOAREDP DGOAREDR DGOAREDX DGOASAVE DGOATOPR DGOATOPS DGOATPRC DGOATPRS DGOATRAC DGOATREC DGOAUPDB DGOAZMER DGOAZREC DGOBARAL DGOBARDD DGOBARLK DGOBARLO DGOBARPK DGOBARPO DGOBARPT DGOBARRI DGOBARRL DGOBARSH DGOBARSP DGOBARSQ DGOBARTE DGOBARTM DGOBATAL DGOBATDD DGOBATLK DGOBATLO DGOBATPK DGOBATPO DGOBATPT DGOBATRI DGOBATRL DGOBATSH DGOBATSP DGOBATSQ DGOBATTM DGOBGENL DGOBSRAL DGOBSRBN DGOBSRCM DGOBSRDD DGOBSRLG DGOBSRLK DGOBSRLO DGOBSROC DGOBSRPO DGOBSRQP DGOBSRRI DGOBSRSH DGOBSRSP DGOBSRSQ DGOBSRSS DGOBSRTM DGOBSTAL DGOBSTBN DGOBSTCM DGOBSTDD DGOBSTLG DGOBSTLK DGOBSTLO DGOBSTOC DGOBSTPO DGOBSTQP DGOBSTRI DGOBSTSH DGOBSTSP DGOBSTSQ DGOBSTSS DGOBSTTM DGOER000 DGOFECAL DGOFEDAT DGOFEDPM DGOFEPKG DGOFPDAT DGOFPDPM DGOFPNMP DGOFPRIC DGOFPRPC DGOFS254 DGOFSBGL DGOFSDST DGOFSJST DGOFUCA1 DGOFUCAL DGOFUFAC DGOFUFDI DGOIPAIR DGOLREDC DGOLTRAC DGOLXRES DGONF250 DGONF260 DGONF270 DGONF280 DGONF310 DGONF320 DGONF330 DGONF340 DGONF350 DGONF360 DGONFIFA DGONFILE DGONFISE DGONFLST DGONFTXA DGONFWP1 DGONFWP9 DGONFWPA DGONTRAC DGOPAB10 DGOPAC10 DGOPAC20 DGOPACNV DGOPSB10 DGOPSB20 DGOPSC10 DGOPSC20 DGOPSCNV DGORAEXT DGORASCN DGORCRE2 DGORCREC DGORCREP DGORDIST DGORINEX DGORIREC DGORIREP DGOROADB DGORPACC DGORPCAP DGORPEXI DGORPHIL DGORPHVA DGORPIOA DGORPMIN DGORPPAG DGORPPAR DGORPRID DGORPSCA DGORPSOR DGORPSUS DGORPUDF DGORRCAP DGORRCOM DGORRDAT DGORRDDF DGORREXI DGORRHIL DGORRHVA DGORRIOA DGORRLOC DGORRMIS DGORRSOR DGORRSQL DGORRTHR DGORSRBY DGORUACC DGORUSUM DGORUWRK DGORZREP DGOSABGL DGOSACMG DGOSACU2 DGOSACUM DGOSAPAW DGOSAPTG DGOSAPTS DGOSATGS DGOSATXA DGOSBDDF DGOSBGBP DGOSBGEN DGOSBLKX DGOSBORD DGOSBORE DGOSCGBP DGOSCGEN DGOSCREC DGOSDDDF DGOSDGBP DGOSDGEN DGOSFILE DGOSFMTQ DGOSFMTR DGOSFMTS DGOSFMTT DGOSGENC DGOSGENS DGOSI225 DGOSLGBP DGOSLGEN
Fix information
Fixed component name
OM XE DB2PE/PM
Fixed component ID
5655OPE00
Applicable component levels
R550 PSY UI90100
UP23/01/20 P F301
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":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"550","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
02 April 2025