Accounting detail trace—long report (BACCTLT)
1 BACCTLT : ACCNTG DETAIL TRACE, LONG 03/01/21 06:20:51 PAGE 86
LOCATION: DEGX ACCOUNTING DETAIL TRACE - LONG GROUP: N/A MEMBER: N/A
SUBSYSTEM: DEGX 10.1 ACTUAL FROM: 02/28/21 21:35:07.49
THREAD IDENTIFICATION ----------------------------------------------------------------------------------------------------------
THRD TSTAMP : 03/01/21 06:20:14.79 PRIMAUTH: MAINT WLM SCLS: DDF LUWID : AC183082.G576.D95601FB343C
BEGIN TIME : 02/28/21 21:35:00.48 ORIGAUTH: MAINT LUW SEQ : 0000
END TIME : 03/01/21 06:20:14.79 CORRNAME: db2jcc_appli ENDUSER : maint
REQUESTER : FFFF:172.24.48.1 CONNECT : SERVER CONNTYPE: DRDA TRANSACT: db2jcc_application
REQ PROD ID : JCC04280 PLANNAME: DISTSERV PKG CNT : 1761 WSNAME : 172.24.48.130
REQ PROD VER: 04 FRST PKG: *ROLLUP*
REQ ACCT STR:
ACCT TOKEN : ACCOUNTING TOKEN(HEX): 0000000000000000
TIMES/EVENTS APPL (CLASS 1) DB2 (CLASS 2) IFI (CLASS 5) CLASS 3 WAIT ELAPSED TIME EVENTS HIGHLIGHTS
------------ -------------- -------------- -------------- ------------------------------------ ---------------------------------
ELAPSED TIME 0:05:42.352173 0:03:35.129837 0:00:00.000000 LOCK 0:00:00.007317 11 #OCCURS : 17610
NONNESTED 0:05:42.352173 0:03:35.129837 N/A LATCH 0:00:00.000016 40 #ALLIED : 0
STORPROC 0:00:00.000000 0:00:00.000000 N/A SYNC I/O 0:00:24.892813 19537 #DBAT-DIST : 17610
UDF 0:00:00.000000 0:00:00.000000 N/A DATABSE I/O 0:00:01.211699 2197 #NO PROGRAM DATA : 0
TRIGGER 0:00:00.000000 0:00:00.000000 N/A LOG/WRT I/O 0:00:23.681114 17340 DDF ACCESSES : 1761
OTHER READ 0:00:00.002748 6 COMMIT : 17621
CPU TIME 0:00:35.429174 0:00:30.687194 0:00:00.000000 OTHER WRITE 0:00:00.000925 1 ROLLBACK : 0
AGENT 0:00:35.429174 0:00:30.687194 N/A SERVICE TASK 0:00:00.436100 72 INCR BIND : 0
NONNESTED 0:00:35.429174 0:00:30.687194 0:00:00.000000 UPDT COMMIT 0:00:00.000000 0 UPDATE/COMMIT : 3
STOR PROC 0:00:00.000000 0:00:00.000000 N/A OPEN/CLOSE 0:00:00.000000 0 PROGRAMS : 1
UDF 0:00:00.000000 0:00:00.000000 N/A SYSLNG REC 0:00:00.220838 70 #SVPT REQ : 0
TRIGGER 0:00:00.000000 0:00:00.000000 N/A EXT/DEL/DEF 0:00:00.215261 2 #SVPT REL : 0
PARAL TSKS 0:00:00.000000 0:00:00.000000 N/A OTH SRVCE 0:00:00.000000 0 #SVPT RBK : 0
IIP CPU 0:00:49.734974 0:00:43.947723 N/A ARC.LOG QUIS 0:00:00.000000 0 MAX SQL : 0
IIP CP CPU 0:00:00.021727 ARC.LOG READ 0:00:00.000000 0 SQL CALL WT STPRC: 0
IIP CP TCP/IP LOB 0:00:00.000000 0 SYNCH I/O AVG : 0.001274
TRIG CPU 0:00:00.000000 0:00:00.000000 DRAIN LOCK 0:00:00.000000 0 #CP/X PARALLEL : 1761
STORED PR 0:00:00.000000 0:00:00.000000 CLAIM RLSE 0:00:00.000000 0 #IO PARALLELISM : 0
UDF 0:00:00.000000 0:00:00.000000 PAGE LATCH 0:00:00.000000 0 PARALLEL : CPU
SUSPEND TIME 0:00:00.000000 0:00:25.339919 N/A NOTIFY MSGS 0:00:00.000000 0 THRD TYPE : DBAT DDF
AGENT N/A 0:00:25.339919 N/A GLOBAL CONT 0:00:00.000000 0 TERM COND: ACCUM DATA:OCCUR LIMIT
UDF SCHED 0:00:00.000000 CMT PH1 WRT 0:00:00.000000 0 NORMAL TERMINAT : 0
PAR. TAKS N/A 0:00:00.000000 N/A ASYNC IXL RQ 0.000000 N/A ABNORMAL TERMINAT: 0
STORPROC 0:00:00.000000 TOTAL CL 3 0:00:25.339919 19647
NOT ACCOUNT N/A 115.155001 N/A
DB2 ENT/EXIT N/A 1054402.000000 N/A
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 TOTAL SQL DCL TOTAL SQL DDL: CREATE DROP ALTER LOCKING TOTAL DATA SHARING TOTAL
----------------- --------------------- ---------- ------ ------ ------ ----------------------- ---------------------
SELECT 0 LOCK TABLE 0 TABLE 0 0 0 TIMEOUTS 0 LOCK REQ N/P
INSERT 51856 GRANT 0 CRT TABLE 0 DEADLOCKS 0 UNLOCK REQ N/P
UPDATE 5238 REVOKE 0 DCL TABLE 0 ESCAL (SHR) 0 CHANGE REQ N/P
DELETE 1 SET SQLID 0 AUX TABLE 0 ESCAL (EXCL) 0 LOCK -XES N/P
DESCRIBE 102867 SET HOST VAR 0 INDEX 0 0 0 MAX LOCKS HELD 12428 UNLOCK -XES N/P
DESC TBL 0 SET DEGREE 0 TABLESPACE 0 0 0 LOCK REQ 266429 CHANGE -XES N/P
PREPARE 224465 SET RULES 0 DATABASE 0 0 0 UNLOCK REQ 21116 SUSP -IRLM N/P
OPEN 165199 SET CUR PATH 0 STOGROUP 0 0 0 FALSE CONT N/P
FETCH 0 SET CUR PREC 0 SYNONYM 0 0 N/A
1 BACCTLT : ACCNTG DETAIL TRACE, LONG 03/01/21 06:20:51 PAGE 87
LOCATION: DEGX ACCOUNTING DETAIL TRACE - LONG GROUP: N/A MEMBER: N/A
SUBSYSTEM: DEGX 10.1 ACTUAL FROM: 02/28/21 21:35:07.49
CLOSE 0 CONNECT 1 0 VIEW 0 0 0 QUERY REQ 0 SUSP -XES N/P
CONNECT 2 0 ALIAS 0 0 N/A CHANGE REQ 7987 SUSP -FALSE N/P
SET CONNECT 0 PROCEDURE 0 0 0 OTHER REQ 0 INCOMP LOCK N/P
RELEASE 0 FUNCTION 0 0 0 LOCK SUSP 0 NOTIFY SENT N/P
CALL 0 TRIGGER 0 0 LATCH SUSP 11 L-LOCK RATE% 0
ASSOC LOC 0 DIST TYPE 0 0 OTHER SUSP 0
ALLOC CRSR 0 PACKAGE N/A 0 N/A TOTAL SUSP 11
HOLD LOCTR 0 SEQUENCE 0 0 0
FREE LOCTR 0 TRUSTED CT 0 0 0
DML-ALL 549626 DCL-ALL 0 PERMIT/MSK 0 0 0
ROLE 0 0
JAR 0
TOTAL 0 0 0
RENAME TBL 0
COMMENT ON 0
LABEL ON 0
TRUNCATE 0
MERGE 0
RENAME INDEX 0
PREPARE RESTRICTED 0
MERGE STATEMENT 0
TRUNCATE TABLE 0
DYNAMIC SQL STATEMENT (TOTAL) LOGGING TRIGGERS USER DEFINED FUNCTIONS
----------------------------- -------------------------------- ----------------------- ------------------------
REOPTIMIZATION 0 LOG RECORDS WRITTEN 1682359 STMT TRIGGERS 0 EXECUTED 0
NOT FOUND IN CACHE 2749 TOT BYTES WRITTEN 17042G ROW TRIGGER 0 ABENDED 0
FOUND IN CACHE 221716 LOG RECORD SIZE (AVG) 10129834 SQL ERR OCCUR 0 TIMED OUT 0
IMPLICIT PREPARES 0 REJECTED 0
PREPARES AVOIDED 0 MISCELLANEOUS
CACHE LIMIT EXCEEDED 0 --------------------------------
PREP STMT PURGED 0 MAX STG USED FOR LOBS 0
ROWS FETCHED 164622 MAX STG USED FOR XMLS 0
ROWS INSERTED 626742
ROWS UPDATED 5238
ROWS DELETED 0
DB2 PARSE STATEMENTS 0
DB2 REPLACE STMT 0
DB2 MATCHING REUS 0
DB2 CREATE DUPLICATE 0
NORMAL TERMINATION TOTALS ABNORMAL TERMINATION TOTALS AVERAGE SERVICE UNITS CLASS 1 CLASS 2
----------------------------------- --------------------------- -------------------------------------------------
NEW USER 0 APPLICATION ABEND 0 CPU 1346476.91 1166259.16
DEALLOCATION 0 END OF MEMORY 0 AGENT 1346476.91 1166259.16
APPL PROGRAM END 0 RESOLVE INDOUBT 0 NONNESTED 1346476.91 1166259.16
RESIGNON 0 STOP FORCE 0 STORED PRC 0.00 0.00
DBAT INACTIVE 0 UDF 0.00 0.00
RRS COMMIT 0 TRIGGER 0.00 0.00
DDF TYPE 2 INACTIVE 0 PARAL TASKS 0.00 0.00
END USER THRESH DDF/RRSAF 0 IIP CPU 1890165.27 1670222.26
BLK STOR THRESH DDF/RRSAF 0
STALENESS THRESH DDF/RRSAF 0
1 BACCTLT : ACCNTG DETAIL TRACE, LONG 03/01/21 06:20:51 PAGE 88
LOCATION: DEGX ACCOUNTING DETAIL TRACE - LONG GROUP: N/A MEMBER: N/A
SUBSYSTEM: DEGX 10.1 ACTUAL FROM: 02/28/21 21:35:07.49
ROWID TOTALS
-----------------------------------------------
DIRECT ACCESS 0
INDEX USED 0
TS SCAN USED 0
RID LIST TOTAL PARALLELISM TOTAL STORED PROC TOTAL DRAIN/CLAIM TOTAL DATA CAPTURE TOTAL
--------------------- --------------------------- --------------------- ----------------------- ------------------------
SUCCESSFUL 0 MAX MEMBERS USED 0 CALL STMT 0 DRAIN REQ 0 IFI CALL N/P
FAIL-STORAGE 0 MAXIMUM DEGREE 0 PROC ABEND 0 DRAIN FAIL 0 RECS CAPTURED N/P
FAIL-LIMIT 0 GROUPS EXECUTED 0 CALL TIMEOUT 0 CLAIM REQ 346425 LOG REC READ N/P
RID OFW WRKF 0 PLANNED DEGREE 0 CALL REJECT 0 CLAIM FAIL 0 ROWS RETURNED N/P
RID OFW EXTI 0 REDUCED DEGREE 0 RECS RETURNED N/P
HYB JOIN-STG 0 DB2-COORD = NO 0 DATA DESC RETD N/P
HYB JOIN-INT 0 DB2 ISOLATN LVL 0 TABLES RETURNED N/P
MIAC SKIPPED 0 DB2-DCL TEMP TBL 0 DESCRIBES N/P
FALLBACK-CURSOR 0
FALLBACK-NO ESA 0
FALLBACK-NO BUFF 0
FALLBACK-NO ENCL N/P
MEMBER SKIPPED (%) 0
PARALLEL DISABLD NONE
REFRM PARAL CNFG 0
REFRM PARAL NOBUF 0
---- RESOURCE LIMIT FACILITY --------------------------------------------------------------------------------
TYPE: NONE TABLE ID: SERV UNITS: N/A CPU SECS: N/A MAX CPU SECS: N/A
GLOBAL CONTENTION ELAPSED TIME EVENTS AVG ELAPSED/EVENT
-----------------------------------------------------------------------------
L-LOCKS 0:00:00.000000 0 N/P
PARENTS 0:00:00.000000 0 N/P
CHILD 0:00:00.000000 0 N/P
OTHER 0:00:00.000000 0 N/P
P-LOCKS 0:00:00.000000 0 N/P
PAGESET PARTITION 0:00:00.000000 0 N/P
PAGE 0:00:00.000000 0 N/P
OTHER 0:00:00.000000 0 N/P
1 BACCTLT : ACCNTG DETAIL TRACE, LONG 03/01/21 06:20:51 PAGE 89
LOCATION: DEGX ACCOUNTING DETAIL TRACE - LONG GROUP: N/A MEMBER: N/A
SUBSYSTEM: DEGX 10.1 ACTUAL FROM: 02/28/21 21:35:07.49
---- BUFFER POOL ACTIVITY ------------------- --- GROUP BUFFER POOL ACTIVITY ------------------------------------------------
BP0 GBP0 (IF APPLICABLE)
------------------------------------ ----------------------------------------------------------------------------
BPOOL HIT RATIO (%) 100 GBP-DEPEND GETPAGES READ(NF) DATA RETURNED
GETPAGE REQUESTS 211659 READ(XI) DATA RETURNED READ(NF) NO DATA RETURNED
GETPAGES - FAILED 0 READ(XI) NO DATA RETURNED READ(NF) R/W INTEREST
BUFFER UPDATES 0 READ(XI) R/W INTEREST READ(NF) NO R/W INTEREST
SEQUENTIAL PREFETCH 0 CLEAN PAGES WRITTEN CHANGED PAGES WRITTEN
LIST PREFETCH REQUEST 0 UNREGISTER PAGE WRITE REGISTER SNGL RQTS
SYNCHRONOUS READ I/O 0 WRITE REGISTER MULT RQTS ASYNCH GBP REQUESTS
SYNCHRONOUS WRITE I/O 0 EXPLICIT X-INVALID
DYNAMIC PREFETCH 5496 ASYNCH SEC-GBP REQ PG P-LOCK UNLOCK REQ
PAGES READ ASYNCHRONOUSLY 0 PG P-LOCK LOCK REQ PG P-LOCK LOCK SUSP
SPACE MAP PAGES SPACE MAP PAGES
DATA PAGES DATA PAGES
INDEX LEAF PAGES INDEX LEAF PAGES
BP4 GBP4 (IF APPLICABLE)
------------------------------------ ----------------------------------------------------------------------------
BPOOL HIT RATIO (%) 98 GBP-DEPEND GETPAGES READ(NF) DATA RETURNED
GETPAGE REQUESTS 144505 READ(XI) DATA RETURNED READ(NF) NO DATA RETURNED
GETPAGES - FAILED 0 READ(XI) NO DATA RETURNED READ(NF) R/W INTEREST
BUFFER UPDATES 671496 READ(XI) R/W INTEREST READ(NF) NO R/W INTEREST
SEQUENTIAL PREFETCH 0 CLEAN PAGES WRITTEN CHANGED PAGES WRITTEN
LIST PREFETCH REQUEST 0 UNREGISTER PAGE WRITE REGISTER SNGL RQTS
SYNCHRONOUS READ I/O 2121 WRITE REGISTER MULT RQTS ASYNCH GBP REQUESTS
SYNCHRONOUS WRITE I/O 0 EXPLICIT X-INVALID
DYNAMIC PREFETCH 46 ASYNCH SEC-GBP REQ PG P-LOCK UNLOCK REQ
PAGES READ ASYNCHRONOUSLY 81 PG P-LOCK LOCK REQ PG P-LOCK LOCK SUSP
SPACE MAP PAGES SPACE MAP PAGES
DATA PAGES DATA PAGES
INDEX LEAF PAGES INDEX LEAF PAGES
BP8K0 GBP8K0 (IF APPLICABLE)
------------------------------------ ----------------------------------------------------------------------------
BPOOL HIT RATIO (%) 100 GBP-DEPEND GETPAGES READ(NF) DATA RETURNED
GETPAGE REQUESTS 5497 READ(XI) DATA RETURNED READ(NF) NO DATA RETURNED
GETPAGES - FAILED 0 READ(XI) NO DATA RETURNED READ(NF) R/W INTEREST
BUFFER UPDATES 0 READ(XI) R/W INTEREST READ(NF) NO R/W INTEREST
SEQUENTIAL PREFETCH 0 CLEAN PAGES WRITTEN CHANGED PAGES WRITTEN
LIST PREFETCH REQUEST 0 UNREGISTER PAGE WRITE REGISTER SNGL RQTS
SYNCHRONOUS READ I/O 0 WRITE REGISTER MULT RQTS ASYNCH GBP REQUESTS
SYNCHRONOUS WRITE I/O 0 EXPLICIT X-INVALID
DYNAMIC PREFETCH 2059 ASYNCH SEC-GBP REQ PG P-LOCK UNLOCK REQ
PAGES READ ASYNCHRONOUSLY 0 PG P-LOCK LOCK REQ PG P-LOCK LOCK SUSP
SPACE MAP PAGES SPACE MAP PAGES
DATA PAGES DATA PAGES
INDEX LEAF PAGES INDEX LEAF PAGES
1 BACCTLT : ACCNTG DETAIL TRACE, LONG 03/01/21 06:20:51 PAGE 90
LOCATION: DEGX ACCOUNTING DETAIL TRACE - LONG GROUP: N/A MEMBER: N/A
SUBSYSTEM: DEGX 10.1 ACTUAL FROM: 02/28/21 21:35:07.49
BP16K0 GBP16K0 (IF APPLICABLE)
------------------------------------ ----------------------------------------------------------------------------
BPOOL HIT RATIO (%) 100 GBP-DEPEND GETPAGES READ(NF) DATA RETURNED
GETPAGE REQUESTS 12 READ(XI) DATA RETURNED READ(NF) NO DATA RETURNED
GETPAGES - FAILED 0 READ(XI) NO DATA RETURNED READ(NF) R/W INTEREST
BUFFER UPDATES 6 READ(XI) R/W INTEREST READ(NF) NO R/W INTEREST
SEQUENTIAL PREFETCH 0 CLEAN PAGES WRITTEN CHANGED PAGES WRITTEN
LIST PREFETCH REQUEST 0 UNREGISTER PAGE WRITE REGISTER SNGL RQTS
SYNCHRONOUS READ I/O 0 WRITE REGISTER MULT RQTS ASYNCH GBP REQUESTS
SYNCHRONOUS WRITE I/O 0 EXPLICIT X-INVALID
DYNAMIC PREFETCH 0 ASYNCH SEC-GBP REQ PG P-LOCK UNLOCK REQ
PAGES READ ASYNCHRONOUSLY 0 PG P-LOCK LOCK REQ PG P-LOCK LOCK SUSP
SPACE MAP PAGES SPACE MAP PAGES
DATA PAGES DATA PAGES
INDEX LEAF PAGES INDEX LEAF PAGES
BP32K GBP32K (IF APPLICABLE)
------------------------------------ ----------------------------------------------------------------------------
BPOOL HIT RATIO (%) 100 GBP-DEPEND GETPAGES READ(NF) DATA RETURNED
GETPAGE REQUESTS 1354794 READ(XI) DATA RETURNED READ(NF) NO DATA RETURNED
GETPAGES - FAILED 0 READ(XI) NO DATA RETURNED READ(NF) R/W INTEREST
BUFFER UPDATES 915246 READ(XI) R/W INTEREST READ(NF) NO R/W INTEREST
SEQUENTIAL PREFETCH 0 CLEAN PAGES WRITTEN CHANGED PAGES WRITTEN
LIST PREFETCH REQUEST 0 UNREGISTER PAGE WRITE REGISTER SNGL RQTS
SYNCHRONOUS READ I/O 76 WRITE REGISTER MULT RQTS ASYNCH GBP REQUESTS
SYNCHRONOUS WRITE I/O 0 EXPLICIT X-INVALID
DYNAMIC PREFETCH 8 ASYNCH SEC-GBP REQ PG P-LOCK UNLOCK REQ
PAGES READ ASYNCHRONOUSLY 0 PG P-LOCK LOCK REQ PG P-LOCK LOCK SUSP
SPACE MAP PAGES SPACE MAP PAGES
DATA PAGES DATA PAGES
INDEX LEAF PAGES INDEX LEAF PAGES
BP TOT GBP TOT (IF APPLICABLE)
------------------------------------ ----------------------------------------------------------------------------
BPOOL HIT RATIO (%) 100 GBP-DEPEND GETPAGES N/P READ(NF) DATA RETURNED N/P
GETPAGE REQUESTS 1716467 READ(XI) DATA RETURNED N/P READ(NF) NO DATA RETURNED N/P
GETPAGES - FAILED 0 READ(XI) NO DATA RETURNED N/P READ(NF) R/W INTEREST N/P
BUFFER UPDATES 1586748 READ(XI) R/W INTEREST N/P READ(NF) NO R/W INTEREST N/P
SEQUENTIAL PREFETCH 0 CLEAN PAGES WRITTEN N/P CHANGED PAGES WRITTEN N/P
LIST PREFETCH REQUEST 0 UNREGISTER PAGE N/P WRITE REGISTER SNGL RQTS N/P
SYNCHRONOUS READ I/O 2197 WRITE REGISTER MULT RQTS N/P ASYNCH GBP REQUESTS N/P
SYNCHRONOUS WRITE I/O 0 EXPLICIT X-INVALID N/P
DYNAMIC PREFETCH 7609 ASYNCH SEC-GBP REQ N/P PG P-LOCK UNLOCK REQ N/P
PAGES READ ASYNCHRONOUSLY 81 PG P-LOCK LOCK REQ 0 PG P-LOCK LOCK SUSP 0
SPACE MAP PAGES N/P SPACE MAP PAGES N/P
DATA PAGES N/P DATA PAGES N/P
INDEX LEAF PAGES N/P INDEX LEAF PAGES N/P
1 BACCTLT : ACCNTG DETAIL TRACE, LONG 03/01/21 06:20:51 PAGE 91
LOCATION: DEGX ACCOUNTING DETAIL TRACE - LONG GROUP: N/A MEMBER: N/A
SUBSYSTEM: DEGX 10.1 ACTUAL FROM: 02/28/21 21:35:07.49
---- INITIAL OTHER REQUESTER CORRELATION ---------------------------------------------------------------------------------------
PRODUCT ID : JCC
PRODUCT VERSION: 04 28 0
STRING : 172.24.48.130 db2jcc_application maint .JCC04280172.24.48.130
---- DISTRIBUTED DATA FACILITY ACTIVITY ---------------------------------------------------------------------------------------
*******************************************************************************************************************
* REMOTE LOCATION: ::FFFF:172.24.48 ( SERVER ) PROTOCOL: APPL DIRECTED PRODUCT ID: JCC04280 *
* *
* TIME WAITING FOR A DB ACCESS AGENT (POSSIBLY MAXDBATS) 3.022833 *
* ELAPSED TIME PROCESSING REQUEST AT REMOTE SITE 0.045370 *
*******************************************************************************************************************
DESCRIPTION TOTAL DESCRIPTION TOTAL
-------------------------------------- ---------- ------------------------------------- ----------
TRANSACTIONS SENT N/A TRANSACTIONS RECEIVED N/A
SINGLE-PHASE COMMITS SENT 0 SINGLE-PHASE COMMITS RECEIVED 17655
ROLLBACKS SENT 0 ROLLBACKS RECEIVED 0
SQL STATEMENTS SENT 0 SQL STATEMENTS RECEIVED 509637
ROWS SENT 164622 ROWS RECEIVED 0
MESSAGES SENT 527419 MESSAGES RECEIVED 527419
BYTES SENT 169474K BYTES RECEIVED 295859K
BLOCKS SENT 330398 BLOCKS RECEIVED 0
CONVERSATIONS SENT 0
CONVERSATIONS QUEUED 0 MAXIMUM CONVERSATIONS ACTIVE
CONVERSATIONS ALLOCATED CONVERSATIONS TERMINATED 0
SWITCH TO LIMITED BLOCK FETCH MESSAGES IN BUFFER
SQL STATEMENTS BOUND AT SERVER ROLLBACKS W/REMOTE COORDINATOR
PREPARE REQUESTS SENT PREPARE REQUESTS RECEIVED
LAST AGENT REQUESTS SENT LAST AGENT REQUESTS RECEIVED
TWO-PHASE COMMITS SENT TWO-PHASE COMMITS RECEIVED
BACKOUT REQUESTS SENT BACKOUT REQUESTS RECEIVED
FORGET RESPONSES SENT FORGET RESPONSES RECEIVED
REQUEST COMMIT RESPONSES SENT REQUEST COMMIT RESPONSES RECEIVED
BACKOUT RESPONSES SENT BACKOUT RESPONSES RECEIVED
THREADS INDOUBT W/REMOTE COORDINATOR 0 TWO-PHASE COMMITS PERFORMED
CONVERSATIONS INIT BY REQUESTOR 46
1 BACCTLT : ACCNTG DETAIL TRACE, LONG 03/01/21 06:20:51 PAGE 92
LOCATION: DEGX ACCOUNTING DETAIL TRACE - LONG GROUP: N/A MEMBER: N/A
SUBSYSTEM: DEGX 10.1 ACTUAL FROM: 02/28/21 21:35:07.49
---- PACKAGE DETAILS ----------------------------------------------------------------------------------------------------------
CLASS 8 WAIT EVENTS ELAPSED TIME AVG TIME/EVENT
-------------------------------------- ---------------------------------- ---------------------- -------------- --------------
PROGRAM NAME *SUMMARY* AVG ELAP TIME CL7 00:00.005634 LOCK/LATCH 10 00:00.006682 0.000668
COLLECTION ID NULLID AVG CPU TIME 00:00.000000 SYNC I/O 19537 00:24.892813 0.001274
LOCATION DEGX AVG AGENT 00:00.001611 OTHER READ 6 00:00.002748 0.000458
TYPE PACKAGE ROLLUP AVG PAR TASKS 00:00.000000 OTHER WRITE 1 00:00.000925 0.000925
SEQUENCE NUMBER 1 SERVICE TASK 72 00:00.436100 0.006057
TOT ELAP TIME CL7 01:39.215493 ARCHIVE LOG 0 00:00.000000 N/P
TOT CPU TIME 00:00.000000 ARCHIVE READ 0 00:00.000000 N/P
TOT AGENT 00:28.361140 DRAIN LOCK 0 00:00.000000 N/P
TOT PAR TASKS 00:00.000000 CLAIM RLSE 0 00:00.000000 N/P
PAGE LATCH 0 00:00.000000 N/P
IIP CPU TIME 00:00.002300 NOTIFY MSGS 0 00:00.000000 N/A
CONSISTENCY TOKEN 5359534C564C3031 SUSPENSION - CL8 0.001439
SUCC AUTH CHECK YES AGENT 0.001439 TOTAL CL 8 19626 0.001439 0.000000
SQL STATEMENTS 549626 PAR TASKS 0.000000
ALLOCATIONS(EXECS) 17610 (DB2 V9+) NOT ACCOUNTED 00:00.004195
OCCURENCES 0 AVG. DB2 ENTRY/EXIT 0
NESTED CALLER TYPE Not Nested DB2 ENTRY/EXIT 60
ACTIVITY NAME CPU SERVICE UNITS 0.00
SCHEMA NAME AGENT N/P
ST-PROCS CALLED 0 CPU PARALLEL N/P
UDFS CALLED 0
LOCKING ACTIVITY TOTAL DML ACTIVITY TOTAL BUFFER POOL ACTIVITY TOTAL
------------------------------------ ------------------------------------ ------------------------------------
TIMEOUT 0 SELECT 0 BPOOL HIT RATIO (%) -59
DEADLOCK 0 INSERT 0 GETPAGE REQUESTS 46
ESCAL (SHR) 0 UPDATE 0 BUFFER UPDATES 0
ESCAL (EXCL) 0 DELETE 0 IMMED WRITE I/OS (SYNC) 0
MAX LOCKS HELD 2 CALL 0 SYNC READ I/OS 7
SUSPENSION (TOTAL) 0 OPEN 1 SEQ PREFETCH REQUESTS 1
SUSPENSION (LOCK ONLY) 0 FETCH 999 LIST PREFETCH REQUESTS 1
SUSPENSION (LATCH ONLY) 0 CLOSE 1 DYNAMIC PREFETCH REQUESTS 1
SUSPENSION (OTHER ONLY) 0 PREPARE 0 PAGES READ ASYNCHRONOUSLY 66
LOCK ESCALATIONS 0 DESCRIBE 0
LOCK REQUEST 7 LOCKTABLE 0
UNLOCK REQUEST 6
QUERY REQUEST 0
CHANGE REQUEST 0
OTHER REQUEST 0
CLAIM REQUEST 6
---- ACCELERATOR MODELING ACTIVITY
-------------------------------------------------------------------------------------------------------------------------------
ELIGIBLE FOR EXECUTION ON AN ACCELERATOR
ACCUMULATED ELAPSED TIME SPENT PROCESSING SQL IN DB2 00:00:00.000000
ACCUMULATED CPU TIME SPENT PROCESSING SQL IN DB2 00:00:00.000000
ACCUMULATED CPU TIME ON AN IBM SPECIALTY ENGINE
PROCESSING SQL IN DB2 00:00:00.000000
1 BACCTLT : ACCNTG DETAIL TRACE, LONG 03/01/21 06:20:51 PAGE 93
LOCATION: DEGX ACCOUNTING DETAIL TRACE - LONG GROUP: N/A MEMBER: N/A
SUBSYSTEM: DEGX 10.1 ACTUAL FROM: 02/28/21 21:35:07.49
---- ACCELERATOR ACTIVITY -----------------------------------------------------------------------------------------------------
NO ACCELERATOR DATA FOUND
LOCATION: DEGX ACCOUNTING DETAIL TRACE - LONG GROUP: N/A MEMBER: N/A
SUBSYSTEM: DEGX 10.1 ACTUAL FROM: 02/28/21 21:35:07.49
THREAD IDENTIFICATION ----------------------------------------------------------------------------------------------------------
THRD TSTAMP : 03/01/21 06:20:14.79 PRIMAUTH: MAINT WLM SCLS: DDF LUWID : AC183082.G576.D95601FB343C
BEGIN TIME : 02/28/21 21:35:00.48 ORIGAUTH: MAINT LUW SEQ : 0000
END TIME : 03/01/21 06:20:14.79 CORRNAME: db2jcc_appli ENDUSER : maint
REQUESTER : FFFF:172.24.48.1 CONNECT : SERVER CONNTYPE: DRDA TRANSACT: db2jcc_application
REQ PROD ID : JCC04280 PLANNAME: DISTSERV PKG CNT : 1761 WSNAME : 172.24.48.130
REQ PROD VER: 04 FRST PKG: *ROLLUP*
REQ ACCT STR:
ACCT TOKEN : ACCOUNTING TOKEN(HEX): 0000000000000000
TIMES/EVENTS APPL (CLASS 1) DB2 (CLASS 2) IFI (CLASS 5) CLASS 3 WAIT ELAPSED TIME EVENTS HIGHLIGHTS
------------ -------------- -------------- -------------- ------------------------------------ ---------------------------------
ELAPSED TIME 0:05:42.352173 0:03:35.129837 0:00:00.000000 LOCK 0:00:00.007317 11 #OCCURS : 17610
NONNESTED 0:05:42.352173 0:03:35.129837 N/A LATCH 0:00:00.000016 40 #ALLIED : 0
STORPROC 0:00:00.000000 0:00:00.000000 N/A SYNC I/O 0:00:24.892813 19537 #DBAT-DIST : 17610
UDF 0:00:00.000000 0:00:00.000000 N/A DATABSE I/O 0:00:01.211699 2197 #NO PROGRAM DATA : 0
TRIGGER 0:00:00.000000 0:00:00.000000 N/A LOG/WRT I/O 0:00:23.681114 17340 DDF ACCESSES : 1761
OTHER READ 0:00:00.002748 6 COMMIT : 17621
CPU TIME 0:00:35.429174 0:00:30.687194 0:00:00.000000 OTHER WRITE 0:00:00.000925 1 ROLLBACK : 0
AGENT 0:00:35.429174 0:00:30.687194 N/A SERVICE TASK 0:00:00.436100 72 INCR BIND : 0
NONNESTED 0:00:35.429174 0:00:30.687194 0:00:00.000000 UPDT COMMIT 0:00:00.000000 0 UPDATE/COMMIT : 3
STOR PROC 0:00:00.000000 0:00:00.000000 N/A OPEN/CLOSE 0:00:00.000000 0 PROGRAMS : 1
UDF 0:00:00.000000 0:00:00.000000 N/A SYSLNG REC 0:00:00.220838 70 #SVPT REQ : 0
TRIGGER 0:00:00.000000 0:00:00.000000 N/A EXT/DEL/DEF 0:00:00.215261 2 #SVPT REL : 0
PARAL TSKS 0:00:00.000000 0:00:00.000000 N/A OTH SRVCE 0:00:00.000000 0 #SVPT RBK : 0
IIP CPU 0:00:49.734974 0:00:43.947723 N/A ARC.LOG QUIS 0:00:00.000000 0 MAX SQL : 0
IIP CP CPU 0:00:00.021727 ARC.LOG READ 0:00:00.000000 0 SQL CALL WT STPRC: 0
IIP CP TCP/IP LOB 0:00:00.000000 0 SYNCH I/O AVG : 0.001274
TRIG CPU 0:00:00.000000 0:00:00.000000 DRAIN LOCK 0:00:00.000000 0 #CP/X PARALLEL : 1761
STORED PR 0:00:00.000000 0:00:00.000000 CLAIM RLSE 0:00:00.000000 0 #IO PARALLELISM : 0
UDF 0:00:00.000000 0:00:00.000000 PAGE LATCH 0:00:00.000000 0 PARALLEL : CPU
SUSPEND TIME 0:00:00.000000 0:00:25.339919 N/A NOTIFY MSGS 0:00:00.000000 0 THRD TYPE : DBAT DDF
AGENT N/A 0:00:25.339919 N/A GLOBAL CONT 0:00:00.000000 0 TERM COND: ACCUM DATA:OCCUR LIMIT
UDF SCHED 0:00:00.000000 CMT PH1 WRT 0:00:00.000000 0 NORMAL TERMINAT : 0
PAR. TAKS N/A 0:00:00.000000 N/A ASYNC IXL RQ 0.000000 N/A ABNORMAL TERMINAT: 0
STORPROC 0:00:00.000000 TOTAL CL 3 0:00:25.339919 19647
NOT ACCOUNT N/A 115.155001 N/A
DB2 ENT/EXIT N/A 1054402.000000 N/A
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 TOTAL SQL DCL TOTAL SQL DDL: CREATE DROP ALTER LOCKING TOTAL DATA SHARING TOTAL
----------------- --------------------- ---------- ------ ------ ------ ----------------------- ---------------------
SELECT 0 LOCK TABLE 0 TABLE 0 0 0 TIMEOUTS 0 LOCK REQ N/P
INSERT 51856 GRANT 0 CRT TABLE 0 DEADLOCKS 0 UNLOCK REQ N/P
UPDATE 5238 REVOKE 0 DCL TABLE 0 ESCAL (SHR) 0 CHANGE REQ N/P
DELETE 1 SET SQLID 0 AUX TABLE 0 ESCAL (EXCL) 0 LOCK -XES N/P
DESCRIBE 102867 SET HOST VAR 0 INDEX 0 0 0 MAX LOCKS HELD 12428 UNLOCK -XES N/P
DESC TBL 0 SET DEGREE 0 TABLESPACE 0 0 0 LOCK REQ 266429 CHANGE -XES N/P
PREPARE 224465 SET RULES 0 DATABASE 0 0 0 UNLOCK REQ 21116 SUSP -IRLM N/P
OPEN 165199 SET CUR PATH 0 STOGROUP 0 0 0 FALSE CONT N/P
FETCH 0 SET CUR PREC 0 SYNONYM 0 0 N/A
1 BACCTLT : ACCNTG DETAIL TRACE, LONG 03/01/21 06:20:51 PAGE 87
LOCATION: DEGX ACCOUNTING DETAIL TRACE - LONG GROUP: N/A MEMBER: N/A
SUBSYSTEM: DEGX 10.1 ACTUAL FROM: 02/28/21 21:35:07.49
CLOSE 0 CONNECT 1 0 VIEW 0 0 0 QUERY REQ 0 SUSP -XES N/P
CONNECT 2 0 ALIAS 0 0 N/A CHANGE REQ 7987 SUSP -FALSE N/P
SET CONNECT 0 PROCEDURE 0 0 0 OTHER REQ 0 INCOMP LOCK N/P
RELEASE 0 FUNCTION 0 0 0 LOCK SUSP 0 NOTIFY SENT N/P
CALL 0 TRIGGER 0 0 LATCH SUSP 11 L-LOCK RATE% 0
ASSOC LOC 0 DIST TYPE 0 0 OTHER SUSP 0
ALLOC CRSR 0 PACKAGE N/A 0 N/A TOTAL SUSP 11
HOLD LOCTR 0 SEQUENCE 0 0 0
FREE LOCTR 0 TRUSTED CT 0 0 0
DML-ALL 549626 DCL-ALL 0 PERMIT/MSK 0 0 0
ROLE 0 0
JAR 0
TOTAL 0 0 0
RENAME TBL 0
COMMENT ON 0
LABEL ON 0
TRUNCATE 0
MERGE 0
RENAME INDEX 0
PREPARE RESTRICTED 0
MERGE STATEMENT 0
TRUNCATE TABLE 0
DYNAMIC SQL STATEMENT (TOTAL) LOGGING TRIGGERS USER DEFINED FUNCTIONS
----------------------------- -------------------------------- ----------------------- ------------------------
REOPTIMIZATION 0 LOG RECORDS WRITTEN 1682359 STMT TRIGGERS 0 EXECUTED 0
NOT FOUND IN CACHE 2749 TOT BYTES WRITTEN 17042G ROW TRIGGER 0 ABENDED 0
FOUND IN CACHE 221716 LOG RECORD SIZE (AVG) 10129834 SQL ERR OCCUR 0 TIMED OUT 0
IMPLICIT PREPARES 0 REJECTED 0
PREPARES AVOIDED 0 MISCELLANEOUS
CACHE LIMIT EXCEEDED 0 --------------------------------
PREP STMT PURGED 0 MAX STG USED FOR LOBS 0
ROWS FETCHED 164622 MAX STG USED FOR XMLS 0
ROWS INSERTED 626742
ROWS UPDATED 5238
ROWS DELETED 0
DB2 PARSE STATEMENTS 0
DB2 REPLACE STMT 0
DB2 MATCHING REUS 0
DB2 CREATE DUPLICATE 0
NORMAL TERMINATION TOTALS ABNORMAL TERMINATION TOTALS AVERAGE SERVICE UNITS CLASS 1 CLASS 2
----------------------------------- --------------------------- -------------------------------------------------
NEW USER 0 APPLICATION ABEND 0 CPU 1346476.91 1166259.16
DEALLOCATION 0 END OF MEMORY 0 AGENT 1346476.91 1166259.16
APPL PROGRAM END 0 RESOLVE INDOUBT 0 NONNESTED 1346476.91 1166259.16
RESIGNON 0 STOP FORCE 0 STORED PRC 0.00 0.00
DBAT INACTIVE 0 UDF 0.00 0.00
RRS COMMIT 0 TRIGGER 0.00 0.00
DDF TYPE 2 INACTIVE 0 PARAL TASKS 0.00 0.00
END USER THRESH DDF/RRSAF 0 IIP CPU 1890165.27 1670222.26
BLK STOR THRESH DDF/RRSAF 0
STALENESS THRESH DDF/RRSAF 0
1 BACCTLT : ACCNTG DETAIL TRACE, LONG 03/01/21 06:20:51 PAGE 88
LOCATION: DEGX ACCOUNTING DETAIL TRACE - LONG GROUP: N/A MEMBER: N/A
SUBSYSTEM: DEGX 10.1 ACTUAL FROM: 02/28/21 21:35:07.49
ROWID TOTALS
-----------------------------------------------
DIRECT ACCESS 0
INDEX USED 0
TS SCAN USED 0
RID LIST TOTAL PARALLELISM TOTAL STORED PROC TOTAL DRAIN/CLAIM TOTAL DATA CAPTURE TOTAL
--------------------- --------------------------- --------------------- ----------------------- ------------------------
SUCCESSFUL 0 MAX MEMBERS USED 0 CALL STMT 0 DRAIN REQ 0 IFI CALL N/P
FAIL-STORAGE 0 MAXIMUM DEGREE 0 PROC ABEND 0 DRAIN FAIL 0 RECS CAPTURED N/P
FAIL-LIMIT 0 GROUPS EXECUTED 0 CALL TIMEOUT 0 CLAIM REQ 346425 LOG REC READ N/P
RID OFW WRKF 0 PLANNED DEGREE 0 CALL REJECT 0 CLAIM FAIL 0 ROWS RETURNED N/P
RID OFW EXTI 0 REDUCED DEGREE 0 RECS RETURNED N/P
HYB JOIN-STG 0 DB2-COORD = NO 0 DATA DESC RETD N/P
HYB JOIN-INT 0 DB2 ISOLATN LVL 0 TABLES RETURNED N/P
MIAC SKIPPED 0 DB2-DCL TEMP TBL 0 DESCRIBES N/P
FALLBACK-CURSOR 0
FALLBACK-NO ESA 0
FALLBACK-NO BUFF 0
FALLBACK-NO ENCL N/P
MEMBER SKIPPED (%) 0
PARALLEL DISABLD NONE
REFRM PARAL CNFG 0
REFRM PARAL NOBUF 0
---- RESOURCE LIMIT FACILITY --------------------------------------------------------------------------------
TYPE: NONE TABLE ID: SERV UNITS: N/A CPU SECS: N/A MAX CPU SECS: N/A
GLOBAL CONTENTION ELAPSED TIME EVENTS AVG ELAPSED/EVENT
-----------------------------------------------------------------------------
L-LOCKS 0:00:00.000000 0 N/P
PARENTS 0:00:00.000000 0 N/P
CHILD 0:00:00.000000 0 N/P
OTHER 0:00:00.000000 0 N/P
P-LOCKS 0:00:00.000000 0 N/P
PAGESET PARTITION 0:00:00.000000 0 N/P
PAGE 0:00:00.000000 0 N/P
OTHER 0:00:00.000000 0 N/P
1 BACCTLT : ACCNTG DETAIL TRACE, LONG 03/01/21 06:20:51 PAGE 89
LOCATION: DEGX ACCOUNTING DETAIL TRACE - LONG GROUP: N/A MEMBER: N/A
SUBSYSTEM: DEGX 10.1 ACTUAL FROM: 02/28/21 21:35:07.49
---- BUFFER POOL ACTIVITY ------------------- --- GROUP BUFFER POOL ACTIVITY ------------------------------------------------
BP0 GBP0 (IF APPLICABLE)
------------------------------------ ----------------------------------------------------------------------------
BPOOL HIT RATIO (%) 100 GBP-DEPEND GETPAGES READ(NF) DATA RETURNED
GETPAGE REQUESTS 211659 READ(XI) DATA RETURNED READ(NF) NO DATA RETURNED
GETPAGES - FAILED 0 READ(XI) NO DATA RETURNED READ(NF) R/W INTEREST
BUFFER UPDATES 0 READ(XI) R/W INTEREST READ(NF) NO R/W INTEREST
SEQUENTIAL PREFETCH 0 CLEAN PAGES WRITTEN CHANGED PAGES WRITTEN
LIST PREFETCH REQUEST 0 UNREGISTER PAGE WRITE REGISTER SNGL RQTS
SYNCHRONOUS READ I/O 0 WRITE REGISTER MULT RQTS ASYNCH GBP REQUESTS
SYNCHRONOUS WRITE I/O 0 EXPLICIT X-INVALID
DYNAMIC PREFETCH 5496 ASYNCH SEC-GBP REQ PG P-LOCK UNLOCK REQ
PAGES READ ASYNCHRONOUSLY 0 PG P-LOCK LOCK REQ PG P-LOCK LOCK SUSP
SPACE MAP PAGES SPACE MAP PAGES
DATA PAGES DATA PAGES
INDEX LEAF PAGES INDEX LEAF PAGES
BP4 GBP4 (IF APPLICABLE)
------------------------------------ ----------------------------------------------------------------------------
BPOOL HIT RATIO (%) 98 GBP-DEPEND GETPAGES READ(NF) DATA RETURNED
GETPAGE REQUESTS 144505 READ(XI) DATA RETURNED READ(NF) NO DATA RETURNED
GETPAGES - FAILED 0 READ(XI) NO DATA RETURNED READ(NF) R/W INTEREST
BUFFER UPDATES 671496 READ(XI) R/W INTEREST READ(NF) NO R/W INTEREST
SEQUENTIAL PREFETCH 0 CLEAN PAGES WRITTEN CHANGED PAGES WRITTEN
LIST PREFETCH REQUEST 0 UNREGISTER PAGE WRITE REGISTER SNGL RQTS
SYNCHRONOUS READ I/O 2121 WRITE REGISTER MULT RQTS ASYNCH GBP REQUESTS
SYNCHRONOUS WRITE I/O 0 EXPLICIT X-INVALID
DYNAMIC PREFETCH 46 ASYNCH SEC-GBP REQ PG P-LOCK UNLOCK REQ
PAGES READ ASYNCHRONOUSLY 81 PG P-LOCK LOCK REQ PG P-LOCK LOCK SUSP
SPACE MAP PAGES SPACE MAP PAGES
DATA PAGES DATA PAGES
INDEX LEAF PAGES INDEX LEAF PAGES
BP8K0 GBP8K0 (IF APPLICABLE)
------------------------------------ ----------------------------------------------------------------------------
BPOOL HIT RATIO (%) 100 GBP-DEPEND GETPAGES READ(NF) DATA RETURNED
GETPAGE REQUESTS 5497 READ(XI) DATA RETURNED READ(NF) NO DATA RETURNED
GETPAGES - FAILED 0 READ(XI) NO DATA RETURNED READ(NF) R/W INTEREST
BUFFER UPDATES 0 READ(XI) R/W INTEREST READ(NF) NO R/W INTEREST
SEQUENTIAL PREFETCH 0 CLEAN PAGES WRITTEN CHANGED PAGES WRITTEN
LIST PREFETCH REQUEST 0 UNREGISTER PAGE WRITE REGISTER SNGL RQTS
SYNCHRONOUS READ I/O 0 WRITE REGISTER MULT RQTS ASYNCH GBP REQUESTS
SYNCHRONOUS WRITE I/O 0 EXPLICIT X-INVALID
DYNAMIC PREFETCH 2059 ASYNCH SEC-GBP REQ PG P-LOCK UNLOCK REQ
PAGES READ ASYNCHRONOUSLY 0 PG P-LOCK LOCK REQ PG P-LOCK LOCK SUSP
SPACE MAP PAGES SPACE MAP PAGES
DATA PAGES DATA PAGES
INDEX LEAF PAGES INDEX LEAF PAGES
1 BACCTLT : ACCNTG DETAIL TRACE, LONG 03/01/21 06:20:51 PAGE 90
LOCATION: DEGX ACCOUNTING DETAIL TRACE - LONG GROUP: N/A MEMBER: N/A
SUBSYSTEM: DEGX 10.1 ACTUAL FROM: 02/28/21 21:35:07.49
BP16K0 GBP16K0 (IF APPLICABLE)
------------------------------------ ----------------------------------------------------------------------------
BPOOL HIT RATIO (%) 100 GBP-DEPEND GETPAGES READ(NF) DATA RETURNED
GETPAGE REQUESTS 12 READ(XI) DATA RETURNED READ(NF) NO DATA RETURNED
GETPAGES - FAILED 0 READ(XI) NO DATA RETURNED READ(NF) R/W INTEREST
BUFFER UPDATES 6 READ(XI) R/W INTEREST READ(NF) NO R/W INTEREST
SEQUENTIAL PREFETCH 0 CLEAN PAGES WRITTEN CHANGED PAGES WRITTEN
LIST PREFETCH REQUEST 0 UNREGISTER PAGE WRITE REGISTER SNGL RQTS
SYNCHRONOUS READ I/O 0 WRITE REGISTER MULT RQTS ASYNCH GBP REQUESTS
SYNCHRONOUS WRITE I/O 0 EXPLICIT X-INVALID
DYNAMIC PREFETCH 0 ASYNCH SEC-GBP REQ PG P-LOCK UNLOCK REQ
PAGES READ ASYNCHRONOUSLY 0 PG P-LOCK LOCK REQ PG P-LOCK LOCK SUSP
SPACE MAP PAGES SPACE MAP PAGES
DATA PAGES DATA PAGES
INDEX LEAF PAGES INDEX LEAF PAGES
BP32K GBP32K (IF APPLICABLE)
------------------------------------ ----------------------------------------------------------------------------
BPOOL HIT RATIO (%) 100 GBP-DEPEND GETPAGES READ(NF) DATA RETURNED
GETPAGE REQUESTS 1354794 READ(XI) DATA RETURNED READ(NF) NO DATA RETURNED
GETPAGES - FAILED 0 READ(XI) NO DATA RETURNED READ(NF) R/W INTEREST
BUFFER UPDATES 915246 READ(XI) R/W INTEREST READ(NF) NO R/W INTEREST
SEQUENTIAL PREFETCH 0 CLEAN PAGES WRITTEN CHANGED PAGES WRITTEN
LIST PREFETCH REQUEST 0 UNREGISTER PAGE WRITE REGISTER SNGL RQTS
SYNCHRONOUS READ I/O 76 WRITE REGISTER MULT RQTS ASYNCH GBP REQUESTS
SYNCHRONOUS WRITE I/O 0 EXPLICIT X-INVALID
DYNAMIC PREFETCH 8 ASYNCH SEC-GBP REQ PG P-LOCK UNLOCK REQ
PAGES READ ASYNCHRONOUSLY 0 PG P-LOCK LOCK REQ PG P-LOCK LOCK SUSP
SPACE MAP PAGES SPACE MAP PAGES
DATA PAGES DATA PAGES
INDEX LEAF PAGES INDEX LEAF PAGES
BP TOT GBP TOT (IF APPLICABLE)
------------------------------------ ----------------------------------------------------------------------------
BPOOL HIT RATIO (%) 100 GBP-DEPEND GETPAGES N/P READ(NF) DATA RETURNED N/P
GETPAGE REQUESTS 1716467 READ(XI) DATA RETURNED N/P READ(NF) NO DATA RETURNED N/P
GETPAGES - FAILED 0 READ(XI) NO DATA RETURNED N/P READ(NF) R/W INTEREST N/P
BUFFER UPDATES 1586748 READ(XI) R/W INTEREST N/P READ(NF) NO R/W INTEREST N/P
SEQUENTIAL PREFETCH 0 CLEAN PAGES WRITTEN N/P CHANGED PAGES WRITTEN N/P
LIST PREFETCH REQUEST 0 UNREGISTER PAGE N/P WRITE REGISTER SNGL RQTS N/P
SYNCHRONOUS READ I/O 2197 WRITE REGISTER MULT RQTS N/P ASYNCH GBP REQUESTS N/P
SYNCHRONOUS WRITE I/O 0 EXPLICIT X-INVALID N/P
DYNAMIC PREFETCH 7609 ASYNCH SEC-GBP REQ N/P PG P-LOCK UNLOCK REQ N/P
PAGES READ ASYNCHRONOUSLY 81 PG P-LOCK LOCK REQ 0 PG P-LOCK LOCK SUSP 0
SPACE MAP PAGES N/P SPACE MAP PAGES N/P
DATA PAGES N/P DATA PAGES N/P
INDEX LEAF PAGES N/P INDEX LEAF PAGES N/P
1 BACCTLT : ACCNTG DETAIL TRACE, LONG 03/01/21 06:20:51 PAGE 91
LOCATION: DEGX ACCOUNTING DETAIL TRACE - LONG GROUP: N/A MEMBER: N/A
SUBSYSTEM: DEGX 10.1 ACTUAL FROM: 02/28/21 21:35:07.49
---- INITIAL OTHER REQUESTER CORRELATION ---------------------------------------------------------------------------------------
PRODUCT ID : JCC
PRODUCT VERSION: 04 28 0
STRING : 172.24.48.130 db2jcc_application maint .JCC04280172.24.48.130
---- DISTRIBUTED DATA FACILITY ACTIVITY ---------------------------------------------------------------------------------------
*******************************************************************************************************************
* REMOTE LOCATION: ::FFFF:172.24.48 ( SERVER ) PROTOCOL: APPL DIRECTED PRODUCT ID: JCC04280 *
* *
* TIME WAITING FOR A DB ACCESS AGENT (POSSIBLY MAXDBATS) 3.022833 *
* ELAPSED TIME PROCESSING REQUEST AT REMOTE SITE 0.045370 *
*******************************************************************************************************************
DESCRIPTION TOTAL DESCRIPTION TOTAL
-------------------------------------- ---------- ------------------------------------- ----------
TRANSACTIONS SENT N/A TRANSACTIONS RECEIVED N/A
SINGLE-PHASE COMMITS SENT 0 SINGLE-PHASE COMMITS RECEIVED 17655
ROLLBACKS SENT 0 ROLLBACKS RECEIVED 0
SQL STATEMENTS SENT 0 SQL STATEMENTS RECEIVED 509637
ROWS SENT 164622 ROWS RECEIVED 0
MESSAGES SENT 527419 MESSAGES RECEIVED 527419
BYTES SENT 169474K BYTES RECEIVED 295859K
BLOCKS SENT 330398 BLOCKS RECEIVED 0
CONVERSATIONS SENT 0
CONVERSATIONS QUEUED 0 MAXIMUM CONVERSATIONS ACTIVE
CONVERSATIONS ALLOCATED CONVERSATIONS TERMINATED 0
SWITCH TO LIMITED BLOCK FETCH MESSAGES IN BUFFER
SQL STATEMENTS BOUND AT SERVER ROLLBACKS W/REMOTE COORDINATOR
PREPARE REQUESTS SENT PREPARE REQUESTS RECEIVED
LAST AGENT REQUESTS SENT LAST AGENT REQUESTS RECEIVED
TWO-PHASE COMMITS SENT TWO-PHASE COMMITS RECEIVED
BACKOUT REQUESTS SENT BACKOUT REQUESTS RECEIVED
FORGET RESPONSES SENT FORGET RESPONSES RECEIVED
REQUEST COMMIT RESPONSES SENT REQUEST COMMIT RESPONSES RECEIVED
BACKOUT RESPONSES SENT BACKOUT RESPONSES RECEIVED
THREADS INDOUBT W/REMOTE COORDINATOR 0 TWO-PHASE COMMITS PERFORMED
CONVERSATIONS INIT BY REQUESTOR 46
1 BACCTLT : ACCNTG DETAIL TRACE, LONG 03/01/21 06:20:51 PAGE 92
LOCATION: DEGX ACCOUNTING DETAIL TRACE - LONG GROUP: N/A MEMBER: N/A
SUBSYSTEM: DEGX 10.1 ACTUAL FROM: 02/28/21 21:35:07.49
---- PACKAGE DETAILS ----------------------------------------------------------------------------------------------------------
CLASS 8 WAIT EVENTS ELAPSED TIME AVG TIME/EVENT
-------------------------------------- ---------------------------------- ---------------------- -------------- --------------
PROGRAM NAME *SUMMARY* AVG ELAP TIME CL7 00:00.005634 LOCK/LATCH 10 00:00.006682 0.000668
COLLECTION ID NULLID AVG CPU TIME 00:00.000000 SYNC I/O 19537 00:24.892813 0.001274
LOCATION DEGX AVG AGENT 00:00.001611 OTHER READ 6 00:00.002748 0.000458
TYPE PACKAGE ROLLUP AVG PAR TASKS 00:00.000000 OTHER WRITE 1 00:00.000925 0.000925
SEQUENCE NUMBER 1 SERVICE TASK 72 00:00.436100 0.006057
TOT ELAP TIME CL7 01:39.215493 ARCHIVE LOG 0 00:00.000000 N/P
TOT CPU TIME 00:00.000000 ARCHIVE READ 0 00:00.000000 N/P
TOT AGENT 00:28.361140 DRAIN LOCK 0 00:00.000000 N/P
TOT PAR TASKS 00:00.000000 CLAIM RLSE 0 00:00.000000 N/P
PAGE LATCH 0 00:00.000000 N/P
IIP CPU TIME 00:00.002300 NOTIFY MSGS 0 00:00.000000 N/A
CONSISTENCY TOKEN 5359534C564C3031 SUSPENSION - CL8 0.001439
SUCC AUTH CHECK YES AGENT 0.001439 TOTAL CL 8 19626 0.001439 0.000000
SQL STATEMENTS 549626 PAR TASKS 0.000000
ALLOCATIONS(EXECS) 17610 (DB2 V9+) NOT ACCOUNTED 00:00.004195
OCCURENCES 0 AVG. DB2 ENTRY/EXIT 0
NESTED CALLER TYPE Not Nested DB2 ENTRY/EXIT 60
ACTIVITY NAME CPU SERVICE UNITS 0.00
SCHEMA NAME AGENT N/P
ST-PROCS CALLED 0 CPU PARALLEL N/P
UDFS CALLED 0
LOCKING ACTIVITY TOTAL DML ACTIVITY TOTAL BUFFER POOL ACTIVITY TOTAL
------------------------------------ ------------------------------------ ------------------------------------
TIMEOUT 0 SELECT 0 BPOOL HIT RATIO (%) -59
DEADLOCK 0 INSERT 0 GETPAGE REQUESTS 46
ESCAL (SHR) 0 UPDATE 0 BUFFER UPDATES 0
ESCAL (EXCL) 0 DELETE 0 IMMED WRITE I/OS (SYNC) 0
MAX LOCKS HELD 2 CALL 0 SYNC READ I/OS 7
SUSPENSION (TOTAL) 0 OPEN 1 SEQ PREFETCH REQUESTS 1
SUSPENSION (LOCK ONLY) 0 FETCH 999 LIST PREFETCH REQUESTS 1
SUSPENSION (LATCH ONLY) 0 CLOSE 1 DYNAMIC PREFETCH REQUESTS 1
SUSPENSION (OTHER ONLY) 0 PREPARE 0 PAGES READ ASYNCHRONOUSLY 66
LOCK ESCALATIONS 0 DESCRIBE 0
LOCK REQUEST 7 LOCKTABLE 0
UNLOCK REQUEST 6
QUERY REQUEST 0
CHANGE REQUEST 0
OTHER REQUEST 0
CLAIM REQUEST 6
---- ACCELERATOR MODELING ACTIVITY
-------------------------------------------------------------------------------------------------------------------------------
ELIGIBLE FOR EXECUTION ON AN ACCELERATOR
ACCUMULATED ELAPSED TIME SPENT PROCESSING SQL IN DB2 00:00:00.000000
ACCUMULATED CPU TIME SPENT PROCESSING SQL IN DB2 00:00:00.000000
ACCUMULATED CPU TIME ON AN IBM SPECIALTY ENGINE
PROCESSING SQL IN DB2 00:00:00.000000
1 BACCTLT : ACCNTG DETAIL TRACE, LONG 03/01/21 06:20:51 PAGE 93
LOCATION: DEGX ACCOUNTING DETAIL TRACE - LONG GROUP: N/A MEMBER: N/A
SUBSYSTEM: DEGX 10.1 ACTUAL FROM: 02/28/21 21:35:07.49
---- ACCELERATOR ACTIVITY -----------------------------------------------------------------------------------------------------
NO ACCELERATOR DATA FOUND
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*