A fix is available
APAR status
Closed as program error.
Error description
DB2 Performance Expert / Buffer Pool Analyzer Workstation Client at Version 5.1 Level 861 October 22, 2010 as down loaded from http://www-01.ibm.com/support/docview.wss?rs=434&uid=swg27013147 does not display DYNAMIC SQL STATEMENT CACHE IFCID 318 ( IFCID318) must be active for this information to be collected.
Local fix
Revert to prior level of PE client
Problem summary
**************************************************************** * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM * * users of component: * * - Performance Expert Client * **************************************************************** * PROBLEM DESCRIPTION: * Newest PEClient does not display * * dynamic statement cache information. * * * PEClient shows N/P for most of the * * DBM1 storage fields * **************************************************************** * RECOMMENDATION: Apply this PTF * * * **************************************************************** PROBLEM SUMMARY: PEClient was only handling the newest field version. The old field version was not converted correctly. DBM1 fields were not parsed correctly. PROBLEM CONCLUSION: PEClient handles now correctly both field type version. Dynamic SQL statements are shown again in the PEClient. DBM1 fields are now parsed correctly. DBM1 fields shows values again.
Problem conclusion
PEClient handles now correctly both field type version. Dynamic SQL statements are shown again in the PEClient. DBM1 fields are now parsed correctly. DBM1 fields shows values again. KEYWORDS : PECLIENT STATISTICS DYNAMIC SQL STATEMENTS NOT DISPLAYED DBM1 STORAGE FIELDS N/P
Temporary fix
Comments
APAR Information
APAR number
PM28744
Reported component name
OM XE DB2PE/PM
Reported component ID
5655OPE00
Reported release
420
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-12-13
Closed date
2011-03-30
Last modified date
2011-04-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK66291
Modules/Macros
FPEK$INF
Fix information
Fixed component name
OM XE DB2PE/PM
Fixed component ID
5655OPE00
Applicable component levels
R420 PSY UK66291
UP11/04/03 P F103
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":"4.2.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":"4.2.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
04 April 2011