A fix is available
APAR status
Closed as program error.
Error description
In the OMPE manual, it said that "INAPPLPT - The class 1 CPU time in an application. This value is an average" What tried: GLOBAL TIMEZONE (+6:00) FROM (,19:15:00) TO (,19:30:00) INCLUDE (DB2ID(DB2P) CONNTYPE(DRDA)) ACCOUNTING TRACE LAYOUT (LONG) TOP (50 ONLY INAPPLPT) DDNAME(ACTCPU) EXEC The top guy in the report is TOP FIELD: PROCESSING (CL.1) TIME SPENT IN APPLICATION ---- IDENTIFICATION ---------------------------------- ACCT TSTAMP: 09/08/11 19:22:48.70 PLANNAME: DISTSERV BEGIN TIME : 09/08/11 19:11:14.07 PROD TYP: N/P END TIME : N/P PROD VER: N/P REQUESTER : DB2PRD CORRNAME: sas.exe MAINPACK : DISTSERV CORRNMBR: 'BLANK' PRIMAUTH : E970275 CONNTYPE: DRDA ORIGAUTH : E970275 CONNECT : SERVER TIMES/EVENTS APPL(CL.1) DB2 (CL.2) IFI (CL.5) ------------ ---------- ---------- ---------- ELAPSED TIME 1.280692 0.557898 N/P NONNESTED 1.278660 0.556475 N/A STORED PROC 0.002031 0.001422 N/A UDF 0.000000 0.000000 N/A TRIGGER 0.000000 0.000000 N/A CP CPU TIME 0.141300 0.137524 N/P ******** AGENT 0.141300 0.137524 N/A NONNESTED 0.139593 0.136116 N/P STORED PRC 0.001707 0.001407 N/A UDF 0.000000 0.000000 N/A TRIGGER 0.000000 0.000000 N/A PAR.TASKS 0.000000 0.000000 N/A Then tried again with the default (INAPPLET) GLOBAL TIMEZONE (+6:00) FROM (,19:15:00) TO (,19:30:00) INCLUDE (DB2ID(DB2P) CONNTYPE(DRDA)) ACCOUNTING TRACE LAYOUT (LONG) TOP (15 ONLY ) EXEC TOTAL CL1 CPU time is much higher than the other one's CPU time in the previous report using INAPPLPT LOCATION: DB2PRD GROUP: DSNDG2P MEMBER: DM2P SUBSYSTEM: DB2P DB2 VERSION: V9 the previous report using INAPPLPT LOCATION: DB2PRD TOP FIELD: ELAPSED TIME SPENT IN APPLICATION ---- IDENTIFICATION -------------------------------------- ACCT TSTAMP: 09/08/11 19:15:38.76 PLANNAME: dllhost. BEGIN TIME : 09/08/11 13:15:47.62 PROD TYP: COMMON SERV END TIME : 09/08/11 19:15:38.76 PROD VER: V9 R5 M5 REQUESTER : ::10.1.12.21 CORRNAME: dllhost. MAINPACK : dllhost. CORRNMBR: exe PRIMAUTH : PCOD10B CONNTYPE: DRDA ORIGAUTH : PCOD10B CONNECT : SERVER TIMES/EVENTS APPL(CL.1) DB2 (CL.2) IFI (CL.5) ------------ ---------- ---------- ---------- ELAPSED TIME 5:59:51.14 0.224064 N/P NONNESTED 5:59:51.14 0.000626 N/A STORED PROC 0.002862 0.223439 N/A UDF 0.000000 0.000000 N/A TRIGGER 0.000000 0.000000 N/A CP CPU TIME 3:44:21.38 0.023343 N/P ********** AGENT 3:44:21.38 0.023343 N/A NONNESTED 0.000000 0.000000 N/P STORED PRC 3:44:21.38 0.023343 N/A UDF 0.000000 0.000000 N/A TRIGGER 0.000000 0.000000 N/A PAR.TASKS 0.000000 0.000000 N/A
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM * * users of component: * * - Batch Reporting * **************************************************************** * PROBLEM DESCRIPTION: Invalid TOP processing for INAPPLPT * * field * * * **************************************************************** * RECOMMENDATION: Apply this PTF * * * **************************************************************** PROBLEM SUMMARY: Invalid value is used for INAPPLPT top value. PROBLEM CONCLUSION: Use correct value for INAPPLPT top field
Problem conclusion
Use correct value for INAPPLPT top field KEYWORDS : ACCOUNTING REPORT TRACE TOP PROCESSING INAPPLPT
Temporary fix
Comments
APAR Information
APAR number
PM50567
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-21
Closed date
2012-01-12
Last modified date
2012-02-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK75376 UK75377 UK75378
Modules/Macros
DGOACALC DGOATPRC
Fix information
Fixed component name
OM XE DB2PE/PM
Fixed component ID
5655OPE00
Applicable component levels
R410 PSY UK75376
UP12/01/16 P F201
R420 PSY UK75377
UP12/01/16 P F201
R510 PSY UK75378
UP12/01/16 P F201
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 February 2012