A fix is available
APAR status
Closed as program error.
Error description
- parent-child threads:locked resources=N/P - mismatching of ZDB2C display and PE client statistics data - Some DB2v9 and v10 field values are shown as 'N/A' in system parameters. - Some TOTAL fields are wrong on the GBP panels. - 'Elapsed time' threshold does not make sense on 'per minute' or 'per second' base. - Double click on the KPIs jumps to the wrong panel. - Dynamic Statement Cache display not accurate in case IFCID 318 has been turned off - Cache update timestamp is not shown in Dynamic Statement Cache display for DB2 9 - Statement number in Thread Detail panel is incorrectly shown as zero (0) - Thread type set to N/P for distributed allied threads - Statement cache is not refreshed when the member name is changed within a DSG. - Threshold definition for 'Storage cushion (MB)' must be specified in bytes. - Thread Details cannot be opened on DB2 v10 subsystem. - Thresholds using the Program Name,Package Collection or Location qualifiers are not working correctly.
Local fix
n/a
Problem summary
**************************************************************** * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM * * users of component: * * - Performance Expert Client * **************************************************************** * PROBLEM DESCRIPTION: 1.Some DB2v9 and v10 field values are * * shown as 'N/A' in system parameters. * * 2.Some TOTAL fields are wrong on the * * GBP panels. * * 3.'Elapsed time' threshold does not * * make sense on 'per minute' or 'per * * second' base. * * 4.Double click on the KPIs jumps to the * * wrong panel. * * 5.Dynamic Statement Cache display not * * Accurate in case IFCID 318 has been * * Turned off * * 6.Cache update timestamp is not shown * * In Dynamic Statement Cache display * * For DB2 9 * * 7.Statement number in Thread Detail * * Panel is incorrectly shown as * * zero (0) * * 8.Thread type set to N/P for * * distributed allied threads * * 9.Statement cache is not refreshed * * when the member name is changed * * within a DSG. * * 10.Threshold definition for 'Storage * * cushion (MB)' must be specified in * * bytes. * * 11.Thread Details cannot be opened on * * DB2 v10 subsystem. * * 12.Thresholds using the Program Name, * * Package Collection or Location * * qualifiers are not working correctly. * * * **************************************************************** * RECOMMENDATION: Apply this PTF * * * **************************************************************** PROBLEM SUMMARY: 1.Some DB2 fields are available were shown as N/A even though they were available in system parameters. 2.The Page P-Lock fields on the GBP panels were not calculated correctly, '7K0K1K' was shown instead of '8K'. 3.Threshold based on 'Elapsed time' fields does not make sense when they are calculated 'per minute' or 'per second'. 4.The wrong panel is opened when the KPI is based on a DB2 field which is on different panels dependent of the DB2 version. 5.After turning off IFCID 318 collection the time values in the Dynamic Statement Cache Displays are not shown as N/P 6.Update Timestamp in DB2 9 is not shown in PE Client Dynamic Statement Cache displays 7.The statement number in the Thread Details panel is incorrectly shown as zero (0) 8.Distributed allied threads was not handled correctly 9.When switching the member name in Statistics Details, the statement cache was not refreshed. 10.Threshold definition for 'Storage cushion (MB)' cannot be specified in MB as indicated by the label. 11.Opening Thread Details does not work on DB2 v10 subsystems. 12.The qualifiers Program Name, Package Collection or Location are not recognized correctly for thresholds. PROBLEM CONCLUSION: 1.The missing DB2 system parameters are now shown correctly on .the 'DB2 Utilities' in system parameters. 2.The TOTAL Page P-Lock fields are calculated correctly. 3.Remove 'per minute' and 'per second' calculation for the 'elapsed time' threshold during the threshold configuration. 4.The KPI opens now the correct panel depending on the DB2 Version of the DB2 field. 5.After turning off IFCID 318 collection the time values in the Dynamic Statement Cache Displays now show N/P. 6.The Update Timestamp(s) in the DB2 9 Dynamic Statement Cache displays is now shown properly. 7.The statement number in the Thread Details panel is now correctly shown. 8.Distributed allied threads are shown correctly. 9.Switching the member name refreshes and shows the correct data for the statement cache. 10.Threshold definition for 'Storage cushion (MB)' can now be specified in MB. 11.Thread Details is working again on DB2 v10 subsystems. 12.Thresholds with the Program Name, Package Collection or Location can be specified and used.
Problem conclusion
1.The missing DB2 system parameters are now shown correctly on the 'DB2 Utilities' in system parameters. 2.The TOTAL Page P-Lock fields are calculated correctly. 3.Remove 'per minute' and 'per second' calculation for the 'elapsed time' threshold during the threshold configuration. 4.The KPI opens now the correct panel depending on the DB2 Version of the DB2 field. 5.After turning off IFCID 318 collection the time values in the Dynamic Statement Cache Displays now show N/P. 6.The Update Timestamp(s) in the DB2 9 Dynamic Statement Cache displays is now shown properly. 7.The statement number in the Thread Details panel is now correctly shown. 8.Distributed allied threads are shown correctly. 9.Switching the member name refreshes and shows the correct data for the statement cache. 10.Threshold definition for 'Storage cushion (MB)' can now be specified in MB. 11.Thread Details is working again on DB2 v10 subsystems. 12.Thresholds with the Program Name, Package Collection or Location can be specified and used. KEYWORDS : DB2 V9 V10 SYSTEM PARAMETERS GBP P-LOCK TOTAL THRESHOLD EDITOR ELAPSED TIME FIELD PER MINUTE SECOND KPI WRONG PANEL STATISTICS DYNAMIC STATEMENT CACHE RDISTNUM DISTRIBUTED ALLIED THREAD DETAILS STORAGE CUSHION OPEN THREAD DETAILS PACKAGE COLLECTION LOCATION PROGRAM NAME
Temporary fix
Comments
APAR Information
APAR number
PM49483
Reported component name
OM XE DB2PE/PM
Reported component ID
5655OPE00
Reported release
510
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-10-07
Closed date
2011-10-10
Last modified date
2011-11-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK72705
Modules/Macros
FPEK$INF
Fix information
Fixed component name
OM XE DB2PE/PM
Fixed component ID
5655OPE00
Applicable component levels
R510 PSY UK72705
UP11/10/12 P F110
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.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.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
02 November 2011