Accounting Report - Long
This topic shows an example of a long version of the Accounting report.
Use the following command to produce a long version of the Accounting report:
...
ACCOUNTING
REPORT
LAYOUT (LONG)
ORDER (PRIMAUTH-PLANNAME)
SCOPE (MEMBER)
...Accounting (Long Report)
1 LOCATION: RS27QD1A IBM OMEGAMON FOR DB2 PERFORMANCE EXPERT (V5R5M0) PAGE: 1-1
GROUP: N/P ACCOUNTING REPORT - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: QD1A ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 11/07/23 10:26:10.43
DB2 VERSION: V13 SCOPE: MEMBER TO: 11/07/23 10:26:10.43
PRIMAUTH: OMPQUSER PLANNAME: KO2PLAN
ELAPSED TIME DISTRIBUTION CLASS 2 TIME DISTRIBUTION
---------------------------------------------------------------- ----------------------------------------------------------------
APPL |==================================================> 100% CPU |=======================================> 78%
DB2 | SECPU |
SUSP | NOTACC |=======> 14%
SUSP |====> 8%
AVERAGE APPL(CL.1) DB2 (CL.2) CLASS 3 SUSPENSIONS AVERAGE TIME AV.EVENT TIME/EVENT HIGHLIGHTS
------------ ---------- ---------- -------------------- ------------ -------- ---------- --------------------------
ELAPSED TIME 57.046652 0.012449 LOCK/LATCH(DB2+IRLM) 0.000000 0.00 N/C #OCCURRENCES : 10
NONNESTED 57.046652 0.012449 IRLM LOCK+LATCH 0.000000 0.00 N/C #ALLIEDS : 10
STORED PROC 0.000000 0.000000 DB2 LATCH 0.000000 0.00 N/C #ALLIEDS DISTRIB: 0
UDF 0.000000 0.000000 SYNCHRON. I/O 0.000154 0.90 0.000171 #DBATS : 0
TRIGGER 0.000000 0.000000 DATABASE I/O 0.000154 0.90 0.000171 #DBATS DISTRIB. : 0
READ CACHE HIT 0.000154 0.90 0.000171 #NO PROGRAM DATA: 0
CP CPU TIME 0.011631 0.009721 LOG WRITE I/O 0.000000 0.00 N/C #NORMAL TERMINAT: 10
AGENT 0.011631 0.009721 OTHER READ I/O 0.000000 0.00 N/C #ROLLUP TRAN : 10
NONNESTED 0.011631 0.009721 OTHER WRTE I/O 0.000000 0.00 N/C #DDFRRSAF ROLLUP: 1
STORED PRC 0.000000 0.000000 SER.TASK SWTCH 0.000798 1.40 0.000570 #ABNORMAL TERMIN: 0
UDF 0.000000 0.000000 UPDATE COMMIT 0.000000 0.00 N/C #CP/X PARALLEL. : 0
TRIGGER 0.000000 0.000000 OPEN/CLOSE 0.000000 0.00 N/C #UTIL PARALLEL. : 0
SQL DI N/A 0.000000 SYSLGRNG REC 0.000000 0.00 N/C #IO PARALLELISM : 0
PAR.TASKS 0.000000 0.000000 EXT/DEL/DEF 0.000000 0.00 N/C #PCA RUP COUNT : 0
SQL DI N/A 0.000000 OTHER SERVICE 0.000798 1.40 0.000570 #RUP AUTONOM. PR: 0
ARC.LOG(QUIES) 0.000000 0.00 N/C #AUTONOMOUS PR : 0
SE CPU TIME 0.000000 0.000000 LOG READ 0.000000 0.00 N/C #INCREMENT. BIND: 0
NONNESTED 0.000000 0.000000 DRAIN LOCK 0.000000 0.00 N/C #COMMITS : 8
STORED PROC 0.000000 0.000000 CLAIM RELEASE 0.000000 0.00 N/C #ROLLBACKS : 0
UDF 0.000000 0.000000 PAGE LATCH 0.000000 0.00 N/C #SVPT REQUESTS : 0
TRIGGER 0.000000 0.000000 NOTIFY MSGS 0.000000 0.00 N/C #SVPT RELEASE : 0
SQL DI N/A 0.000000 GLOBAL CONTENTION 0.000000 0.00 N/C #SVPT ROLLBACK : 0
COMMIT PH1 WRITE I/O 0.000000 0.00 N/C MAX SQL CASC LVL: 0
PAR.TASKS 0.000000 0.000000 ASYNCH CF REQUESTS 0.000000 0.00 N/C UPDATE/COMMIT : 0.00
SQL DI N/A 0.000000 TCP/IP LOB XML 0.000000 0.00 N/C SYNCH I/O AVG. : 0.000171
ACCELERATOR 0.000000 0.00 N/C MAX WFILE BLKS : 0
SUSPEND TIME 0.000000 0.000952 AUTONOMOUS PROCEDURE 0.000000 0.00 N/C #ZHL READ I/O : 0.00
AGENT N/A 0.000952 PQ SYNCHRONIZATION 0.000000 0.00 N/C
PAR.TASKS N/A 0.000000 LOB COMPRESSION 0.000000 0.00 N/C
STORED PROC 0.000000 N/A FAST INSERT PIPE 0.000000 0.00 N/C
UDF 0.000000 N/A TOTAL CLASS 3 0.000952 2.30 0.000414
NOT ACCOUNT. N/A 0.001776
DB2 ENT/EXIT N/A 11.40
EN/EX-STPROC N/A 0.00
EN/EX-UDF N/A 0.00
EN/EX-SQL DI N/A 0.00
DCAPT.DESCR. N/A N/A
LOG EXTRACT. N/A N/A
1 LOCATION: RS27QD1A IBM OMEGAMON FOR DB2 PERFORMANCE EXPERT (V5R5M0) PAGE: 1-2
GROUP: N/P ACCOUNTING REPORT - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: QD1A ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 11/07/23 10:26:10.43
DB2 VERSION: V13 SCOPE: MEMBER TO: 11/07/23 10:26:10.43
PRIMAUTH: OMPQUSER PLANNAME: KO2PLAN
SQL DML AVERAGE TOTAL SQL DCL TOTAL SQL DDL CREATE DROP ALTER DYNAMIC SQL STMT AVERAGE TOTAL
-------- -------- -------- -------------- -------- ---------- ------ ------ ------ -------------------- -------- --------
SELECT 1.60 16 LOCK TABLE 0 TABLE 0 0 0 REOPTIMIZATION 0.00 0
INSERT 0.00 0 GRANT 0 CRT TTABLE 0 N/A N/A NOT FOUND IN CACHE 0.00 0
ROWS 0.00 0 REVOKE 0 DCL TTABLE 0 N/A N/A FOUND IN CACHE 0.00 0
IAG1 0.00 0 SET CURR.SQLID 0 AUX TABLE 0 N/A N/A IMPLICIT PREPARES 0.00 0
IAG2 0.00 0 SET HOST VAR. 0 INDEX 0 0 0 PREPARES AVOIDED 0.00 0
UPDATE 0.00 0 SET CUR.DEGREE 0 TABLESPACE 0 0 0 CACHE_LIMIT_EXCEEDED 0.00 0
ROWS 0.00 0 SET RULES 0 DATABASE 0 0 0 PREP_STMT_PURGED 0.00 0
MERGE 0.00 0 SET CURR.PATH 0 STOGROUP 0 0 0 STABILIZED PREPARE 0.00 0
DELETE 0.00 0 SET CURR.PREC. 0 SYNONYM 0 0 N/A CSWL - STMTS PARSED 0.00 0
ROWS 0.00 0 SET TIMEOUT 0 VIEW 0 0 0 CSWL - LITS REPLACED 0.00 0
FROM APPL. 0 ALIAS 0 0 N/A CSWL - MATCHES FOUND 0.00 0
DESCRIBE 0.00 0 FROM PROF. 0 PACKAGE N/A 0 N/A CSWL - DUPLS CREATED 0.00 0
DESC.TBL 0.00 0 CONNECT TYPE 1 0 PROCEDURE 0 0 0 RDS SORT PERFORMED 0.00 0
PREPARE 0.00 0 CONNECT TYPE 2 0 FUNCTION 0 0 0 RDS SORTL USED 0.00 0
OPEN 0.00 0 SET CONNECTION 0 TRIGGER 0 0 N/A ZAI STBLZD PREPARE 0.00 0
FETCH 0.00 0 RELEASE 0 DIST TYPE 0 0 N/A ZAI SORT FB USED 0.00 0
ROWS 0.00 0 CALL 0 SEQUENCE 0 0 0 HISTORY LOST FOR ZAI 0.00 0
CLOSE 0.00 0 ASSOC LOCATORS 0 TRUST. CTX 0 0 0 HV REC LOST FOR ZAI 0.00 0
ALLOC CURSOR 0 ROLE 0 0 N/A
DML-ALL 1.60 16 HOLD LOCATOR 0 JAR N/A N/A 0
FREE LOCATOR 0 MASK/PERM 0 0 0
DCL-ALL 0 VARIABLE 0 0 N/A
TOTAL 0 0 0
TRUNC TBL 0
RENAME TBL 0
RENAME IX 0
COMMENT ON 0
LABEL ON 0
MEASURED/ELIG TIMES APPL (CL1) DB2 (CL2) RID LIST AVERAGE TOTAL DATA CAPTURE AVERAGE TOTAL
------------------- ---------- ---------- ---------------------- -------- -------- ----------------- -------- --------
ELAPSED TIME 57.046652 0.012449 USED 0.00 0 IFI CALLS MADE 2.00 2
ELIGIBLE FOR ACCEL N/A 0.000000 RECORDS CAPTURED 0.00 0
FAIL-NO STORAGE 0.00 0 LOG RECORDS READ 0.00 0
CP CPU TIME 0.011631 0.009721 FAIL-LIMIT EXCEEDED 0.00 0 ROWS RETURNED 0.00 0
ELIGIBLE FOR SECP 0.000000 N/A FAIL-NOT CONSTRUCTED 0.00 0 RECORDS RETURNED 0.00 0
ELIGIBLE FOR ACCEL N/A 0.000000 DATA DESC. RETURN 0.00 0
INTERRUPTED-NO STORAGE 0.00 0 TABLES RETURNED 0.00 0
SE CPU TIME 0.000000 0.000000 INTERRUPTED-LIMIT EXC. 0.00 0 DESCRIBES 0.00 0
ELIGIBLE FOR ACCEL N/A 0.000000
OVERFLOWED-NO STORAGE 0.00 0
OVERFLOWED-LIMIT EXC. 0.00 0
SKIPPED-INDEX KNOWN 0.00 0
STORED PROCEDURES AVERAGE TOTAL UDF AVERAGE TOTAL TRIGGERS AVERAGE TOTAL
----------------- -------- -------- --------- -------- -------- ----------------- -------- --------
CALL STATEMENTS 0.00 0 EXECUTED 0.00 0 STATEMENT TRIGGER 0.00 0
ABENDED 0.00 0 ABENDED 0.00 0 ROW TRIGGER 0.00 0
TIMED OUT 0.00 0 TIMED OUT 0.00 0 SQL ERROR OCCUR 0.00 0
REJECTED 0.00 0 REJECTED 0.00 0
GLOBAL CONTENTION L-LOCKS AVERAGE TIME AV.EVENT GLOBAL CONTENTION P-LOCKS AVERAGE TIME AV.EVENT
------------------------------------- ------------ -------- ------------------------------------- ------------ --------
L-LOCKS 0.000000 0.00 P-LOCKS 0.000000 0.00
PARENT (DB,TS,TAB,PART) 0.000000 0.00 PAGESET/PARTITION 0.000000 0.00
CHILD (PAGE,ROW) 0.000000 0.00 PAGE 0.000000 0.00
OTHER 0.000000 0.00 OTHER 0.000000 0.00
1 LOCATION: RS27QD1A IBM OMEGAMON FOR DB2 PERFORMANCE EXPERT (V5R5M0) PAGE: 1-3
GROUP: N/P ACCOUNTING REPORT - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: QD1A ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 11/07/23 10:26:10.43
DB2 VERSION: V13 SCOPE: MEMBER TO: 11/07/23 10:26:10.43
PRIMAUTH: OMPQUSER PLANNAME: KO2PLAN
LOCKING AVERAGE TOTAL DATA SHARING AVERAGE TOTAL
--------------------- -------- -------- ------------------- -------- --------
TIMEOUTS 0.00 0 GLOBAL CONT RATE(%) N/C N/A
DEADLOCKS 0.00 0 FALSE CONT RATE(%) N/C N/A
ESCAL.(SHARED) 0.00 0 P/L-LOCKS XES(%) N/C N/A
ESCAL.(EXCLUS) 0.00 0 LOCK REQ - PLOCKS 0.00 0
MAX PG/ROW LOCKS HELD 0.00 0 UNLOCK REQ - PLOCKS 0.00 0
LOCK REQUEST 2.60 26 CHANGE REQ - PLOCKS 0.00 0
UNLOCK REQUEST 2.80 28 LOCK REQ - XES 0.00 0
QUERY REQUEST 0.00 0 UNLOCK REQ - XES 0.00 0
CHANGE REQUEST 0.50 5 CHANGE REQ - XES 0.00 0
OTHER REQUEST 0.00 0 SUSPENDS - IRLM 0.00 0
TOTAL SUSPENSIONS 0.00 0 SUSPENDS - XES 0.00 0
LOCK SUSPENSIONS 0.00 0 CONVERSIONS- XES 0.00 0
IRLM LATCH SUSPENS. 0.00 0 FALSE CONTENTIONS 0.00 0
OTHER SUSPENS. 0.00 0 INCOMPATIBLE LOCKS 0.00 0
NOTIFY MSGS SENT 0.00 0
LONGEST LOCK,LATCH, I/O WAIT VALUE LONGEST PAGE LATCH WAIT VALUE
---------------------------- ---------------------------- ----------------------- ----------------
ELAPSED TIME 0.000416 ELAPSED TIME N/P
WAIT TYPE N/P SOURCE ACE N/P
SOURCE ACE X'3AAA7F20' DATABASE ID N/P
DBID FOR SYNC/ASYNC I/O 6 PAGESET ID N/P
OBID FOR SYNC/ASYNC I/O 15 PAGE NUMBER N/P
LOCK HASH X'0006000F' PARTITION NUMBER N/P
LOCK NAME N/P BEGIN TIME N/P
LOCK RES TYPE N/P END TIME N/P
LATCH CLASS 15
LATCH TOKEN N/P
BEGIN TIME 10:26:10.259749
END TIME 10:26:10.260165
LONGEST SERVICE TASK WAIT VALUE QUERY PARALLELISM AVERAGE TOTAL DRAIN/CLAIM AVERAGE TOTAL
------------------------- ---------------- ------------------------- -------- -------- -------------- -------- --------
ELAPSED TIME 0.001036 MAXIMUM DEGREE-ESTIMATED 0.00 0 DRAIN REQUESTS 0.00 0
SOURCE ACE X'3AAA7F20' MAXIMUM DEGREE-PLANNED 0.00 0 DRAIN FAILED 0.00 0
RESOURCE MANAGER ID 22 MAXIMUM DEGREE-EXECUTED N/A 0 CLAIM REQUESTS 4.40 44
FUNCTION CODE 86 MAXIMUM MEMBERS USED N/A 0 CLAIM FAILED 0.00 0
BEGIN TIME 10:16:52.034662 PARALLEL GROUPS EXECUTED 0.00 0
END TIME 10:16:52.035698 RAN AS PLANNED 0.00 0
RAN REDUCED-STORAGE 0.00 0
RAN REDUCED-NEGOTIATION 0.00 0
SEQ-CURSOR 0.00 0
SEQ-NO ESA SORT 0.00 0
SEQ-NO BUFFER 0.00 0
SEQ-AUTONOMOUS PROC 0.00 0
SEQ-NEGOTIATION 0.00 0
ONE DB2-COORDINATOR = NO 0.00 0
ONE DB2-ISOLATION LEVEL 0.00 0
ONE DB2-DCL TTABLE 0.00 0
MEMBER SKIPPED (%) N/C N/A
DISABLED BY RLF 0.00 0
REFORM PARAL-CONFIG 0.00 0
REFORM PARAL-NO BUF 0.00 0
1 LOCATION: RS27QD1A IBM OMEGAMON FOR DB2 PERFORMANCE EXPERT (V5R5M0) PAGE: 1-4
GROUP: N/P ACCOUNTING REPORT - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: QD1A ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 11/07/23 10:26:10.43
DB2 VERSION: V13 SCOPE: MEMBER TO: 11/07/23 10:26:10.43
PRIMAUTH: OMPQUSER PLANNAME: KO2PLAN
NORMAL TERM. AVERAGE TOTAL ABNORMAL TERM. TOTAL IN DOUBT TOTAL ROWID AVERAGE TOTAL
--------------- -------- -------- ----------------- -------- -------------- -------- ------------- -------- --------
NEW USER 0.00 0 APPL.PROGR. ABEND 0 APPL.PGM ABEND 0 DIRECT ACCESS 0.00 0
DEALLOCATION 0.00 0 END OF MEMORY 0 END OF MEMORY 0 INDEX USED 0.00 0
APPL.PROGR. END 0.00 0 RESOL.IN DOUBT 0 END OF TASK 0 TS SCAN USED 0.00 0
RESIGNON 0.00 0 CANCEL FORCE 0 CANCEL FORCE 0
DBAT INACTIVE 0.00 0
TYPE2 INACTIVE 0.00 0
RRS COMMIT 0.00 0
END USER THRESH 0.10 1
BLOCK STOR THR 0.00 0
STALENESS THR 0.00 0
LOGGING AVERAGE TOTAL AVERAGE SU CLASS 1 CLASS 2 MISCELLANEOUS AVERAGE TOTAL
------------------- -------- -------- ------------ -------------- -------------- -------------------- -------- --------
LOG RECORDS WRITTEN 0.00 0 CP CPU 1185.30 990.60 MAX STO LOB VAL (KB) 0.00 0
TOT BYTES WRITTEN 0.00 0 AGENT 1185.30 990.60 MAX STO XML VAL (KB) 0.00 0
LOG RECORD SIZE N/C N/A NONNESTED 1185.30 990.60 ARRAY EXPANSIONS 0.00 0
STORED PRC 0.00 0.00 SPARSE IX DISABLED 0.00 0
UDF 0.00 0.00 SPARSE IX BUILT WF 0.00 0
TRIGGER 0.00 0.00 NO DM CALL RIDL/LPF 0.00 0
PAR.TASKS 0.00 0.00 FETCH 1 BLOCK ONLY 0.00 0
ELIG SECP 0.00 N/A
ELIG ACCEL N/A 0.00
SE CPU 0.00 0.00
NONNESTED 0.00 0.00
STORED PROC 0.00 0.00
UDF 0.00 0.00
TRIGGER 0.00 0.00
PAR.TASKS 0.00 0.00
ELIG ACCEL N/A 0.00
BP0 BPOOL ACTIVITY AVERAGE TOTAL
--------------------- -------- --------
BPOOL HIT RATIO (%) 88.75 N/A
GETPAGES 8.00 80
BUFFER UPDATES 0.00 0
SYNCHRONOUS WRITE 0.00 0
SYNCHRONOUS READ 0.90 9
SEQ. PREFETCH REQS 0.00 0
LIST PREFETCH REQS 0.00 0
DYN. PREFETCH REQS 0.00 0
PAGES READ ASYNCHR. 0.00 0
ZHL SYNC. READS 0.00 0
ZHL READ ELPSD TIME 0.000000 0.000000
1 LOCATION: RS27QD1A IBM OMEGAMON FOR DB2 PERFORMANCE EXPERT (V5R5M0) PAGE: 1-5
GROUP: N/P ACCOUNTING REPORT - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: QD1A ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 11/07/23 10:26:10.43
DB2 VERSION: V13 SCOPE: MEMBER TO: 11/07/23 10:26:10.43
PRIMAUTH: OMPQUSER PLANNAME: KO2PLAN
FPEVDB2S VALUE FPEVDB2S TIMES FPEVDB2S AVERAGE TIME AVG.EV TIME/EVENT
------------------ ------------------ ------------------ ------------ ------------------ ------------ ------ ------------
TYPE PACKAGE ELAP-CL7 TIME-AVG 0.002709 LOCK/LATCH 0.000000 0.00 N/C
CP CPU TIME 0.001931 IRLM LOCK+LATCH 0.000000 0.00 N/C
LOCATION RS27QD1A AGENT 0.001931 DB2 LATCH 0.000000 0.00 N/C
COLLECTION ID KO2OM550 PAR.TASKS 0.000000 SYNCHRONOUS I/O 0.000768 4.50 0.000171
PROGRAM NAME FPEVDB2S SE CPU TIME 0.000000 OTHER READ I/O 0.000000 0.00 N/C
SUSPENSION-CL8 0.000768 OTHER WRITE I/O 0.000000 0.00 N/C
ACTIVITY TYPE NONNESTED AGENT 0.000768 SERV.TASK SWITCH 0.000000 0.00 N/C
ACTIVITY NAME 'BLANK' PAR.TASKS 0.000000 ARCH.LOG(QUIESCE) 0.000000 0.00 N/C
SCHEMA NAME 'BLANK' NOT ACCOUNTED 0.000010 ARCHIVE LOG READ 0.000000 0.00 N/C
INCOMPATIBILITY NO AVG.DB2 ENTRY/EXIT 26.00 DRAIN LOCK 0.000000 0.00 N/C
SUCC AUTH CHECK 0 DB2 ENTRY/EXIT 52 CLAIM RELEASE 0.000000 0.00 N/C
OCCURRENCES 10 PAGE LATCH 0.000000 0.00 N/C
NBR OF ALLOCATIONS 2 CP CPU SU 196.50 NOTIFY MESSAGES 0.000000 0.00 N/C
SQL STMT - AVERAGE 8.00 AGENT 196.50 GLOBAL CONTENTION 0.000000 0.00 N/C
SQL STMT - TOTAL 16 PAR.TASKS 0.00 TCP/IP LOB XML 0.000000 0.00 N/C
NBR RLUP THREADS 2 SE CPU SU 0.00 ACCELERATOR 0.000000 0.00 N/C
PQ SYNCHRONIZATION 0.000000 0.00 N/C
FAST INSERT PIPE 0.000000 0.00 N/C
TOTAL CL8 SUSPENS. 0.000768 4.50 0.000171
FPEVDB2S AVERAGE TIME AV.EVENT FPEVDB2S AVERAGE TIME AV.EVENT
------------------------- ------------ -------- ------------------------- ------------ --------
GLOBAL CONTENTION L-LOCKS 0.000000 0.00 GLOBAL CONTENTION P-LOCKS 0.000000 0.00
PARENT (DB,TS,TAB,PART) 0.000000 0.00 PAGESET/PARTITION 0.000000 0.00
CHILD (PAGE,ROW) 0.000000 0.00 PAGE 0.000000 0.00
OTHER 0.000000 0.00 OTHER 0.000000 0.00
FPEVDB2S AVERAGE TOTAL
------------------ -------- --------
SELECT 8.00 16
INSERT 0.00 0
UPDATE 0.00 0
DELETE 0.00 0
DESCRIBE 0.00 0
PREPARE 0.00 0
OPEN 0.00 0
FETCH 0.00 0
CLOSE 0.00 0
LOCK TABLE 0.00 0
CALL 0.00 0
FPEVDB2S AVERAGE TOTAL
------------------- -------- --------
BPOOL HIT RATIO (%) 83.93 N/A
GETPAGES 28.00 56
BUFFER UPDATES 0.00 0
SYNCHRONOUS WRITE 0.00 0
SYNCHRONOUS READ 4.50 9
SEQ. PREFETCH REQS 0.00 0
LIST PREFETCH REQS 0.00 0
DYN. PREFETCH REQS 0.00 0
PAGES READ ASYNCHR. 0.00 0
ZHL SYNC. READ 0.00 0
ZHL CPU TIME READ 0.000000 0.000000
1 LOCATION: RS27QD1A IBM OMEGAMON FOR DB2 PERFORMANCE EXPERT (V5R5M0) PAGE: 1-6
GROUP: N/P ACCOUNTING REPORT - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: QD1A ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 11/07/23 10:26:10.43
DB2 VERSION: V13 SCOPE: MEMBER TO: 11/07/23 10:26:10.43
PRIMAUTH: OMPQUSER PLANNAME: KO2PLAN
FPEVDB2S AVERAGE TOTAL
--------------------- -------- --------
TIMEOUTS 0.00 0
DEADLOCKS 0.00 0
ESCAL.(SHARED) 0.00 0
ESCAL.(EXCLUS) 0.00 0
MAX PG/ROW LOCKS HELD 0.00 0
LOCK REQUEST 6.00 12
UNLOCK REQUEST 8.00 16
QUERY REQUEST 0.00 0
CHANGE REQUEST 1.00 2
OTHER REQUEST 0.00 0
TOTAL SUSPENSIONS 0.00 0
LOCK SUSPENSIONS 0.00 0
IRLM LATCH SUSPENS. 0.00 0
OTHER SUSPENS. 0.00 0
AVERAGE TIMES CL. 5 IFI (CL.5)
------------------- ----------
ELAPSED TIME 0.005801
CP CPU TIME 0.004205
DCAPT.DESCR. 0.000000
LOG EXTRACT. 0.000000
ACCOUNTING REPORT COMPLETE