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: RS22ODS5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-1
GROUP: ODS5 ACCOUNTING REPORT - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: OCC5 TO: NOT SPECIFIED
SUBSYSTEM: OCC5 ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 11/06/23 08:35:00.27
DB2 VERSION: V12 SCOPE: MEMBER TO: 11/06/23 08:35:00.27
PRIMAUTH: CSMVDQO PLANNAME: db2jcc_a
ELAPSED TIME DISTRIBUTION CLASS 2 TIME DISTRIBUTION
---------------------------------------------------------------- ----------------------------------------------------------------
APPL |====================> 40% CPU |====> 8%
DB2 |==========================> 52% SECPU |=> 2%
SUSP |====> 8% NOTACC |======================================> 77%
SUSP |======> 13%
AVERAGE APPL(CL.1) DB2 (CL.2) CLASS 3 SUSPENSIONS AVERAGE TIME AV.EVENT TIME/EVENT HIGHLIGHTS
------------ ---------- ---------- -------------------- ------------ -------- ---------- --------------------------
ELAPSED TIME 0.012772 0.007685 LOCK/LATCH(DB2+IRLM) 0.000000 0.00 N/C #OCCURRENCES : 4
NONNESTED 0.001861 0.000431 IRLM LOCK+LATCH 0.000000 0.00 N/C #ALLIEDS : 0
STORED PROC 0.010911 0.007254 DB2 LATCH 0.000000 0.00 N/C #ALLIEDS DISTRIB: 0
UDF 0.000000 0.000000 SYNCHRON. I/O 0.000000 0.00 N/C #DBATS : 4
TRIGGER 0.000000 0.000000 DATABASE I/O 0.000000 0.00 N/C #DBATS DISTRIB. : 0
READ CACHE HIT 0.000000 0.00 N/C #NO PROGRAM DATA: 0
CP CPU TIME 0.001076 0.000624 LOG WRITE I/O 0.000000 0.00 N/C #NORMAL TERMINAT: 4
AGENT 0.001076 0.000624 OTHER READ I/O 0.000000 0.00 N/C #ROLLUP TRAN : 4
NONNESTED 0.000248 0.000208 OTHER WRTE I/O 0.000000 0.00 N/C #DDFRRSAF ROLLUP: 1
STORED PRC 0.000828 0.000415 SER.TASK SWTCH 0.000980 2.00 0.000490 #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
PAR.TASKS 0.000000 0.000000 SYSLGRNG REC 0.000000 0.00 N/C #IO PARALLELISM : 0
EXT/DEL/DEF 0.000000 0.00 N/C #PCA RUP COUNT : 0
SE CPU TIME 0.000231 0.000186 OTHER SERVICE 0.000980 2.00 0.000490 #RUP AUTONOM. PR: 0
NONNESTED 0.000231 0.000186 ARC.LOG(QUIES) 0.000000 0.00 N/C #AUTONOMOUS PR : 0
STORED PROC 0.000000 0.000000 LOG READ 0.000000 0.00 N/C #INCREMENT. BIND: 0
UDF 0.000000 0.000000 DRAIN LOCK 0.000000 0.00 N/C #COMMITS : 4
TRIGGER 0.000000 0.000000 CLAIM RELEASE 0.000000 0.00 N/C #ROLLBACKS : 0
PAGE LATCH 0.000000 0.00 N/C #SVPT REQUESTS : 0
PAR.TASKS 0.000000 0.000000 NOTIFY MSGS 0.000000 0.00 N/C #SVPT RELEASE : 0
GLOBAL CONTENTION 0.000000 0.00 N/C #SVPT ROLLBACK : 0
SUSPEND TIME 0.000343 0.000980 COMMIT PH1 WRITE I/O 0.000000 0.00 N/C MAX SQL CASC LVL: 1
AGENT N/A 0.000980 ASYNCH CF REQUESTS 0.000000 0.00 N/C UPDATE/COMMIT : 4.00
PAR.TASKS N/A 0.000000 TCP/IP LOB XML 0.000000 0.00 N/C SYNCH I/O AVG. : N/C
STORED PROC 0.000343 N/A ACCELERATOR 0.000000 0.00 N/C MAX WFILE BLKS : 512
UDF 0.000000 N/A AUTONOMOUS PROCEDURE 0.000000 0.00 N/C #ZHL READ I/O : 0.00
PQ SYNCHRONIZATION 0.000000 0.00 N/C
NOT ACCOUNT. N/A 0.005895 LOB COMPRESSION 0.000000 0.00 N/C
DB2 ENT/EXIT N/A 4.00 FAST INSERT PIPE 0.000000 0.00 N/C
EN/EX-STPROC N/A 14.00 TOTAL CLASS 3 0.000980 2.00 0.000490
EN/EX-UDF N/A 0.00
DCAPT.DESCR. N/A N/A
LOG EXTRACT. N/A N/A
1 LOCATION: RS22ODS5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-2
GROUP: ODS5 ACCOUNTING REPORT - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: OCC5 TO: NOT SPECIFIED
SUBSYSTEM: OCC5 ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 11/06/23 08:35:00.27
DB2 VERSION: V12 SCOPE: MEMBER TO: 11/06/23 08:35:00.27
PRIMAUTH: CSMVDQO PLANNAME: db2jcc_a
SQL DML AVERAGE TOTAL SQL DCL TOTAL SQL DDL CREATE DROP ALTER DYNAMIC SQL STMT AVERAGE TOTAL
-------- -------- -------- -------------- -------- ---------- ------ ------ ------ -------------------- -------- --------
SELECT 0.00 0 LOCK TABLE 0 TABLE 0 0 0 REOPTIMIZATION 0.00 0
INSERT 2.00 8 GRANT 0 CRT TTABLE 0 N/A N/A NOT FOUND IN CACHE 0.00 0
ROWS 2.00 8 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 2.00 8 SET CURR.PREC. 0 SYNONYM 0 0 N/A CSWL - STMTS PARSED 0.00 0
ROWS 0.00 0 CONNECT TYPE 1 0 VIEW 0 0 0 CSWL - LITS REPLACED 0.00 0
CONNECT TYPE 2 0 ALIAS 0 0 N/A CSWL - MATCHES FOUND 0.00 0
DESCRIBE 0.00 0 SET CONNECTION 0 PACKAGE N/A 0 N/A CSWL - DUPLS CREATED 0.00 0
DESC.TBL 0.00 0 RELEASE 0 PROCEDURE 0 0 0 RDS SORT PERFORMED 1.00 4
PREPARE 0.00 0 CALL 4 FUNCTION 0 0 0 RDS SORTL USED 1.00 4
OPEN 2.00 8 ASSOC LOCATORS 0 TRIGGER 0 0 N/A ZAI STBLZD PREPARE 0.00 0
FETCH 2.00 8 ALLOC CURSOR 0 DIST TYPE 0 0 N/A ZAI SORT FB USED 0.00 0
ROWS 2.00 8 HOLD LOCATOR 0 SEQUENCE 0 0 0
CLOSE 0.00 0 FREE LOCATOR 0 TRUST. CTX 0 0 0
DCL-ALL 4 ROLE 0 0 N/A
DML-ALL 8.00 32 JAR N/A N/A 0
MASK/PERM 0 0 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 0.012772 0.007685 USED 0.00 0 IFI CALLS MADE 0.00 0
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.001076 0.000624 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.000231 0.000186 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 1.00 4 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
1 LOCATION: RS22ODS5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-3
GROUP: ODS5 ACCOUNTING REPORT - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: OCC5 TO: NOT SPECIFIED
SUBSYSTEM: OCC5 ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 11/06/23 08:35:00.27
DB2 VERSION: V12 SCOPE: MEMBER TO: 11/06/23 08:35:00.27
PRIMAUTH: CSMVDQO PLANNAME: db2jcc_a
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
LOCKING AVERAGE TOTAL DATA SHARING AVERAGE TOTAL QUERY PARALLELISM AVERAGE TOTAL
--------------------- -------- -------- ------------------- -------- -------- ------------------------- -------- --------
TIMEOUTS 0.00 0 GLOBAL CONT RATE(%) 0.00 N/A MAXIMUM DEGREE-ESTIMATED 0.00 0
DEADLOCKS 0.00 0 FALSE CONT RATE(%) 0.00 N/A MAXIMUM DEGREE-PLANNED 0.00 0
ESCAL.(SHARED) 0.00 0 P/L-LOCKS XES(%) 22.22 N/A MAXIMUM DEGREE-EXECUTED N/A 0
ESCAL.(EXCLUS) 0.00 0 LOCK REQ - PLOCKS 0.00 0 MAXIMUM MEMBERS USED N/A 0
MAX PG/ROW LOCKS HELD 0.00 0 UNLOCK REQ - PLOCKS 0.00 0 PARALLEL GROUPS EXECUTED 0.00 0
LOCK REQUEST 9.00 36 CHANGE REQ - PLOCKS 0.00 0 RAN AS PLANNED 0.00 0
UNLOCK REQUEST 4.75 19 LOCK REQ - XES 2.00 8 RAN REDUCED-STORAGE 0.00 0
QUERY REQUEST 0.00 0 UNLOCK REQ - XES 2.00 8 RAN REDUCED-NEGOTIATION 0.00 0
CHANGE REQUEST 1.00 4 CHANGE REQ - XES 0.00 0 SEQ-CURSOR 0.00 0
OTHER REQUEST 0.00 0 SUSPENDS - IRLM 0.00 0 SEQ-NO ESA SORT 0.00 0
TOTAL SUSPENSIONS 0.00 0 SUSPENDS - XES 0.00 0 SEQ-NO BUFFER 0.00 0
LOCK SUSPENSIONS 0.00 0 CONVERSIONS- XES 0.00 0 SEQ-AUTONOMOUS PROC 0.00 0
IRLM LATCH SUSPENS. 0.00 0 FALSE CONTENTIONS 0.00 0 SEQ-NEGOTIATION 0.00 0
OTHER SUSPENS. 0.00 0 INCOMPATIBLE LOCKS 0.00 0 ONE DB2-COORDINATOR = NO 0.00 0
NOTIFY MSGS SENT 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
DRAIN/CLAIM AVERAGE TOTAL NORMAL TERM. AVERAGE TOTAL ABNORMAL TERM. TOTAL IN DOUBT TOTAL
-------------- -------- -------- --------------- -------- -------- ----------------- -------- -------------- --------
DRAIN REQUESTS 0.00 0 NEW USER 0.00 0 APPL.PROGR. ABEND 0 APPL.PGM ABEND 0
DRAIN FAILED 0.00 0 DEALLOCATION 0.00 0 END OF MEMORY 0 END OF MEMORY 0
CLAIM REQUESTS 0.00 0 APPL.PROGR. END 0.00 0 RESOL.IN DOUBT 0 END OF TASK 0
CLAIM FAILED 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.00 0
BLOCK STOR THR 0.00 0
STALENESS THR 0.25 1
1 LOCATION: RS22ODS5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-4
GROUP: ODS5 ACCOUNTING REPORT - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: OCC5 TO: NOT SPECIFIED
SUBSYSTEM: OCC5 ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 11/06/23 08:35:00.27
DB2 VERSION: V12 SCOPE: MEMBER TO: 11/06/23 08:35:00.27
PRIMAUTH: CSMVDQO PLANNAME: db2jcc_a
ROWID AVERAGE TOTAL LOGGING AVERAGE TOTAL AVERAGE SU CLASS 1 CLASS 2
------------- -------- -------- ------------------- -------- -------- ------------ -------------- --------------
DIRECT ACCESS 0.00 0 LOG RECORDS WRITTEN 0.00 0 CP CPU 109.50 63.25
INDEX USED 0.00 0 TOT BYTES WRITTEN 0.00 0 AGENT 109.50 63.25
TS SCAN USED 0.00 0 LOG RECORD SIZE N/C N/A NONNESTED 25.25 21.00
STORED PRC 84.25 42.25
UDF 0.00 0.00
TRIGGER 0.00 0.00
PAR.TASKS 0.00 0.00
ELIG SECP 0.00 N/A
ELIG ACCEL N/A 0.00
SE CPU 23.58 19.00
NONNESTED 23.58 19.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
MISCELLANEOUS AVERAGE TOTAL
-------------------- -------- --------
MAX STO LOB VAL (KB) 0.00 0
MAX STO XML VAL (KB) 0.00 0
ARRAY EXPANSIONS 0.00 0
SPARSE IX DISABLED 0.00 0
SPARSE IX BUILT WF 0.00 0
NO DM CALL RIDL/LPF 0.00 0
FETCH 1 BLOCK ONLY 0.00 0
BP0 BPOOL ACTIVITY AVERAGE TOTAL
--------------------- -------- --------
BPOOL HIT RATIO (%) 100.00 N/A
GETPAGES 12.00 48
BUFFER UPDATES 9.00 36
SYNCHRONOUS WRITE 0.00 0
SYNCHRONOUS READ 0.00 0
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
---- DISTRIBUTED ACTIVITY -------------------------------------------------------------------------------------------------
REQUESTER : ::FFFF:192.168#1 #COMMIT(1) RECEIVED: 4 MESSAGES SENT : 8.00 ROWS SENT : 12.00
PRODUCT ID : JDBC DRIVER #ROLLBK(1) RECEIVED: 0 MESSAGES RECEIVED: 8.00 BLOCKS SENT : 16.00
PRODUCT VERSION: V4 R31M0 SQL RECEIVED : 4.00 BYTES SENT : 11280.00 #DDF ACCESSES: 1
METHOD : DRDA PROTOCOL BYTES RECEIVED : 1048.00 #RLUP THREADS: 4
CONV.INITIATED : 0.00 #THREADS INDOUBT : 0
1 LOCATION: RS22ODS5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-5
GROUP: ODS5 ACCOUNTING REPORT - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: OCC5 TO: NOT SPECIFIED
SUBSYSTEM: OCC5 ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 11/06/23 08:35:00.27
DB2 VERSION: V12 SCOPE: MEMBER TO: 11/06/23 08:35:00.27
PRIMAUTH: CSMVDQO PLANNAME: db2jcc_a
-------------------------------------------------------------------------------
|PROGRAM NAME CLASS 7 ELAPSED TIME CONSUMERS |
|SYSSTAT |==============================================> 93% |
|DSNADMCD |==> 4% |
|DSNADMCW |=> 2% |
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
|PROGRAM NAME CLASS 7 CP CPU TIME CONSUMERS |
|SYSSTAT |=====================> 42% |
|DSNADMCD |=================> 34% |
|DSNADMCW |========> 16% |
-------------------------------------------------------------------------------
SYSSTAT VALUE SYSSTAT TIMES SYSSTAT AVERAGE TIME AVG.EV TIME/EVENT
------------------ ------------------ ------------------ ------------ ------------------ ------------ ------ ------------
TYPE PACKAGE ELAP-CL7 TIME-AVG 0.007159 LOCK/LATCH 0.000000 0.00 N/C
CP CPU TIME 0.000261 IRLM LOCK+LATCH 0.000000 0.00 N/C
LOCATION RS22ODS5 AGENT 0.000261 DB2 LATCH 0.000000 0.00 N/C
COLLECTION ID NULLID PAR.TASKS 0.000000 SYNCHRONOUS I/O 0.000000 0.00 N/C
PROGRAM NAME SYSSTAT SE CPU TIME 0.000069 OTHER READ I/O 0.000000 0.00 N/C
SUSPENSION-CL8 0.000980 OTHER WRITE I/O 0.000000 0.00 N/C
ACTIVITY TYPE NONNESTED AGENT 0.000980 SERV.TASK SWITCH 0.000980 2.00 0.000490
ACTIVITY NAME 'BLANK' PAR.TASKS 0.000000 ARCH.LOG(QUIESCE) 0.000000 0.00 N/C
SCHEMA NAME 'BLANK' NOT ACCOUNTED 0.005848 ARCHIVE LOG READ 0.000000 0.00 N/C
INCOMPATIBILITY NO AVG.DB2 ENTRY/EXIT 4.00 DRAIN LOCK 0.000000 0.00 N/C
SUCC AUTH CHECK 0 DB2 ENTRY/EXIT 16 CLAIM RELEASE 0.000000 0.00 N/C
OCCURRENCES 4 PAGE LATCH 0.000000 0.00 N/C
NBR OF ALLOCATIONS 4 CP CPU SU 26.50 NOTIFY MESSAGES 0.000000 0.00 N/C
SQL STMT - AVERAGE 2.00 AGENT 26.50 GLOBAL CONTENTION 0.000000 0.00 N/C
SQL STMT - TOTAL 8 PAR.TASKS 0.00 TCP/IP LOB XML 0.000000 0.00 N/C
NBR RLUP THREADS 4 SE CPU SU 7.06 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.000980 2.00 0.000490
1 LOCATION: RS22ODS5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-6
GROUP: ODS5 ACCOUNTING REPORT - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: OCC5 TO: NOT SPECIFIED
SUBSYSTEM: OCC5 ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 11/06/23 08:35:00.27
DB2 VERSION: V12 SCOPE: MEMBER TO: 11/06/23 08:35:00.27
PRIMAUTH: CSMVDQO PLANNAME: db2jcc_a
DSNADMCD VALUE DSNADMCD TIMES DSNADMCD AVERAGE TIME AVG.EV TIME/EVENT
------------------ ------------------ ------------------ ------------ ------------------ ------------ ------ ------------
TYPE PACKAGE ELAP-CL7 TIME-AVG 0.000321 LOCK/LATCH 0.000000 0.00 N/C
CP CPU TIME 0.000212 IRLM LOCK+LATCH 0.000000 0.00 N/C
LOCATION RS22ODS5 AGENT 0.000212 DB2 LATCH 0.000000 0.00 N/C
COLLECTION ID DSNADM PAR.TASKS 0.000000 SYNCHRONOUS I/O 0.000000 0.00 N/C
PROGRAM NAME DSNADMCD SE CPU TIME 0.000085 OTHER READ I/O 0.000000 0.00 N/C
SUSPENSION-CL8 0.000000 OTHER WRITE I/O 0.000000 0.00 N/C
ACTIVITY TYPE STORED PROC AGENT 0.000000 SERV.TASK SWITCH 0.000000 0.00 N/C
ACTIVITY NAME ADMIN_COMMAND_DB2 PAR.TASKS 0.000000 ARCH.LOG(QUIESCE) 0.000000 0.00 N/C
SCHEMA NAME SYSPROC NOT ACCOUNTED 0.000024 ARCHIVE LOG READ 0.000000 0.00 N/C
INCOMPATIBILITY NO AVG.DB2 ENTRY/EXIT 14.00 DRAIN LOCK 0.000000 0.00 N/C
SUCC AUTH CHECK 0 DB2 ENTRY/EXIT 56 CLAIM RELEASE 0.000000 0.00 N/C
OCCURRENCES 4 PAGE LATCH 0.000000 0.00 N/C
NBR OF ALLOCATIONS 12 CP CPU SU 21.50 NOTIFY MESSAGES 0.000000 0.00 N/C
SQL STMT - AVERAGE 8.00 AGENT 21.50 GLOBAL CONTENTION 0.000000 0.00 N/C
SQL STMT - TOTAL 32 PAR.TASKS 0.00 TCP/IP LOB XML 0.000000 0.00 N/C
NBR RLUP THREADS 4 SE CPU SU 8.68 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.000000 0.00 N/C
DSNADMCW VALUE DSNADMCW TIMES DSNADMCW AVERAGE TIME AVG.EV TIME/EVENT
------------------ ------------------ ------------------ ------------ ------------------ ------------ ------ ------------
TYPE PACKAGE ELAP-CL7 TIME-AVG 0.000118 LOCK/LATCH 0.000000 0.00 N/C
CP CPU TIME 0.000100 IRLM LOCK+LATCH 0.000000 0.00 N/C
LOCATION RS22ODS5 AGENT 0.000100 DB2 LATCH 0.000000 0.00 N/C
COLLECTION ID DSNADM PAR.TASKS 0.000000 SYNCHRONOUS I/O 0.000000 0.00 N/C
PROGRAM NAME DSNADMCW SE CPU TIME 0.000000 OTHER READ I/O 0.000000 0.00 N/C
SUSPENSION-CL8 0.000000 OTHER WRITE I/O 0.000000 0.00 N/C
ACTIVITY TYPE STORED PROC AGENT 0.000000 SERV.TASK SWITCH 0.000000 0.00 N/C
ACTIVITY NAME ADMIN_COMMAND_DB2 PAR.TASKS 0.000000 ARCH.LOG(QUIESCE) 0.000000 0.00 N/C
SCHEMA NAME SYSPROC NOT ACCOUNTED 0.000018 ARCHIVE LOG READ 0.000000 0.00 N/C
INCOMPATIBILITY NO AVG.DB2 ENTRY/EXIT 4.00 DRAIN LOCK 0.000000 0.00 N/C
SUCC AUTH CHECK 0 DB2 ENTRY/EXIT 16 CLAIM RELEASE 0.000000 0.00 N/C
OCCURRENCES 4 PAGE LATCH 0.000000 0.00 N/C
NBR OF ALLOCATIONS 4 CP CPU SU 10.00 NOTIFY MESSAGES 0.000000 0.00 N/C
SQL STMT - AVERAGE 2.00 AGENT 10.00 GLOBAL CONTENTION 0.000000 0.00 N/C
SQL STMT - TOTAL 8 PAR.TASKS 0.00 TCP/IP LOB XML 0.000000 0.00 N/C
NBR RLUP THREADS 4 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.000000 0.00 N/C
SYSSTAT AVERAGE TIME AV.EVENT SYSSTAT 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
1 LOCATION: RS22ODS5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-7
GROUP: ODS5 ACCOUNTING REPORT - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: OCC5 TO: NOT SPECIFIED
SUBSYSTEM: OCC5 ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 11/06/23 08:35:00.27
DB2 VERSION: V12 SCOPE: MEMBER TO: 11/06/23 08:35:00.27
PRIMAUTH: CSMVDQO PLANNAME: db2jcc_a
DSNADMCD AVERAGE TIME AV.EVENT DSNADMCD 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
DSNADMCW AVERAGE TIME AV.EVENT DSNADMCW 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
SYSSTAT AVERAGE TOTAL DSNADMCD AVERAGE TOTAL DSNADMCW AVERAGE TOTAL
------------------ -------- -------- ------------------ -------- -------- ------------------ -------- --------
SELECT 0.00 0 SELECT 0.00 0 SELECT 0.00 0
INSERT 0.00 0 INSERT 0.00 0 INSERT 0.00 0
UPDATE 0.00 0 UPDATE 0.00 0 UPDATE 0.00 0
DELETE 0.00 0 DELETE 0.00 0 DELETE 0.00 0
DESCRIBE 0.00 0 DESCRIBE 0.00 0 DESCRIBE 0.00 0
PREPARE 0.00 0 PREPARE 0.00 0 PREPARE 0.00 0
OPEN 0.00 0 OPEN 0.00 0 OPEN 0.00 0
FETCH 0.00 0 FETCH 0.00 0 FETCH 0.00 0
CLOSE 0.00 0 CLOSE 0.00 0 CLOSE 0.00 0
LOCK TABLE 0.00 0 LOCK TABLE 0.00 0 LOCK TABLE 0.00 0
CALL 0.00 0 CALL 0.00 0 CALL 0.00 0
SYSSTAT AVERAGE TOTAL DSNADMCD AVERAGE TOTAL DSNADMCW AVERAGE TOTAL
------------------- -------- -------- ------------------- -------- -------- ------------------- -------- --------
BPOOL HIT RATIO (%) N/C N/A BPOOL HIT RATIO (%) N/C N/A BPOOL HIT RATIO (%) N/C N/A
GETPAGES 0.00 0 GETPAGES 0.00 0 GETPAGES 0.00 0
BUFFER UPDATES 0.00 0 BUFFER UPDATES 0.00 0 BUFFER UPDATES 0.00 0
SYNCHRONOUS WRITE 0.00 0 SYNCHRONOUS WRITE 0.00 0 SYNCHRONOUS WRITE 0.00 0
SYNCHRONOUS READ 0.00 0 SYNCHRONOUS READ 0.00 0 SYNCHRONOUS READ 0.00 0
SEQ. PREFETCH REQS 0.00 0 SEQ. PREFETCH REQS 0.00 0 SEQ. PREFETCH REQS 0.00 0
LIST PREFETCH REQS 0.00 0 LIST PREFETCH REQS 0.00 0 LIST PREFETCH REQS 0.00 0
DYN. PREFETCH REQS 0.00 0 DYN. PREFETCH REQS 0.00 0 DYN. PREFETCH REQS 0.00 0
PAGES READ ASYNCHR. 0.00 0 PAGES READ ASYNCHR. 0.00 0 PAGES READ ASYNCHR. 0.00 0
ZHL SYNC. READ 0.00 0 ZHL SYNC. READ 0.00 0 ZHL SYNC. READ 0.00 0
ZHL CPU TIME READ 0.000000 0.000000 ZHL CPU TIME READ 0.000000 0.000000 ZHL CPU TIME READ 0.000000 0.000000
1 LOCATION: RS22ODS5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-8
GROUP: ODS5 ACCOUNTING REPORT - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: OCC5 TO: NOT SPECIFIED
SUBSYSTEM: OCC5 ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 11/06/23 08:35:00.27
DB2 VERSION: V12 SCOPE: MEMBER TO: 11/06/23 08:35:00.27
PRIMAUTH: CSMVDQO PLANNAME: db2jcc_a
SYSSTAT AVERAGE TOTAL DSNADMCD AVERAGE TOTAL DSNADMCW AVERAGE TOTAL
--------------------- -------- -------- --------------------- -------- -------- --------------------- -------- --------
TIMEOUTS 0.00 0 TIMEOUTS 0.00 0 TIMEOUTS 0.00 0
DEADLOCKS 0.00 0 DEADLOCKS 0.00 0 DEADLOCKS 0.00 0
ESCAL.(SHARED) 0.00 0 ESCAL.(SHARED) 0.00 0 ESCAL.(SHARED) 0.00 0
ESCAL.(EXCLUS) 0.00 0 ESCAL.(EXCLUS) 0.00 0 ESCAL.(EXCLUS) 0.00 0
MAX PG/ROW LOCKS HELD 0.00 0 MAX PG/ROW LOCKS HELD 0.00 0 MAX PG/ROW LOCKS HELD 0.00 0
LOCK REQUEST 0.00 0 LOCK REQUEST 0.00 0 LOCK REQUEST 0.00 0
UNLOCK REQUEST 0.00 0 UNLOCK REQUEST 0.00 0 UNLOCK REQUEST 0.00 0
QUERY REQUEST 0.00 0 QUERY REQUEST 0.00 0 QUERY REQUEST 0.00 0
CHANGE REQUEST 0.00 0 CHANGE REQUEST 0.00 0 CHANGE REQUEST 0.00 0
OTHER REQUEST 0.00 0 OTHER REQUEST 0.00 0 OTHER REQUEST 0.00 0
TOTAL SUSPENSIONS 0.00 0 TOTAL SUSPENSIONS 0.00 0 TOTAL SUSPENSIONS 0.00 0
LOCK SUSPENSIONS 0.00 0 LOCK SUSPENSIONS 0.00 0 LOCK SUSPENSIONS 0.00 0
IRLM LATCH SUSPENS. 0.00 0 IRLM LATCH SUSPENS. 0.00 0 IRLM LATCH SUSPENS. 0.00 0
OTHER SUSPENS. 0.00 0 OTHER SUSPENS. 0.00 0 OTHER SUSPENS. 0.00 0
AVERAGE TIMES CL. 5 IFI (CL.5)
------------------- ----------
ELAPSED TIME 0.000000
CP CPU TIME 0.000000
DCAPT.DESCR. 0.000000
LOG EXTRACT. 0.000000
1 LOCATION: RS22ODS5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-9
GROUP: ODS5 ACCOUNTING REPORT - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: OCC5 TO: NOT SPECIFIED
SUBSYSTEM: OCC5 ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 11/06/23 08:35:00.27
DB2 VERSION: V12 SCOPE: MEMBER TO: 11/06/23 08:35:00.27
PRIMAUTH: CSMVDQO PLANNAME: db2jcc_a
--------------------------------------------------------------------------------------------------------------------------------
|TRUNCATED VALUE FULL VALUE |
|::FFFF:192.168#1 ::FFFF:192.168.55.27 |
--------------------------------------------------------------------------------------------------------------------------------
ACCOUNTING REPORT COMPLETE