A fix is available
APAR status
Closed as program error.
Error description
When DYNAMICSQL(YES) is specified in near term history option file, the performance trace started is missing some of the IFCIDs such as IFCID 172 and IFCID 196.
Local fix
Change COPT parm DYNAMICSQL(FULL) to DYNAMICSQL(YES)
Problem summary
**************************************************************** * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM * * users of component * * - Classic Interface * * - CUA Interface * **************************************************************** * PROBLEM DESCRIPTION: MISSING LOCKING IFCIDS FROM NEAR TERM * * HISTORY PERFORMANCE TRACE. * **************************************************************** * RECOMMENDATION: Apply this PTF * **************************************************************** PROBLEM SUMMARY: NEAR TERM HISTORY PERFORMANCE TRACE IS NOT STARTED CORRECTLY WHEN DYNAMICSQL(FULL) OPTION IS USED CAUSING MISSING LOCKING CONFLICT DATA. PROBLEM CONCLUSION: CORRECTED NEAR TERM HISTORY PERFORMANCE TRACE STATEMENT BY INCLUDING LOCKING CONFLICT RELATED IFCIDS REQUESTED BY USER.
Problem conclusion
CORRECTED NEAR TERM HISTORY PERFORMANCE TRACE STATEMENT BY INCLUDING LOCKING CONFLICT RELATED IFCIDS REQUESTED BY USER.
Temporary fix
Comments
APAR Information
APAR number
PK91550
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
2009-07-16
Closed date
2009-08-17
Last modified date
2009-09-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK49228 UK49256
Modules/Macros
KO2ICOLA KO2ICOLS KO2ICOL2 KO2ONAPB
Fix information
Fixed component name
OM XE DB2PE/PM
Fixed component ID
5655OPE00
Applicable component levels
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:
02 September 2009