Accounting summary—long report (BACCTDR)
BACCTDR : ACCNTG SUMMARY, LONG 07/15/19 11:54:27 PAGE 1
SYSTEM: DB2A ACCOUNTING SUMMARY - LONG INTERVAL FROM: 05/29/19 06:00:31
SUBSYSTEM: DECD REL: 12.1 TO: 06/17/19 07:45:38
D/S GROUP: MBR: Prime AuthID: CSTCXN ACTUAL FROM: 06/07/19 11:24:47.74
LOCATION: DECD Plan Name: NGTTC11 TO: 06/07/19 11:43:36.55
ELAPSED TIME DISTRIBUTION CLASS 2 TIME DISTRIBUTION
-------------|-----------------------+------------------------| ---------------|-----------------------+------------------------|
APPL 96 % |============================================== | CPU 3 % |= |
DB2 4 % |== | SE-CPU 0 % | |
SUSP 1 % | | SUSP 19 % |========= |
| | NOTACC 78 % |====================================== |
AVERAGE APPL (CLASS 1) DB2 (CLASS 2) IFI (CLASS 5) CLASS 3 WAIT AVERAGE TIME AVG EVNT HIGHLIGHTS
------------ -------------- -------------- -------------- ------------- -------------- -------- ---------------------------
ELAPSED TIME 8.977891 0.398360 0.024612 LOCK 0:00:00.000000 0.00 #OCCURS (THREADS) 76
NONNESTED 8.977891 0.398360 N/A LATCH 0:00:00.000000 0.00 #ALLIED (THREADS) 73
STORED PROC 0.000000 0.000000 N/A SYNC I/O 0:00:00.007711 1.12 #DBAT (THREADS) 3
UDF 0.000000 0.000000 N/A DATABASE I/O 0:00:00.007682 1 #CPU PARALLELISM 0
TRIGGER 0.000000 0.000000 N/A LOG/WRT I/O 0:00:00.000029 0 #I/O PARALLELISM 0
OTHER READ 0:00:00.000609 0.03
CP CPU TIME 0.014027 0.010141 0.000611 OTHER WRITE 0:00:00.000000 0.00 #NORMAL TERM 76
AGENT 0.014027 0.010141 N/A SER.TASK SWTCH 0:00:00.067699 4.67 #ABNORMAL TERM 0
NONNESTED 0.014027 0.010141 N/A UPDATE COMMIT 0:00:00.026473 1.71 #NO PROGRAM DATA 15
STORED PRC 0.000000 0.000000 N/A OPEN/CLOSE 0:00:00.015896 0.36 #INCRBIND 0
UDF 0.000000 0.000000 N/A SYSLGRNG REC 0:00:00.000654 0.08 #COMMIT 427
TRIGGER 0.000000 0.000000 N/A EXT/DEL/DEF 0:00:00.002268 0.16 #ROLLBACK 0
PAR. TASKS 0.000000 0.000000 N/A OTHER SERVICE 0:00:00.022408 2.37 #SVPT REQUEST 0
S/E ELIGIBL 0.000000 ARC.LOG(QUIES) 0:00:00.000000 0.00 #SVPT RELEASE 0
ARC.LOG READ 0:00:00.000000 0.00 #SVPT ROLLBACK 0
S/E CPU 0.000000 0.000000 N/A DRAIN LOCK 0:00:00.000000 0.00 MAX SQL CASC LEVL 0.00
TRIGGERS 0.000000 CLAIM RELEASE 0:00:00.000000 0.00 UPDATE/COMMIT 0.26
PAGELATCH 0:00:00.000000 0.00 SYNC I/O AVG. 0.006894
SUSPEND TIME 0.000000 0.076019 N/A NOTIFY MSGS 0:00:00.000000
AGENT N/A 0.076019 0.000611 GLOBAL CONT 0:00:00.000000 0.00
PAR.TASKS N/A 0.000000 N/A ASYNC CF REQ 0.000000 0.00
STORED PR 0.000000 TCP/IP LOB 0:00:00.000000 0.00
NOT ACCOUNT N/A 0.312200 N/A CMT PH1 WRT 0:00:00.000000 0.00
DB2 ENT/EXIT N/A 44.105263 N/A TOTAL CL 3 0.076019 6
EN/EX-STPROC N/A 0.000000 N/A
EN/EX-UDF N/A 0.000000 N/A
DCAPT DESCR N/A N/A 0.000000
LOG EXTRACT N/A N/A 0.000000
SQL DML AVERAGE TOTAL SQL DCL TOTAL SQL DDL CREATE DROP ALTER LOCKING AVERAGE TOTAL
-------- -------- -------- ------------ -------- ---------- ------ ------ ------ --------------- -------- --------
SELECT 1.87 142 LOCK TABLE 0 TABLE 0 0 0 TIMEOUTS 0.00 0
INSERT 0.46 35 GRANT 0 TEMP TABLE 0 N/A N/A DEADLOCKS 0.00 0
UPDATE 0.64 49 REVOKE 0 INDEX 0 0 0 ESCAL (SHR) 0.00 0
DELETE 0.37 28 SET SQLID 0 TABLESPACE 0 0 0 ESCAL (EXCL) 0.00 0
SET HOST VAR 15 DATABASE 0 0 0 MAX LOCKS HELD 0.01 1
DESCRIBE 0.28 21 SET DEGREE 0 STOGROUP 0 0 0 LOCK REQ 43.30 3291
DESC TBL 0.00 0 SET RULES 0 SYNONYM 0 0 N/A UNLOCK REQ 7.83 595
PREPARE 2.47 188 CONNECT 1 0 VIEW 0 0 N/A QUERY REQ 0.00 0
OPEN 2.08 158 CONNECT 2 0 ALIAS 0 0 N/A CHANGE REQ 1.24 94
FETCH 3.78 287 SET CONNECT 0 PACKAGE N/A 0 N/A OTHER REQ 0.00 0
CLOSE 1.88 143 RELEASE 0 PROCEDURE 0 0 0 LOCK SUSP 0.00 0
DML-ALL 13.83 1051 CALL 0 FUNCTION 0 0 0 LATCH SUSP 0.01 1
BACCTDR : ACCNTG SUMMARY, LONG 07/15/19 11:54:27 PAGE 2
SYSTEM: DB2A ACCOUNTING SUMMARY - LONG INTERVAL FROM: 05/29/19 06:00:31
SUBSYSTEM: DECD REL: 12.1 TO: 06/17/19 07:45:38
D/S GROUP: MBR: Prime AuthID: CSTCXN ACTUAL FROM: 06/07/19 11:24:47.74
LOCATION: DECD Plan Name: NGTTC11 TO: 06/07/19 11:43:36.55
ASSOC.LOCATORS 0 TRIGGER 0 0 N/A OTHER SUSP 0.00 0
ASSOC.CURSOR 0 DIST TYPE 0 0 N/A
HOLD LOCATOR 0 SEQUENCE 0 0 0
FREE LOCATOR 0 TRUSTED CT 0 0 0 TOTAL SUSP 0.01 1
DCL-ALL 15 ROLE 0 0
SET CURR PATH 0 PERMIT/MSK 0 0 0
SET CURR PREC 0 JAR 0
TRUSTED CT 0 0 0
TOTAL 0 0 0
COMMENT ON 0
RENAME TBL 0
LABEL ON 0
RENAME INDEX 0
PREPARE RESTRICTED 0
MERGE STATEMENT 0
TRUNCATE TABLE 0
BACCTDR : ACCNTG SUMMARY, LONG 07/15/19 11:54:27 PAGE 3
SYSTEM: DB2A ACCOUNTING SUMMARY - LONG INTERVAL FROM: 05/29/19 06:00:31
SUBSYSTEM: DECD REL: 12.1 TO: 06/17/19 07:45:38
D/S GROUP: MBR: Prime AuthID: CSTCXN ACTUAL FROM: 06/07/19 11:24:47.74
LOCATION: DECD Plan Name: NGTTC11 TO: 06/07/19 11:43:36.55
NORMAL TERM AVERAGE TOTAL ABNORMAL TERM TOTAL IN DOUBT TOTAL DRAIN/CLAIM AVERAGE TOTAL
---------------- -------- -------- ------------------ -------- ------------------ ------- --------------- -------- --------
NEW USER 0.00 0 APPL PROGRAM ABEND 0 APPL PROGRAM ABEND 0 DRAIN REQ 0.00 0
DEALLOCATION 1.00 76 END OF MEMORY 0 END OF MEMORY 0 DRAIN FAIL 0.00 0
APPL PROGRAM END 0.00 0 RESOLVE IN DOUBT 0 END OF TASK 0 CLAIM REQ 30.28 2301
RESIGNON 0.00 0 CANCEL FORCE 0 CANCEL FORCE 0 CLAIM FAIL 0.00 0
DBAT INACTIVE 0.00 0
RRS COMMIT 0.00 0
TYPE 2 INACTIVE 0.00 0
END USER THRESH 0.00 0
BLK STOR THR 0.00 0
STALENESS THR 0.00 0
DATA CAPTURE AVERAGE TOTAL DATA SHARING AVERAGE TOTAL QUERY PARALLELISM AVERAGE TOTAL
---------------- -------- -------- ------------------ -------- ------- ----------------------- --------- ----------
IFI CALL 2.21 84 GLOBAL CONT RATE(%) 0.00 N/A MEMBERS USED 0.00 N/A
RECS CAPTURED 0.00 0 FALSE CONT RATE(%) 0.00 N/A MAXIMUM DEGREE N/A 0
LOG REC READ 0.00 0 L-LOCK XES RATE(%) 0.00 N/A GROUPS EXECUTED 0.00 0
ROWS RETURNED 0.00 0 LOCK REQ - PLOCKS 0.00 N/P RAN AS PLANNED 0.00 0
RECS RETURNED 0.00 0 UNLOCK REQ - PLOCKS 0.00 N/P RAN REDUCED 0.00 0
DATA DESC RETD 0.00 0 CHANGE REQ - PLOCKS 0.00 N/P ONE DB2-COORDINATOR = NO 0.00 0
TABLES RETURNED 0.00 0 LOCK REQ - XES 0.00 N/P ONE DB2-ISOLATION LEVEL 0.00 0
DESCRIBES 0.00 0 UNLOCK REQ - XES 0.00 N/P SEQUENTIAL-CURSOR 0.00 0
CHANGE REQ - XES 0.00 N/P SEQUENTIAL-NO ESA SORT 0.00 0
SUSPENDS - IRLM 0.00 N/P SEQUENTIAL-NO BUFFER 0.00 0
SUSPENDS - XES 0.00 N/P SEQUENTIAL-ENCLAVE SERVICES 0.00 0
SUSPENDS - FALSE 0.00 N/P MEMBER SKIPPED (%)
INCOMP LOCK 0.00 N/P DISABLED BY RLF 0.00 0
NOTIFY SENT 0.00 N/P REFORM PARAL-CONFIG 0.00 0
L-LOCK RATE(%) 0 N/P REFORM PARAL-NO BUF 0.00 0
ONE DB2-DCL TEMP TABLE 0 0
GLOBAL CONTENTION L-LOCKS TOTAL AV.TIME AV.EVENT GLOBAL CONT L-LOCKS ELAPSED TIME EVENTS
---------------------------------------------------------------------------------------------------------------------
L-LOCKS 00.000000 0.00 L-LOCKS 00:00.000000 0
PARENTS 00.000000 0.00 PARENTS 00:00.000000 0
CHILD 00.000000 0.00 CHILD 00:00.000000 0
OTHER 00.000000 0.00 OTHER 00:00.000000 0
GLOBAL CONTENTION P-LOCKS TOTAL AV.TIME AV.EVENT GLOBAL CONT P-LOCKS ELAPSED TIME EVENTS
---------------------------------------------------------------------------------------------------------------------
P-LOCKS 00.000000 0.00 P-LOCKS 00:00.000000 0
PAGESET PARTITION 00.000000 0.00 PAGESET PARTITION 00:00.000000 0
PAGE 00.000000 0.00 PAGE 00:00.000000 0
OTHER 00.000000 0.00 OTHER 00:00.000000 0
STORED PROC AVERAGE TOTAL UDF AVERAGE TOTAL RID LIST AVERAGE TOTAL
--------------- -------- -------- ------------- ---------- --------- ------------------ -------- --------
CALL STMT 0.00 0 EXECUTED 0.00 0 SUCCESSFUL 1.11 84
PROC ABEND 0.00 0 ABENDED 0.00 0 FAIL-STORAGE 0.00 0
CALL TIMEOUT 0.00 0 TIMED OUT 0.00 0 FAIL-LIMIT 0.00 0
CALL REJECT 0.00 0 REJECTED 0.00 0
BACCTDR : ACCNTG SUMMARY, LONG 07/15/19 11:54:27 PAGE 4
SYSTEM: DB2A ACCOUNTING SUMMARY - LONG INTERVAL FROM: 05/29/19 06:00:31
SUBSYSTEM: DECD REL: 12.1 TO: 06/17/19 07:45:38
D/S GROUP: MBR: Prime AuthID: CSTCXN ACTUAL FROM: 06/07/19 11:24:47.74
LOCATION: DECD Plan Name: NGTTC11 TO: 06/07/19 11:43:36.55
TRIGGERS AVERAGE TOTAL LOGGING AVERAGE TOTAL ROWID AVERAGE TOTAL
---------------- -------- ------- ------------------- --------- ---------- ------------- --------- ---------
STATEMENT TRIGGER 0.00 0 LOG RECORDS WRITTEN 9.18 698 DIRECT ACCESS 0.00 0
ROW TRIGGER 0.00 0 TOT BYTES WRITTEN 1610.42 122392 INDEX USED 0.00 0
SQL ERROR OCCUR 0.00 0 LOG RECORD SIZE 175 TS SCAN USED 0.00 0
AVERAGE SU CLASS 1 CLASS 2 OPTIMIZATION AVERAGE TOTAL MISCELLANEOUS AVERAGE TOTAL
------------ --------------- --------------- ---------------- -------- -------- ------------------- --------- ---------
CPU 508.91 367.93 REOPTIMIZATION 0.00 0 MAX STOR LOB VALUES 0.00 0
AGENT 508.91 367.93 PREP_STMT_MATCH 1.80 137
NONNESTED 508.91 367.93 PREP_STMT_NO_MATCH 0.67 51
STPROC 0.00 0.00 IMPLCIT_PREPARES 0.00 0
UDF 0.00 0.00 PREP_FROM_CACHE 0.00 0
TRIGGER 0.00 0.00 CACHE_LIMIT_EXCEED 0.00 0
PAR.TASKS 0.00 0.00 PREP_STMT_PURGED 0.00 0
SE CPU 0.00 0.00
BACCTDR : ACCNTG SUMMARY, LONG 07/15/19 11:54:27 PAGE 5
SYSTEM: DB2A ACCOUNTING SUMMARY - LONG INTERVAL FROM: 05/29/19 06:00:31
SUBSYSTEM: DECD REL: 12.1 TO: 06/17/19 07:45:38
D/S GROUP: MBR: Prime AuthID: CSTCXN ACTUAL FROM: 06/07/19 11:24:47.74
LOCATION: DECD Plan Name: NGTTC11 TO: 06/07/19 11:43:36.55
BP0 AVERAGE TOTAL
------------------------- -------- --------
BPOOL HIT RATIO (%) 97.44
GETPAGES 36.97 2810
BUFFER UPDATES 2.88 219
SYNCHRONOUS WRITE 0.00 0
SYNCHRONOUS READ 0.87 66
SEQUENTIAL PREFETCH REQS 0.05 4
LIST PREFETCH REQS 0.57 43
DYNAMIC PREFETCH REQS 0.00 0
PAGES READ ASYNCHR 0.08 6
BACCTDR : ACCNTG SUMMARY, LONG 07/15/19 11:54:27 PAGE 6
SYSTEM: DB2A ACCOUNTING SUMMARY - LONG INTERVAL FROM: 05/29/19 06:00:31
SUBSYSTEM: DECD REL: 12.1 TO: 06/17/19 07:45:38
D/S GROUP: MBR: Prime AuthID: CSTCXN ACTUAL FROM: 06/07/19 11:24:47.74
LOCATION: DECD Plan Name: NGTTC11 TO: 06/07/19 11:43:36.55
BP8K0 AVERAGE TOTAL
------------------------- -------- --------
BPOOL HIT RATIO (%) 96.28
GETPAGES 3.18 242
BUFFER UPDATES 0.09 7
SYNCHRONOUS WRITE 0.00 0
SYNCHRONOUS READ 0.09 7
SEQUENTIAL PREFETCH REQS 0.00 0
LIST PREFETCH REQS 0.00 0
DYNAMIC PREFETCH REQS 0.29 22
PAGES READ ASYNCHR 0.03 2
BACCTDR : ACCNTG SUMMARY, LONG 07/15/19 11:54:27 PAGE 7
SYSTEM: DB2A ACCOUNTING SUMMARY - LONG INTERVAL FROM: 05/29/19 06:00:31
SUBSYSTEM: DECD REL: 12.1 TO: 06/17/19 07:45:38
D/S GROUP: MBR: Prime AuthID: CSTCXN ACTUAL FROM: 06/07/19 11:24:47.74
LOCATION: DECD Plan Name: NGTTC11 TO: 06/07/19 11:43:36.55
BP16K0 AVERAGE TOTAL
------------------------- -------- --------
BPOOL HIT RATIO (%) 100.0
GETPAGES 0.72 55
BUFFER UPDATES 0.00 0
SYNCHRONOUS WRITE 0.00 0
SYNCHRONOUS READ 0.00 0
SEQUENTIAL PREFETCH REQS 0.00 0
LIST PREFETCH REQS 0.00 0
DYNAMIC PREFETCH REQS 0.09 7
PAGES READ ASYNCHR 0.00 0
BACCTDR : ACCNTG SUMMARY, LONG 07/15/19 11:54:27 PAGE 8
SYSTEM: DB2A ACCOUNTING SUMMARY - LONG INTERVAL FROM: 05/29/19 06:00:31
SUBSYSTEM: DECD REL: 12.1 TO: 06/17/19 07:45:38
D/S GROUP: MBR: Prime AuthID: CSTCXN ACTUAL FROM: 06/07/19 11:24:47.74
LOCATION: DECD Plan Name: NGTTC11 TO: 06/07/19 11:43:36.55
BP32K AVERAGE TOTAL
------------------------- -------- --------
BPOOL HIT RATIO (%) 65.22
GETPAGES 0.30 23
BUFFER UPDATES 0.00 0
SYNCHRONOUS WRITE 0.00 0
SYNCHRONOUS READ 0.11 8
SEQUENTIAL PREFETCH REQS 0.00 0
LIST PREFETCH REQS 0.00 0
DYNAMIC PREFETCH REQS 0.00 0
PAGES READ ASYNCHR 0.00 0
BACCTDR : ACCNTG SUMMARY, LONG 07/15/19 11:54:27 PAGE 9
SYSTEM: DB2A ACCOUNTING SUMMARY - LONG INTERVAL FROM: 05/29/19 06:00:31
SUBSYSTEM: DECD REL: 12.1 TO: 06/17/19 07:45:38
D/S GROUP: MBR: Prime AuthID: CSTCXN ACTUAL FROM: 06/07/19 11:24:47.74
LOCATION: DECD Plan Name: NGTTC11 TO: 06/07/19 11:43:36.55
BP TOT AVERAGE TOTAL
------------------------- -------- --------
BPOOL HIT RATIO (%) 97.16
GETPAGES 41.18 3130
BUFFER UPDATES 2.97 226
SYNCHRONOUS WRITE 0.00 0
SYNCHRONOUS READ 1.07 81
SEQUENTIAL PREFETCH REQS 0.05 4
LIST PREFETCH REQS 0.57 43
DYNAMIC PREFETCH REQS 0.38 29
PAGES READ ASYNCHR 0.11 8
/------- AVERAGES PER PACKAGE EXECUTION (SECTION COUNT FOR DB2 V8) -------\ /-- AVERAGE --\
PACKAGE TOTALS CPU AND ELAPSED TIMES SUSPEND WAIT TIMES EVENTS WAIT TIME/EVENT
-------------------------------- ------------------------------- -------------------------------- ------- ---------------
PACKAGE SECTION CNT 102 CL7 ELAPSED TIME 00:00.093951 LOCK 00:00.000000 0 N/P
DBRMS 0 CL7 CPU TIME 00:00.002428 LATCH 00:00.000000 0 N/P
STORED PROCEDURES 0 CL7 SE CPU TIME 00:00.000000 SYNCHRONOUS I/O 00:00.001662 0 0.006759
USER DEFINED FCNS 0 OTHER READ I/O 00:00.000150 0 0.023155
TRIGGERS 0 CL8 SUSPEND TIME 00:00.016049 OTHER WRITE I/O 00:00.000000 0 N/P
NATIVE ST PROCS 0 NOT ACCOUNTED 00:00.075473 SERV TASK SWITCH 00:00.014237 1 0.016601
NON-INLINE UDFS 0 ARCH LOG(QUIESCE) 00:00.000000 0 N/P
TOTAL EXECUTIONS 309 CPU SERVICE UNITS 88.09 ARCHIVE LOG READ 00:00.000000 0 N/P
SE CPU SERV UNITS 0.00 DRAIN LOCK 00:00.000000 0 N/P
STOR PROCS CALLED 0 CLAIM RELEASE 00:00.000000 0 N/P
UDFS SCHEDULED 0 PAGE LATCH 00:00.000000 0 N/P
NOTIFY MESSAGE 00:00.000000 0 N/P
TOTAL SQL STMTS 1851 SQL STATEMENTS AVG 6 GLOBAL CONTENTION 00:00.000000 0 N/P
TOTAL DB2 ENT/EXIT 1554 DB2 ENTRY/EXIT AVG 5 TCP/IP LOB 00:00.000000 0 N/P
TOTAL SUCC AUTH CHK 98 SUCC AUTH CHK AVG 0 ALL CL8 SUSP TYPES 00:00.016049 1 0.014458
BACCTDR : ACCNTG SUMMARY, LONG 07/15/19 11:54:27 PAGE 10
SYSTEM: DB2A ACCOUNTING SUMMARY - LONG INTERVAL FROM: 05/29/19 06:00:31
SUBSYSTEM: DECD REL: 12.1 TO: 06/17/19 07:45:38
D/S GROUP: MBR: Prime AuthID: CSTCXN ACTUAL FROM: 06/07/19 11:24:47.74
LOCATION: DECD Plan Name: NGTTC11 TO: 06/07/19 11:43:36.55
---- ACCELERATOR ACTIVITY -----------------------------------------------------------------------------------------------------
THREAD INFORMATION COUNTS: AVERAGE TOTAL TIMES: AVERAGE TOTAL
--------------------------------------- -------------------------------------- ---------------------------------------------
TOTAL THREADS 76 OCCURRENCES 3 ELAPSED TIME
ACCEL THREADS 3 CONNECTS 1.00 3 SVCS TCP/IP 0:00:00.003353 0:00:00.010059
PCT ACCEL THREADS 3.9% REQUESTS 0.00 0 ACCUM ACCEL 0:00:00.000000 0:00:00.000000
TIMED OUT 0.00 0 CPU TIME
FAILED 0.00 0 SVCS TCP/IP 0:00:00.001385 0:00:00.004154
SENT ACCUM ACCEL 0:00:00.000000 0:00:00.000000
BYTES 0.00 0 WAIT TIME
MESSAGES 0.00 0 ACCUM ACCEL 0:00:00.000000 0:00:00.000000
BLOCKS 0.00 0
ROWS 0.00 0 DB2 THREAD
RECEIVED CLASS 1
BYTES 0.00 0 ELAPSED N/A 0:00:08.977891
MESSAGES 0.00 0 CP CPU N/A 0:00:00.014027
BLOCKS 0.00 0 SE CPU N/A 0:00:00.000000
ROWS 0.00 0 CLASS 2
ELAPSED N/A 0:00:00.398360
CP CPU N/A 0:00:00.010141
SE CPU N/A 0:00:00.000000
SYSTEM: DB2A ACCOUNTING SUMMARY - LONG INTERVAL FROM: 05/29/19 06:00:31
SUBSYSTEM: DECD REL: 12.1 TO: 06/17/19 07:45:38
D/S GROUP: MBR: Prime AuthID: CSTCXN ACTUAL FROM: 06/07/19 11:24:47.74
LOCATION: DECD Plan Name: NGTTC11 TO: 06/07/19 11:43:36.55
ELAPSED TIME DISTRIBUTION CLASS 2 TIME DISTRIBUTION
-------------|-----------------------+------------------------| ---------------|-----------------------+------------------------|
APPL 96 % |============================================== | CPU 3 % |= |
DB2 4 % |== | SE-CPU 0 % | |
SUSP 1 % | | SUSP 19 % |========= |
| | NOTACC 78 % |====================================== |
AVERAGE APPL (CLASS 1) DB2 (CLASS 2) IFI (CLASS 5) CLASS 3 WAIT AVERAGE TIME AVG EVNT HIGHLIGHTS
------------ -------------- -------------- -------------- ------------- -------------- -------- ---------------------------
ELAPSED TIME 8.977891 0.398360 0.024612 LOCK 0:00:00.000000 0.00 #OCCURS (THREADS) 76
NONNESTED 8.977891 0.398360 N/A LATCH 0:00:00.000000 0.00 #ALLIED (THREADS) 73
STORED PROC 0.000000 0.000000 N/A SYNC I/O 0:00:00.007711 1.12 #DBAT (THREADS) 3
UDF 0.000000 0.000000 N/A DATABASE I/O 0:00:00.007682 1 #CPU PARALLELISM 0
TRIGGER 0.000000 0.000000 N/A LOG/WRT I/O 0:00:00.000029 0 #I/O PARALLELISM 0
OTHER READ 0:00:00.000609 0.03
CP CPU TIME 0.014027 0.010141 0.000611 OTHER WRITE 0:00:00.000000 0.00 #NORMAL TERM 76
AGENT 0.014027 0.010141 N/A SER.TASK SWTCH 0:00:00.067699 4.67 #ABNORMAL TERM 0
NONNESTED 0.014027 0.010141 N/A UPDATE COMMIT 0:00:00.026473 1.71 #NO PROGRAM DATA 15
STORED PRC 0.000000 0.000000 N/A OPEN/CLOSE 0:00:00.015896 0.36 #INCRBIND 0
UDF 0.000000 0.000000 N/A SYSLGRNG REC 0:00:00.000654 0.08 #COMMIT 427
TRIGGER 0.000000 0.000000 N/A EXT/DEL/DEF 0:00:00.002268 0.16 #ROLLBACK 0
PAR. TASKS 0.000000 0.000000 N/A OTHER SERVICE 0:00:00.022408 2.37 #SVPT REQUEST 0
S/E ELIGIBL 0.000000 ARC.LOG(QUIES) 0:00:00.000000 0.00 #SVPT RELEASE 0
ARC.LOG READ 0:00:00.000000 0.00 #SVPT ROLLBACK 0
S/E CPU 0.000000 0.000000 N/A DRAIN LOCK 0:00:00.000000 0.00 MAX SQL CASC LEVL 0.00
TRIGGERS 0.000000 CLAIM RELEASE 0:00:00.000000 0.00 UPDATE/COMMIT 0.26
PAGELATCH 0:00:00.000000 0.00 SYNC I/O AVG. 0.006894
SUSPEND TIME 0.000000 0.076019 N/A NOTIFY MSGS 0:00:00.000000
AGENT N/A 0.076019 0.000611 GLOBAL CONT 0:00:00.000000 0.00
PAR.TASKS N/A 0.000000 N/A ASYNC CF REQ 0.000000 0.00
STORED PR 0.000000 TCP/IP LOB 0:00:00.000000 0.00
NOT ACCOUNT N/A 0.312200 N/A CMT PH1 WRT 0:00:00.000000 0.00
DB2 ENT/EXIT N/A 44.105263 N/A TOTAL CL 3 0.076019 6
EN/EX-STPROC N/A 0.000000 N/A
EN/EX-UDF N/A 0.000000 N/A
DCAPT DESCR N/A N/A 0.000000
LOG EXTRACT N/A N/A 0.000000
SQL DML AVERAGE TOTAL SQL DCL TOTAL SQL DDL CREATE DROP ALTER LOCKING AVERAGE TOTAL
-------- -------- -------- ------------ -------- ---------- ------ ------ ------ --------------- -------- --------
SELECT 1.87 142 LOCK TABLE 0 TABLE 0 0 0 TIMEOUTS 0.00 0
INSERT 0.46 35 GRANT 0 TEMP TABLE 0 N/A N/A DEADLOCKS 0.00 0
UPDATE 0.64 49 REVOKE 0 INDEX 0 0 0 ESCAL (SHR) 0.00 0
DELETE 0.37 28 SET SQLID 0 TABLESPACE 0 0 0 ESCAL (EXCL) 0.00 0
SET HOST VAR 15 DATABASE 0 0 0 MAX LOCKS HELD 0.01 1
DESCRIBE 0.28 21 SET DEGREE 0 STOGROUP 0 0 0 LOCK REQ 43.30 3291
DESC TBL 0.00 0 SET RULES 0 SYNONYM 0 0 N/A UNLOCK REQ 7.83 595
PREPARE 2.47 188 CONNECT 1 0 VIEW 0 0 N/A QUERY REQ 0.00 0
OPEN 2.08 158 CONNECT 2 0 ALIAS 0 0 N/A CHANGE REQ 1.24 94
FETCH 3.78 287 SET CONNECT 0 PACKAGE N/A 0 N/A OTHER REQ 0.00 0
CLOSE 1.88 143 RELEASE 0 PROCEDURE 0 0 0 LOCK SUSP 0.00 0
DML-ALL 13.83 1051 CALL 0 FUNCTION 0 0 0 LATCH SUSP 0.01 1
BACCTDR : ACCNTG SUMMARY, LONG 07/15/19 11:54:27 PAGE 2
SYSTEM: DB2A ACCOUNTING SUMMARY - LONG INTERVAL FROM: 05/29/19 06:00:31
SUBSYSTEM: DECD REL: 12.1 TO: 06/17/19 07:45:38
D/S GROUP: MBR: Prime AuthID: CSTCXN ACTUAL FROM: 06/07/19 11:24:47.74
LOCATION: DECD Plan Name: NGTTC11 TO: 06/07/19 11:43:36.55
ASSOC.LOCATORS 0 TRIGGER 0 0 N/A OTHER SUSP 0.00 0
ASSOC.CURSOR 0 DIST TYPE 0 0 N/A
HOLD LOCATOR 0 SEQUENCE 0 0 0
FREE LOCATOR 0 TRUSTED CT 0 0 0 TOTAL SUSP 0.01 1
DCL-ALL 15 ROLE 0 0
SET CURR PATH 0 PERMIT/MSK 0 0 0
SET CURR PREC 0 JAR 0
TRUSTED CT 0 0 0
TOTAL 0 0 0
COMMENT ON 0
RENAME TBL 0
LABEL ON 0
RENAME INDEX 0
PREPARE RESTRICTED 0
MERGE STATEMENT 0
TRUNCATE TABLE 0
BACCTDR : ACCNTG SUMMARY, LONG 07/15/19 11:54:27 PAGE 3
SYSTEM: DB2A ACCOUNTING SUMMARY - LONG INTERVAL FROM: 05/29/19 06:00:31
SUBSYSTEM: DECD REL: 12.1 TO: 06/17/19 07:45:38
D/S GROUP: MBR: Prime AuthID: CSTCXN ACTUAL FROM: 06/07/19 11:24:47.74
LOCATION: DECD Plan Name: NGTTC11 TO: 06/07/19 11:43:36.55
NORMAL TERM AVERAGE TOTAL ABNORMAL TERM TOTAL IN DOUBT TOTAL DRAIN/CLAIM AVERAGE TOTAL
---------------- -------- -------- ------------------ -------- ------------------ ------- --------------- -------- --------
NEW USER 0.00 0 APPL PROGRAM ABEND 0 APPL PROGRAM ABEND 0 DRAIN REQ 0.00 0
DEALLOCATION 1.00 76 END OF MEMORY 0 END OF MEMORY 0 DRAIN FAIL 0.00 0
APPL PROGRAM END 0.00 0 RESOLVE IN DOUBT 0 END OF TASK 0 CLAIM REQ 30.28 2301
RESIGNON 0.00 0 CANCEL FORCE 0 CANCEL FORCE 0 CLAIM FAIL 0.00 0
DBAT INACTIVE 0.00 0
RRS COMMIT 0.00 0
TYPE 2 INACTIVE 0.00 0
END USER THRESH 0.00 0
BLK STOR THR 0.00 0
STALENESS THR 0.00 0
DATA CAPTURE AVERAGE TOTAL DATA SHARING AVERAGE TOTAL QUERY PARALLELISM AVERAGE TOTAL
---------------- -------- -------- ------------------ -------- ------- ----------------------- --------- ----------
IFI CALL 2.21 84 GLOBAL CONT RATE(%) 0.00 N/A MEMBERS USED 0.00 N/A
RECS CAPTURED 0.00 0 FALSE CONT RATE(%) 0.00 N/A MAXIMUM DEGREE N/A 0
LOG REC READ 0.00 0 L-LOCK XES RATE(%) 0.00 N/A GROUPS EXECUTED 0.00 0
ROWS RETURNED 0.00 0 LOCK REQ - PLOCKS 0.00 N/P RAN AS PLANNED 0.00 0
RECS RETURNED 0.00 0 UNLOCK REQ - PLOCKS 0.00 N/P RAN REDUCED 0.00 0
DATA DESC RETD 0.00 0 CHANGE REQ - PLOCKS 0.00 N/P ONE DB2-COORDINATOR = NO 0.00 0
TABLES RETURNED 0.00 0 LOCK REQ - XES 0.00 N/P ONE DB2-ISOLATION LEVEL 0.00 0
DESCRIBES 0.00 0 UNLOCK REQ - XES 0.00 N/P SEQUENTIAL-CURSOR 0.00 0
CHANGE REQ - XES 0.00 N/P SEQUENTIAL-NO ESA SORT 0.00 0
SUSPENDS - IRLM 0.00 N/P SEQUENTIAL-NO BUFFER 0.00 0
SUSPENDS - XES 0.00 N/P SEQUENTIAL-ENCLAVE SERVICES 0.00 0
SUSPENDS - FALSE 0.00 N/P MEMBER SKIPPED (%)
INCOMP LOCK 0.00 N/P DISABLED BY RLF 0.00 0
NOTIFY SENT 0.00 N/P REFORM PARAL-CONFIG 0.00 0
L-LOCK RATE(%) 0 N/P REFORM PARAL-NO BUF 0.00 0
ONE DB2-DCL TEMP TABLE 0 0
GLOBAL CONTENTION L-LOCKS TOTAL AV.TIME AV.EVENT GLOBAL CONT L-LOCKS ELAPSED TIME EVENTS
---------------------------------------------------------------------------------------------------------------------
L-LOCKS 00.000000 0.00 L-LOCKS 00:00.000000 0
PARENTS 00.000000 0.00 PARENTS 00:00.000000 0
CHILD 00.000000 0.00 CHILD 00:00.000000 0
OTHER 00.000000 0.00 OTHER 00:00.000000 0
GLOBAL CONTENTION P-LOCKS TOTAL AV.TIME AV.EVENT GLOBAL CONT P-LOCKS ELAPSED TIME EVENTS
---------------------------------------------------------------------------------------------------------------------
P-LOCKS 00.000000 0.00 P-LOCKS 00:00.000000 0
PAGESET PARTITION 00.000000 0.00 PAGESET PARTITION 00:00.000000 0
PAGE 00.000000 0.00 PAGE 00:00.000000 0
OTHER 00.000000 0.00 OTHER 00:00.000000 0
STORED PROC AVERAGE TOTAL UDF AVERAGE TOTAL RID LIST AVERAGE TOTAL
--------------- -------- -------- ------------- ---------- --------- ------------------ -------- --------
CALL STMT 0.00 0 EXECUTED 0.00 0 SUCCESSFUL 1.11 84
PROC ABEND 0.00 0 ABENDED 0.00 0 FAIL-STORAGE 0.00 0
CALL TIMEOUT 0.00 0 TIMED OUT 0.00 0 FAIL-LIMIT 0.00 0
CALL REJECT 0.00 0 REJECTED 0.00 0
BACCTDR : ACCNTG SUMMARY, LONG 07/15/19 11:54:27 PAGE 4
SYSTEM: DB2A ACCOUNTING SUMMARY - LONG INTERVAL FROM: 05/29/19 06:00:31
SUBSYSTEM: DECD REL: 12.1 TO: 06/17/19 07:45:38
D/S GROUP: MBR: Prime AuthID: CSTCXN ACTUAL FROM: 06/07/19 11:24:47.74
LOCATION: DECD Plan Name: NGTTC11 TO: 06/07/19 11:43:36.55
TRIGGERS AVERAGE TOTAL LOGGING AVERAGE TOTAL ROWID AVERAGE TOTAL
---------------- -------- ------- ------------------- --------- ---------- ------------- --------- ---------
STATEMENT TRIGGER 0.00 0 LOG RECORDS WRITTEN 9.18 698 DIRECT ACCESS 0.00 0
ROW TRIGGER 0.00 0 TOT BYTES WRITTEN 1610.42 122392 INDEX USED 0.00 0
SQL ERROR OCCUR 0.00 0 LOG RECORD SIZE 175 TS SCAN USED 0.00 0
AVERAGE SU CLASS 1 CLASS 2 OPTIMIZATION AVERAGE TOTAL MISCELLANEOUS AVERAGE TOTAL
------------ --------------- --------------- ---------------- -------- -------- ------------------- --------- ---------
CPU 508.91 367.93 REOPTIMIZATION 0.00 0 MAX STOR LOB VALUES 0.00 0
AGENT 508.91 367.93 PREP_STMT_MATCH 1.80 137
NONNESTED 508.91 367.93 PREP_STMT_NO_MATCH 0.67 51
STPROC 0.00 0.00 IMPLCIT_PREPARES 0.00 0
UDF 0.00 0.00 PREP_FROM_CACHE 0.00 0
TRIGGER 0.00 0.00 CACHE_LIMIT_EXCEED 0.00 0
PAR.TASKS 0.00 0.00 PREP_STMT_PURGED 0.00 0
SE CPU 0.00 0.00
BACCTDR : ACCNTG SUMMARY, LONG 07/15/19 11:54:27 PAGE 5
SYSTEM: DB2A ACCOUNTING SUMMARY - LONG INTERVAL FROM: 05/29/19 06:00:31
SUBSYSTEM: DECD REL: 12.1 TO: 06/17/19 07:45:38
D/S GROUP: MBR: Prime AuthID: CSTCXN ACTUAL FROM: 06/07/19 11:24:47.74
LOCATION: DECD Plan Name: NGTTC11 TO: 06/07/19 11:43:36.55
BP0 AVERAGE TOTAL
------------------------- -------- --------
BPOOL HIT RATIO (%) 97.44
GETPAGES 36.97 2810
BUFFER UPDATES 2.88 219
SYNCHRONOUS WRITE 0.00 0
SYNCHRONOUS READ 0.87 66
SEQUENTIAL PREFETCH REQS 0.05 4
LIST PREFETCH REQS 0.57 43
DYNAMIC PREFETCH REQS 0.00 0
PAGES READ ASYNCHR 0.08 6
BACCTDR : ACCNTG SUMMARY, LONG 07/15/19 11:54:27 PAGE 6
SYSTEM: DB2A ACCOUNTING SUMMARY - LONG INTERVAL FROM: 05/29/19 06:00:31
SUBSYSTEM: DECD REL: 12.1 TO: 06/17/19 07:45:38
D/S GROUP: MBR: Prime AuthID: CSTCXN ACTUAL FROM: 06/07/19 11:24:47.74
LOCATION: DECD Plan Name: NGTTC11 TO: 06/07/19 11:43:36.55
BP8K0 AVERAGE TOTAL
------------------------- -------- --------
BPOOL HIT RATIO (%) 96.28
GETPAGES 3.18 242
BUFFER UPDATES 0.09 7
SYNCHRONOUS WRITE 0.00 0
SYNCHRONOUS READ 0.09 7
SEQUENTIAL PREFETCH REQS 0.00 0
LIST PREFETCH REQS 0.00 0
DYNAMIC PREFETCH REQS 0.29 22
PAGES READ ASYNCHR 0.03 2
BACCTDR : ACCNTG SUMMARY, LONG 07/15/19 11:54:27 PAGE 7
SYSTEM: DB2A ACCOUNTING SUMMARY - LONG INTERVAL FROM: 05/29/19 06:00:31
SUBSYSTEM: DECD REL: 12.1 TO: 06/17/19 07:45:38
D/S GROUP: MBR: Prime AuthID: CSTCXN ACTUAL FROM: 06/07/19 11:24:47.74
LOCATION: DECD Plan Name: NGTTC11 TO: 06/07/19 11:43:36.55
BP16K0 AVERAGE TOTAL
------------------------- -------- --------
BPOOL HIT RATIO (%) 100.0
GETPAGES 0.72 55
BUFFER UPDATES 0.00 0
SYNCHRONOUS WRITE 0.00 0
SYNCHRONOUS READ 0.00 0
SEQUENTIAL PREFETCH REQS 0.00 0
LIST PREFETCH REQS 0.00 0
DYNAMIC PREFETCH REQS 0.09 7
PAGES READ ASYNCHR 0.00 0
BACCTDR : ACCNTG SUMMARY, LONG 07/15/19 11:54:27 PAGE 8
SYSTEM: DB2A ACCOUNTING SUMMARY - LONG INTERVAL FROM: 05/29/19 06:00:31
SUBSYSTEM: DECD REL: 12.1 TO: 06/17/19 07:45:38
D/S GROUP: MBR: Prime AuthID: CSTCXN ACTUAL FROM: 06/07/19 11:24:47.74
LOCATION: DECD Plan Name: NGTTC11 TO: 06/07/19 11:43:36.55
BP32K AVERAGE TOTAL
------------------------- -------- --------
BPOOL HIT RATIO (%) 65.22
GETPAGES 0.30 23
BUFFER UPDATES 0.00 0
SYNCHRONOUS WRITE 0.00 0
SYNCHRONOUS READ 0.11 8
SEQUENTIAL PREFETCH REQS 0.00 0
LIST PREFETCH REQS 0.00 0
DYNAMIC PREFETCH REQS 0.00 0
PAGES READ ASYNCHR 0.00 0
BACCTDR : ACCNTG SUMMARY, LONG 07/15/19 11:54:27 PAGE 9
SYSTEM: DB2A ACCOUNTING SUMMARY - LONG INTERVAL FROM: 05/29/19 06:00:31
SUBSYSTEM: DECD REL: 12.1 TO: 06/17/19 07:45:38
D/S GROUP: MBR: Prime AuthID: CSTCXN ACTUAL FROM: 06/07/19 11:24:47.74
LOCATION: DECD Plan Name: NGTTC11 TO: 06/07/19 11:43:36.55
BP TOT AVERAGE TOTAL
------------------------- -------- --------
BPOOL HIT RATIO (%) 97.16
GETPAGES 41.18 3130
BUFFER UPDATES 2.97 226
SYNCHRONOUS WRITE 0.00 0
SYNCHRONOUS READ 1.07 81
SEQUENTIAL PREFETCH REQS 0.05 4
LIST PREFETCH REQS 0.57 43
DYNAMIC PREFETCH REQS 0.38 29
PAGES READ ASYNCHR 0.11 8
/------- AVERAGES PER PACKAGE EXECUTION (SECTION COUNT FOR DB2 V8) -------\ /-- AVERAGE --\
PACKAGE TOTALS CPU AND ELAPSED TIMES SUSPEND WAIT TIMES EVENTS WAIT TIME/EVENT
-------------------------------- ------------------------------- -------------------------------- ------- ---------------
PACKAGE SECTION CNT 102 CL7 ELAPSED TIME 00:00.093951 LOCK 00:00.000000 0 N/P
DBRMS 0 CL7 CPU TIME 00:00.002428 LATCH 00:00.000000 0 N/P
STORED PROCEDURES 0 CL7 SE CPU TIME 00:00.000000 SYNCHRONOUS I/O 00:00.001662 0 0.006759
USER DEFINED FCNS 0 OTHER READ I/O 00:00.000150 0 0.023155
TRIGGERS 0 CL8 SUSPEND TIME 00:00.016049 OTHER WRITE I/O 00:00.000000 0 N/P
NATIVE ST PROCS 0 NOT ACCOUNTED 00:00.075473 SERV TASK SWITCH 00:00.014237 1 0.016601
NON-INLINE UDFS 0 ARCH LOG(QUIESCE) 00:00.000000 0 N/P
TOTAL EXECUTIONS 309 CPU SERVICE UNITS 88.09 ARCHIVE LOG READ 00:00.000000 0 N/P
SE CPU SERV UNITS 0.00 DRAIN LOCK 00:00.000000 0 N/P
STOR PROCS CALLED 0 CLAIM RELEASE 00:00.000000 0 N/P
UDFS SCHEDULED 0 PAGE LATCH 00:00.000000 0 N/P
NOTIFY MESSAGE 00:00.000000 0 N/P
TOTAL SQL STMTS 1851 SQL STATEMENTS AVG 6 GLOBAL CONTENTION 00:00.000000 0 N/P
TOTAL DB2 ENT/EXIT 1554 DB2 ENTRY/EXIT AVG 5 TCP/IP LOB 00:00.000000 0 N/P
TOTAL SUCC AUTH CHK 98 SUCC AUTH CHK AVG 0 ALL CL8 SUSP TYPES 00:00.016049 1 0.014458
BACCTDR : ACCNTG SUMMARY, LONG 07/15/19 11:54:27 PAGE 10
SYSTEM: DB2A ACCOUNTING SUMMARY - LONG INTERVAL FROM: 05/29/19 06:00:31
SUBSYSTEM: DECD REL: 12.1 TO: 06/17/19 07:45:38
D/S GROUP: MBR: Prime AuthID: CSTCXN ACTUAL FROM: 06/07/19 11:24:47.74
LOCATION: DECD Plan Name: NGTTC11 TO: 06/07/19 11:43:36.55
---- ACCELERATOR ACTIVITY -----------------------------------------------------------------------------------------------------
THREAD INFORMATION COUNTS: AVERAGE TOTAL TIMES: AVERAGE TOTAL
--------------------------------------- -------------------------------------- ---------------------------------------------
TOTAL THREADS 76 OCCURRENCES 3 ELAPSED TIME
ACCEL THREADS 3 CONNECTS 1.00 3 SVCS TCP/IP 0:00:00.003353 0:00:00.010059
PCT ACCEL THREADS 3.9% REQUESTS 0.00 0 ACCUM ACCEL 0:00:00.000000 0:00:00.000000
TIMED OUT 0.00 0 CPU TIME
FAILED 0.00 0 SVCS TCP/IP 0:00:00.001385 0:00:00.004154
SENT ACCUM ACCEL 0:00:00.000000 0:00:00.000000
BYTES 0.00 0 WAIT TIME
MESSAGES 0.00 0 ACCUM ACCEL 0:00:00.000000 0:00:00.000000
BLOCKS 0.00 0
ROWS 0.00 0 DB2 THREAD
RECEIVED CLASS 1
BYTES 0.00 0 ELAPSED N/A 0:00:08.977891
MESSAGES 0.00 0 CP CPU N/A 0:00:00.014027
BLOCKS 0.00 0 SE CPU N/A 0:00:00.000000
ROWS 0.00 0 CLASS 2
ELAPSED N/A 0:00:00.398360
CP CPU N/A 0:00:00.010141
SE CPU N/A 0:00:00.000000
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*