A fix is available
APAR status
Closed as unreproducible in next release.
Error description
Support of instrumentation changes for serviceability for query acceleration related activities. Introduced by DB2's change request DM1637.
Local fix
n/a
Problem summary
**************************************************************** * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM * * users of component * * - Batch Reporting * **************************************************************** * PROBLEM DESCRIPTION: 1. Batch Accounting does not support * * yet enhancements of DB2 * * Instrumentation Facility related to * * IBM DB2 Analytics * * Accelerator V3. DB2 introduced those * * enhancements for DB2 version 10 with * * the support of waiting times on thread * * and package level. Batch Accounting * * should be able to report those fields * * because NOT ACCOUNTED fields show up * * values that do not account for waiting * * times for accelerators. * * * * 2. Batch Record Trace does not support * * yet enhancements of * * DB2 Instrumentation Facility * * related to IBM DB2 Analytics * * Accelerator V3. * * Missing support of IFCIDs 378/379. * * * * 3. Batch Locking Trace and Report do * * not translate hexadecimal values * * '35'X and '3D'X for locking types * * XML LOCK and INDEX KEY. * * * * 4. Missing support of some parameters * * and options regarding accelerators in * * Batch System Parameters report. * * * * 5. Batch Statistics and Record Trace * * label DATA SKEW (%) invalidly marked * * as a percentage. * **************************************************************** * RECOMMENDATION: Apply this PTF * **************************************************************** PROBLEM SUMMARY: 1. Batch Accounting does not support yet the exploitation of DB2 IDAA V3 performance data. Not Accounted fields show up values that do not account for waiting times for accelerators. 2. Same for Batch Record Trace. Missing support of IFCIDS 378/379. 3. Batch Locking Trace and Report do not translate hexadecimal values '35'X and '3D'X for locking types XML LOCK and INDEX KEY. 4. Missing support of some parameters and options regarding accelerators in Batch System Parameters report. 5. Batch Statistics and Record Trace label DATA SKEW (%) invalidly marked as a percentage. PROBLEM CONCLUSION: 1. Batch Accounting supports now the bucket of DB2 IDAA V3 waiting times and events of CLASS 3 and CLASS 8. Not Accounted fields on thread and package level account now for waiting times for accelerators. 2. Same for Batch Record trace. Some parameters and options with regard to accelerators have been added. IFCIDS 378/379 are supported now. 3. Batch Locking Trace and Report translate locking types '35'X and '3D'X into readable strings XML LOCK and INDEX KEY. 4. Batch System Parameters supports new parameters and options regarding accelerators in its report. 5. Batch Statistics and Record Trace field label changed to DATA SKEW. KEYWORDS: IDAA V3 ACCELERATOR WAITING TIME NOT ACCOUNTED QWACAACC QWACAACW QPACAACC QPACAACW EVENT XML LOCK INDEX KEY IFCID 378 379 DATA SKEW (%) QUERY_ACCEL_OPTION GET_ACCEL_ARCHIVE QUERY_ACCELERATION
Problem conclusion
Temporary fix
Comments
PROBLEM SUMMARY: 1. Batch Accounting does not support yet the exploitation of DB2 IDAA V3 performance data. Not Accounted fields show up values that do not account for waiting times for accelerators. 2. Same for Batch Record Trace. Missing support of IFCIDS 378/379. 3. Batch Locking Trace and Report do not translate hexadecimal values '35'X and '3D'X for locking types XML LOCK and INDEX KEY. 4. Missing support of some parameters and options regarding accelerators in Batch System Parameters report. 5. Batch Statistics and Record Trace label DATA SKEW (%) invalidly marked as a percentage. PROBLEM CONCLUSION: 1. Batch Accounting supports now the bucket of DB2 IDAA V3 waiting times and events of CLASS 3 and CLASS 8. Not Accounted fields on thread and package level account now for waiting times for accelerators. 2. Same for Batch Record trace. Some parameters and options with regard to accelerators have been added. IFCIDS 378/379 are supported now. 3. Batch Locking Trace and Report translate locking types '35'X and '3D'X into readable strings XML LOCK and INDEX KEY. 4. Batch System Parameters supports new parameters and options regarding accelerators in its report. 5. Batch Statistics and Record Trace field label changed to DATA SKEW. KEYWORDS: IDAA V3 ACCELERATOR WAITING TIME NOT ACCOUNTED QWACAACC QWACAACW QPACAACC QPACAACW EVENT XML LOCK INDEX KEY IFCID 378 379 DATA SKEW (%) QUERY_ACCEL_OPTION GET_ACCEL_ARCHIVE QUERY_ACCELERATION ×**** PE13/08/19 PTF IN ERROR. SEE APAR PM95251 FOR DESCRIPTION
APAR Information
APAR number
PM72622
Reported component name
OM XE DB2PE/PM
Reported component ID
5655OPE00
Reported release
511
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2012-09-11
Closed date
2012-12-20
Last modified date
2017-06-21
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK90526
Modules/Macros
BPOMAXA0 DGOAACUM DGOABLOG DGOABORD DGOABORE DGOACALC DGOACALX DGOACMER DGOACOMP DGOACREC DGOADIST DGOADNOR DGOAEXIT DGOAEX20 DGOAFGEN DGOAFILE DGOAFISA DGOAFLAT DGOAFORM DGOAFPCK DGOAIREC DGOAIREP DGOALUMP DGOAMPAC DGOAMTRC DGOAPARC DGOAQKEY DGOARCAL DGOAREDB DGOAREDC DGOAREDD DGOAREDG DGOAREDI DGOAREDM DGOAREDP DGOAREDR DGOAREDX DGOARXIT DGOASAVE DGOATOPR DGOATPRC DGOATRAC DGOATREC 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 DGOBSRSP DGOBSRSQ DGOBSRSS DGOBSRTM DGOBSTAL DGOBSTBN DGOBSTCM DGOBSTDD DGOBSTLG DGOBSTLK DGOBSTLO DGOBSTOC DGOBSTPO DGOBSTQP DGOBSTRI DGOBSTSP DGOBSTSQ DGOBSTSS DGOBSTTM DGOER000 DGOFECAL DGOFECA2 DGOFEDAT DGOFEDPM DGOFEPKG DGOFPDAT DGOFPDPM DGOFPRIC DGOLADLK DGOLAEOF DGOLAOTH DGOLAREQ DGOLARES DGOLASUM DGOLASUS DGOLATIM DGOLDIST DGOLFILE DGOLPRES DGOLQKEY DGOLREDC DGOLREXT DGOLSPSH DGOLTRAC DGOLXDUR DGOLXRES DGOLXSTA DGOMAXA0 DGOMFTAG DGOMTADJ DGOMTC3T DGOMTLST DGOMTPKG DGOMTPOP DGOMZF00 DGOMZF03 DGONFILE DGONFPAC DGONFWAC DGONFWPA DGONFWP9 DGONF370 DGONF380 DGONF410 DGONF500 DGONF8ST DGONIREC DGONTRAC DGOPACNV DGOPA920 DGORAEXT DGORCREC DGORCREP DGORCRE2 DGORIREP DGORPACC DGORUACC DGORZREP DGOSBLKX DGOSBORD DGOSBORE DGOSCREC DGOSI369 DGOSPREQ DGOTAPVA DGOVDB2F DGOVDSS DGOVMIDI DGOVMUAE DGOVSADJ DGOVSADK DGOVSAGG DGOVSCNI DGOVSCNT DGOVSCO1 DGOVSCS1 DGOVSCS2 DGOVSCTH DGOVSCT1 DGOVSCT2 DGOVSC2T DGOVSC3C DGOVSC3T DGOVSDSC DGOVSDTS DGOVSDTT DGOVSSP1 DGOVSTAG DGOVSTDS DGOVSTQL DGOWF106 DGOWF107 DGOW1FIL DGOXF000 DGOXF002 DGOXR000 DGOXT002 DGOZCRDW FPECKE15 FPECMDAT FPEUCBPR FPEUCXSX FPEUFTDS FPEUFTS2 FPEUIFCI FPEUIFC2 FPEUNIDT FPEUVTMM FPEVDB2F FPEVSETM FPEZCRD KO2CSY3A KO2CSY32 KO2I148
| SH12696300 |
Fix information
Fixed component name
OM XE DB2PE/PM
Fixed component ID
5655OPE00
Applicable component levels
R511 PSY UK90526
UP12/12/21 P F212
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.1","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.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
21 June 2017