A fix is available
APAR status
Closed as new function.
Error description
Support new IFCID 389 and 477 and two new fields of IFCID 125 in Batch Record Trace: - IFCIDs 389 and 477 are new in DB2 version 12. - IFCID 389 records all indexes with Fast Traverse Block (FTB), - IFCID 477 records allocation and deallocation of an index Fast Traverse Block (FTB), - IFCID 125 has two new fields in DB2 version 12: QW0125RE and QW0125AD
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM batch record * * trace users. * **************************************************************** * PROBLEM DESCRIPTION: Add record trace support for IFCID389, * * IFCID477 and new IFCID125 fields * * QW0125RE and QWO125AD. * **************************************************************** * RECOMMENDATION: Apply the provided PTF. * **************************************************************** IFCID389 and IFCID477 are new for DB2 12. They provide data about index fast traverse blocks (FTB). IFCID125 fields QW0125RE and QW0125AD concern runtime SQL behavior (legs reordered and adaptive index processing). DB2PM / DB2PE record trace needs to support these changes.
Problem conclusion
Temporary fix
Comments
Support has been added to record trace processing for IFCID389, IFCID477 and IFCID125 fields QW0125RE and QW0125AD. This enhancement is already documented in publication SH12-7065, IBM Tivoli OMEGAMON XE for DB2 Performance Expert Report Reference.
APAR Information
APAR number
PI72647
Reported component name
OM XE DB2PE/PM
Reported component ID
5655OPE00
Reported release
540
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-11-21
Closed date
2017-06-14
Last modified date
2017-07-05
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI48046
Modules/Macros
DGONF130 DGONF380 DGONF500 DGONIREC
Fix information
Fixed component name
OM XE DB2PE/PM
Fixed component ID
5655OPE00
Applicable component levels
R540 PSY UI48046
UP17/06/16 P F706
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.4.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.4.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
05 July 2017