Accounting Trace - Long
This topic shows an example of a long version of the Accounting trace.
The following example shows an extract from a long version of the Accounting trace produced by
the following command:
...
ACCOUNTING
TRACE
LAYOUT (LONG)
...
Accounting (Long Trace)
The following example shows an extract from a long version of the Accounting trace. LOCATION: OMPDA5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-1
GROUP: N/P ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: DA5 ACTUAL FROM: 08/24/16 08:18:18.92
DB2 VERSION: V10
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 08:18:18.92 PLANNAME: ADB WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 08:17:30.65 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : 08/24/16 08:18:18.92 PROD VER: N/P LUW LUN: IPUAPZA5 CICS INS: N/A
REQUESTER : OMPDA5 CORRNAME: MIS LUW INS: D13DD32594B7
MAINPACK : ADB2GET CORRNMBR: 'BLANK' LUW SEQ: 4 ENDUSER : MIS
PRIMAUTH : MIS CONNTYPE: TSO TRANSACT: MIS
ORIGAUTH : MIS CONNECT : TSO WSNAME : TSO
MVS ACCOUNTING DATA : DE03704
ACCOUNTING TOKEN(CHAR): N/A
ACCOUNTING TOKEN(HEX) : N/A
ELAPSED TIME DISTRIBUTION CLASS 2 TIME DISTRIBUTION
---------------------------------------------------------------- ----------------------------------------------------------------
APPL !==================================================> 100% CPU !===> 7%
DB2 ! SECPU !
SUSP ! NOTACC !
SUSP !==============================================> 93%
LOCATION: OMPDA5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-2
GROUP: N/P ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: DA5 ACTUAL FROM: 08/24/16 08:18:18.92
DB2 VERSION: V10
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 08:18:18.92 PLANNAME: ADB WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 08:17:30.65 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : 08/24/16 08:18:18.92 PROD VER: N/P LUW LUN: IPUAPZA5 CICS INS: N/A
REQUESTER : OMPDA5 CORRNAME: MIS LUW INS: D13DD32594B7
MAINPACK : ADB2GET CORRNMBR: 'BLANK' LUW SEQ: 4 ENDUSER : MIS
PRIMAUTH : MIS CONNTYPE: TSO TRANSACT: MIS
ORIGAUTH : MIS CONNECT : TSO WSNAME : TSO
TIMES/EVENTS APPL(CL.1) DB2 (CL.2) CLASS 3 SUSPENSIONS ELAPSED TIME EVENTS TIME/EVENT HIGHLIGHTS
------------ ---------- ---------- -------------------- ------------ -------- ---------- --------------------------
ELAPSED TIME 48.277700 0.053410 LOCK/LATCH(DB2+IRLM) 0.000000 0 N/C THREAD TYPE : ALLIED
NONNESTED 48.277700 0.053410 IRLM LOCK+LATCH 0.000000 0 N/C TERM.CONDITION: NORMAL
STORED PROC 0.000000 0.000000 DB2 LATCH 0.000000 0 N/C INVOKE REASON : DEALLOC
UDF 0.000000 0.000000 SYNCHRON. I/O 0.011191 4 0.002798 PARALLELISM : NO
TRIGGER 0.000000 0.000000 DATABASE I/O 0.011191 4 0.002798 PCA RUP COUNT : N/A
LOG WRITE I/O 0.000000 0 N/C RUP AUTONOM.PR: N/A
CP CPU TIME 0.005557 0.003498 OTHER READ I/O 0.000000 0 N/C AUTONOMOUS PR : N/A
AGENT 0.005557 0.003498 OTHER WRTE I/O 0.000000 0 N/C QUANTITY : 0
NONNESTED 0.005557 0.003498 SER.TASK SWTCH 0.038488 3 0.012829 COMMITS : 3
STORED PRC 0.000000 0.000000 UPDATE COMMIT 0.000034 1 0.000034 ROLLBACK : 0
UDF 0.000000 0.000000 OPEN/CLOSE 0.000000 0 N/C SVPT REQUESTS : 0
TRIGGER 0.000000 0.000000 SYSLGRNG REC 0.000000 0 N/C SVPT RELEASE : 0
PAR.TASKS 0.000000 0.000000 EXT/DEL/DEF 0.000000 0 N/C SVPT ROLLBACK : 0
OTHER SERVICE 0.038454 2 0.019227 INCREM.BINDS : 0
SE CPU TIME 0.000000 0.000000 ARC.LOG(QUIES) 0.000000 0 N/C UPDATE/COMMIT : 0.00
NONNESTED 0.000000 0.000000 LOG READ 0.000000 0 N/C SYNCH I/O AVG.: 0.002798
STORED PROC 0.000000 0.000000 DRAIN LOCK 0.000000 0 N/C PROGRAMS : 3
UDF 0.000000 0.000000 CLAIM RELEASE 0.000000 0 N/C MAX CASCADE : 0
TRIGGER 0.000000 0.000000 PAGE LATCH 0.000000 0 N/C MAX WFILE BLKS: N/A
NOTIFY MSGS 0.000000 0 N/C
PAR.TASKS 0.000000 0.000000 GLOBAL CONTENTION 0.000000 0 N/C
COMMIT PH1 WRITE I/O 0.000000 0 N/C
SUSPEND TIME 0.000000 0.049679 ASYNCH CF REQUESTS 0.000000 0 N/C
AGENT N/A 0.049679 TCP/IP LOB XML 0.000000 0 N/C
PAR.TASKS N/A 0.000000 ACCELERATOR 0.000000 0 N/C
STORED PROC 0.000000 N/A AUTONOMOUS PROCEDURE N/A N/A N/A
UDF 0.000000 N/A PQ SYNCHRONIZATION N/A N/A N/A
LOB COMPRESSION N/A N/A N/A
NOT ACCOUNT. N/A 0.000233 FAST INSERT PIPE N/A N/A N/A
DB2 ENT/EXIT N/A 36 TOTAL CLASS 3 0.049679 7 0.007097
EN/EX-STPROC N/A 0
EN/EX-UDF N/A 0
DCAPT.DESCR. N/A N/A
LOG EXTRACT. N/A N/A
LOCATION: OMPDA5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-3
GROUP: N/P ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: DA5 ACTUAL FROM: 08/24/16 08:18:18.92
DB2 VERSION: V10
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 08:18:18.92 PLANNAME: ADB WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 08:17:30.65 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : 08/24/16 08:18:18.92 PROD VER: N/P LUW LUN: IPUAPZA5 CICS INS: N/A
REQUESTER : OMPDA5 CORRNAME: MIS LUW INS: D13DD32594B7
MAINPACK : ADB2GET CORRNMBR: 'BLANK' LUW SEQ: 4 ENDUSER : MIS
PRIMAUTH : MIS CONNTYPE: TSO TRANSACT: MIS
ORIGAUTH : MIS CONNECT : TSO WSNAME : TSO
SQL DML TOTAL SQL DCL TOTAL SQL DDL CREATE DROP ALTER DYNAMIC SQL STMT TOTAL
-------- -------- ---------- -------- ---------- ------ ------ ------ -------------------- --------
SELECT 0 LOCK TABLE 0 TABLE 0 0 0 REOPTIMIZATION 0
INSERT 0 GRANT 0 CRT TTABLE 0 N/A N/A NOT FOUND IN CACHE 1
ROWS 0 REVOKE 0 DCL TTABLE 0 N/A N/A FOUND IN CACHE 0
UPDATE 0 SET SQLID 0 AUX TABLE 0 N/A N/A IMPLICIT PREPARES 0
ROWS 0 SET H.VAR. 4 INDEX 0 0 0 PREPARES AVOIDED 0
MERGE 0 SET DEGREE 0 TABLESPACE 0 0 0 CACHE_LIMIT_EXCEEDED 0
DELETE 0 SET RULES 0 DATABASE 0 0 0 PREP_STMT_PURGED 0
ROWS 0 SET PATH 0 STOGROUP 0 0 0 STABILIZED PREPARE N/A
SET PREC. 0 SYNONYM 0 0 N/A CSWL - STMTS PARSED 1
DESCRIBE 1 CONNECT 1 0 VIEW 0 0 0 CSWL - LITS REPLACED 0
DESC.TBL 0 CONNECT 2 1 ALIAS 0 0 N/A CSWL - MATCHES FOUND 0
PREPARE 1 SET CONNEC 0 PACKAGE N/A 0 N/A CSWL - DUPLS CREATED 0
OPEN 1 RELEASE 0 PROCEDURE 0 0 0
FETCH 2 CALL 0 FUNCTION 0 0 0
ROWS 1 ASSOC LOC. 0 TRIGGER 0 0 N/A
CLOSE 1 ALLOC CUR. 0 DIST TYPE 0 0 N/A
HOLD LOC. 0 SEQUENCE 0 0 0
DML-ALL 6 FREE LOC. 0 TRUST. CTX 0 0 0
DCL-ALL 5 ROLE 0 0 N/A
JAR N/A N/A 0
MASK/PERM 0 0 0
VARIABLE N/A N/A N/A
TOTAL 0 0 0
TRUNC TBL 0
RENAME TBL 0
RENAME IX 0
COMMENT ON 0
LABEL ON 0
LOCATION: OMPDA5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-4
GROUP: N/P ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: DA5 ACTUAL FROM: 08/24/16 08:18:18.92
DB2 VERSION: V10
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 08:18:18.92 PLANNAME: ADB WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 08:17:30.65 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : 08/24/16 08:18:18.92 PROD VER: N/P LUW LUN: IPUAPZA5 CICS INS: N/A
REQUESTER : OMPDA5 CORRNAME: MIS LUW INS: D13DD32594B7
MAINPACK : ADB2GET CORRNMBR: 'BLANK' LUW SEQ: 4 ENDUSER : MIS
PRIMAUTH : MIS CONNTYPE: TSO TRANSACT: MIS
ORIGAUTH : MIS CONNECT : TSO WSNAME : TSO
MEASURED/ELIG TIMES APPL (CL1) DB2 (CL2) RID LIST TOTAL DATA CAPTURE TOTAL ROWID TOTAL
------------------- ---------- ---------- ---------------------- -------- ------------ -------- ---------- --------
ELAPSED TIME 48.277700 0.053410 USED 0 IFI CALLS 0 DIR ACCESS 0
ELIGIBLE FOR ACCEL N/A 0.000000 REC.CAPTURED 0 INDEX USED 0
FAIL-NO STORAGE 0 LOG REC.READ 0 TS SCAN 0
CP CPU TIME 0.005557 0.003498 FAIL-LIMIT EXC. 0 ROWS RETURN 0
ELIGIBLE FOR SECP 0.000000 N/A RECORDS RET. 0
ELIGIBLE FOR ACCEL N/A 0.000000 INTERRUPTED-NO STORAGE 0 DATA DES.RET 0
INTERRUPTED-LIMIT EXC. 0 TABLES RET. 0
SE CPU TIME 0.000000 0.000000 DESCRIBES 0
ELIGIBLE FOR ACCEL N/A 0.000000 OVERFLOWED-NO STORAGE 0
OVERFLOWED-LIMIT EXC. 0
SKIPPED-INDEX KNOWN 0
GLOBAL CONTENTION L-LOCKS ELAPSED TIME EVENTS GLOBAL CONTENTION P-LOCKS ELAPSED TIME EVENTS
------------------------------------- ------------ -------- ------------------------------------- ------------ --------
L-LOCKS 0.000000 0 P-LOCKS 0.000000 0
PARENT (DB,TS,TAB,PART) 0.000000 0 PAGESET/PARTITION 0.000000 0
CHILD (PAGE,ROW) 0.000000 0 PAGE 0.000000 0
OTHER 0.000000 0 OTHER 0.000000 0
LOCKING TOTAL DATA SHARING TOTAL QUERY PARALLELISM TOTAL DRAIN/CLAIM TOTAL
------------------- -------- ------------ -------- ------------------------- -------- ------------ --------
TIMEOUTS 0 GLOB CONT(%) N/C MAXIMUM DEGREE-ESTIMATED N/A DRAIN REQST 0
DEADLOCKS 0 FALS CONT(%) N/C MAXIMUM DEGREE-PLANNED N/A DRAIN FAILED 0
ESCAL.(SHAR) 0 P/L-LOCKS(%) N/P MAXIMUM DEGREE-EXECUTED 0 CLAIM REQST 23
ESCAL.(EXCL) 0 P-LOCK REQ N/P MAXIMUM MEMBERS USED N/P CLAIM FAILED 0
MAX PG/ROW LCK HELD 0 P-UNLOCK REQ N/P PARALLEL GROUPS EXECUTED 0
LOCK REQUEST 39 P-CHANGE REQ N/P RAN AS PLANNED 0
UNLOCK REQST 4 LOCK - XES N/P RAN REDUCED-STORAGE 0
QUERY REQST 0 UNLOCK-XES N/P RAN REDUCED-NEGOTIATION N/A
CHANGE REQST 1 CHANGE-XES N/P SEQ-CURSOR 0
OTHER REQST 0 SUSP - IRLM N/P SEQ-NO ESA SORT 0
TOTAL SUSPENSIONS 0 SUSP - XES N/P SEQ-NO BUFFER 0
LOCK SUSPENS 0 CONV - XES N/P SEQ-AUTONOMOUS PROC N/A
IRLM LATCH SUSPENS 0 FALSE CONT N/P SEQ-NEGOTIATION N/A
OTHER SUSPENS 0 INCOMP.LOCK N/P ONE DB2-COORDINATOR = NO 0
NOTIFY SENT N/P ONE DB2-ISOLATION LEVEL 0
ONE DB2-DCL TTABLE 0
MEMB SKIPPED(%) 0
DISABLED BY RLF NO
REFORM PARAL-CONFIG 0
REFORM PARAL-NO BUF 0
LOCATION: OMPDA5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-5
GROUP: N/P ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: DA5 ACTUAL FROM: 08/24/16 08:18:18.92
DB2 VERSION: V10
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 08:18:18.92 PLANNAME: ADB WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 08:17:30.65 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : 08/24/16 08:18:18.92 PROD VER: N/P LUW LUN: IPUAPZA5 CICS INS: N/A
REQUESTER : OMPDA5 CORRNAME: MIS LUW INS: D13DD32594B7
MAINPACK : ADB2GET CORRNMBR: 'BLANK' LUW SEQ: 4 ENDUSER : MIS
PRIMAUTH : MIS CONNTYPE: TSO TRANSACT: MIS
ORIGAUTH : MIS CONNECT : TSO WSNAME : TSO
STORED PROC. TOTAL UDF TOTAL TRIGGERS TOTAL LOGGING TOTAL
------------ -------- --------- -------- ------------ -------- ----------------- --------
CALL STMTS 0 EXECUTED 0 STMT TRIGGER 0 LOG RECS WRITTEN 0
ABENDED 0 ABENDED 0 ROW TRIGGER 0 TOT BYTES WRITTEN 0
TIMED OUT 0 TIMED OUT 0 SQL ERROR 0
REJECTED 0 REJECTED 0
TOTAL SU CLASS 1 CLASS 2 MISCELLANEOUS TOTAL
------------ -------------- -------------- -------------------- --------
CP CPU 359 226 MAX STO LOB VAL (KB) 0
AGENT 359 226 MAX STO XML VAL (KB) 0
NONNESTED 359 226 ARRAY EXPANSIONS N/A
STORED PRC 0 0 SPARSE IX DISABLED N/A
UDF 0 0 SPARSE IX BUILT WF N/A
TRIGGER 0 0
PAR.TASKS 0 0
ELIG SECP 0 N/A
ELIG ACCEL N/A 0
SE CPU 0 0
NONNESTED 0 0
STORED PROC 0 0
UDF 0 0
TRIGGER 0 0
PAR.TASKS 0 0
ELIG ACCEL N/A 0
---- RESOURCE LIMIT FACILITY --------------------------------------------------------------------------------------------------
TYPE: N/P TABLE ID: N/P SERV.UNITS: N/P CPU SECONDS: 0.000000 MAX CPU SEC: N/P
BP0 BPOOL ACTIVITY TOTAL BP8K BPOOL ACTIVITY TOTAL TOTAL BPOOL ACTIVITY TOTAL
--------------------- -------- --------------------- -------- --------------------- --------
BPOOL HIT RATIO (%) 86 BPOOL HIT RATIO (%) 100 BPOOL HIT RATIO (%) 87
GETPAGES 28 GETPAGES 2 GETPAGES 30
BUFFER UPDATES 0 BUFFER UPDATES 0 BUFFER UPDATES 0
SYNCHRONOUS WRITE 0 SYNCHRONOUS WRITE 0 SYNCHRONOUS WRITE 0
SYNCHRONOUS READ 4 SYNCHRONOUS READ 0 SYNCHRONOUS READ 4
SEQ. PREFETCH REQS 0 SEQ. PREFETCH REQS 0 SEQ. PREFETCH REQS 0
LIST PREFETCH REQS 0 LIST PREFETCH REQS 0 LIST PREFETCH REQS 0
DYN. PREFETCH REQS 0 DYN. PREFETCH REQS 1 DYN. PREFETCH REQS 1
PAGES READ ASYNCHR. 0 PAGES READ ASYNCHR. 0 PAGES READ ASYNCHR. 0
LOCATION: OMPDA5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-6
GROUP: N/P ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: DA5 ACTUAL FROM: 08/24/16 08:18:18.92
DB2 VERSION: V10
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 08:18:18.92 PLANNAME: ADB WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 08:17:30.65 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : 08/24/16 08:18:18.92 PROD VER: N/P LUW LUN: IPUAPZA5 CICS INS: N/A
REQUESTER : OMPDA5 CORRNAME: MIS LUW INS: D13DD32594B7
MAINPACK : ADB2GET CORRNMBR: 'BLANK' LUW SEQ: 4 ENDUSER : MIS
PRIMAUTH : MIS CONNTYPE: TSO TRANSACT: MIS
ORIGAUTH : MIS CONNECT : TSO WSNAME : TSO
-------------------------------------------------------------------------------
!PROGRAM NAME CLASS 7 ELAPSED TIME CONSUMERS !
!ADB2GET !> 1% !
!ADB2CON ! !
!ADBMAIN !=================================================> 99% !
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
!PROGRAM NAME CLASS 7 CP CPU TIME CONSUMERS !
!ADB2GET !=====> 10% !
!ADB2CON !> 1% !
!ADBMAIN !============================================> 89% !
-------------------------------------------------------------------------------
ADB2GET VALUE ADB2GET TIMES ADB2GET TIME EVENTS TIME/EVENT
------------------ ------------------ ------------------ ------------ ------------------ ------------ ------ ------------
TYPE PACKAGE ELAPSED TIME - CL7 0.000333 LOCK/LATCH 0.000000 0 N/C
LOCATION OMPDA5 CP CPU TIME 0.000328 IRLM LOCK+LATCH 0.000000 0 N/C
COLLECTION ID ADBL AGENT 0.000328 DB2 LATCH 0.000000 0 N/C
PROGRAM NAME ADB2GET PAR.TASKS 0.000000 SYNCHRONOUS I/O 0.000000 0 N/C
CONSISTENCY TOKEN 196091EA1913F078 SE CPU TIME 0.000000 OTHER READ I/O 0.000000 0 N/C
ACTIVITY TYPE NONNESTED SUSPENSION-CL8 0.000000 OTHER WRITE I/O 0.000000 0 N/C
ACTIVITY NAME 'BLANK' AGENT 0.000000 SERV.TASK SWITCH 0.000000 0 N/C
SCHEMA NAME 'BLANK' PAR.TASKS 0.000000 ARCH.LOG(QUIESCE) 0.000000 0 N/C
SUCC AUTH CHECK NO NOT ACCOUNTED 0.000005 ARCHIVE LOG READ 0.000000 0 N/C
NBR OF ALLOCATIONS 2 DRAIN LOCK 0.000000 0 N/C
SQL STMT - AVERAGE 6.00 CP CPU SU 21 CLAIM RELEASE 0.000000 0 N/C
SQL STMT - TOTAL 6 AGENT 21 PAGE LATCH 0.000000 0 N/C
NBR RLUP THREADS 1 PAR.TASKS 0 NOTIFY MESSAGES 0.000000 0 N/C
SE CPU SU 0 GLOBAL CONTENTION 0.000000 0 N/C
TCP/IP LOB XML 0.000000 0 N/C
DB2 ENTRY/EXIT 14 ACCELERATOR 0.000000 0 N/C
PQ SYNCHRONIZATION N/A N/A N/A
FAST INSERT PIPE N/A N/A N/A
TOTAL CL8 SUSPENS. 0.000000 0 N/C
LOCATION: OMPDA5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-7
GROUP: N/P ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: DA5 ACTUAL FROM: 08/24/16 08:18:18.92
DB2 VERSION: V10
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 08:18:18.92 PLANNAME: ADB WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 08:17:30.65 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : 08/24/16 08:18:18.92 PROD VER: N/P LUW LUN: IPUAPZA5 CICS INS: N/A
REQUESTER : OMPDA5 CORRNAME: MIS LUW INS: D13DD32594B7
MAINPACK : ADB2GET CORRNMBR: 'BLANK' LUW SEQ: 4 ENDUSER : MIS
PRIMAUTH : MIS CONNTYPE: TSO TRANSACT: MIS
ORIGAUTH : MIS CONNECT : TSO WSNAME : TSO
ADB2CON VALUE ADB2CON TIMES ADB2CON TIME EVENTS TIME/EVENT
------------------ ------------------ ------------------ ------------ ------------------ ------------ ------ ------------
TYPE PACKAGE ELAPSED TIME - CL7 0.000041 LOCK/LATCH 0.000000 0 N/C
LOCATION OMPDA5 CP CPU TIME 0.000041 IRLM LOCK+LATCH 0.000000 0 N/C
COLLECTION ID ADBL AGENT 0.000041 DB2 LATCH 0.000000 0 N/C
PROGRAM NAME ADB2CON PAR.TASKS 0.000000 SYNCHRONOUS I/O 0.000000 0 N/C
CONSISTENCY TOKEN 193DB3EF185991D1 SE CPU TIME 0.000000 OTHER READ I/O 0.000000 0 N/C
ACTIVITY TYPE NONNESTED SUSPENSION-CL8 0.000000 OTHER WRITE I/O 0.000000 0 N/C
ACTIVITY NAME 'BLANK' AGENT 0.000000 SERV.TASK SWITCH 0.000000 0 N/C
SCHEMA NAME 'BLANK' PAR.TASKS 0.000000 ARCH.LOG(QUIESCE) 0.000000 0 N/C
SUCC AUTH CHECK NO NOT ACCOUNTED 0.000000 ARCHIVE LOG READ 0.000000 0 N/C
NBR OF ALLOCATIONS 1 DRAIN LOCK 0.000000 0 N/C
SQL STMT - AVERAGE 1.00 CP CPU SU 3 CLAIM RELEASE 0.000000 0 N/C
SQL STMT - TOTAL 1 AGENT 3 PAGE LATCH 0.000000 0 N/C
NBR RLUP THREADS 1 PAR.TASKS 0 NOTIFY MESSAGES 0.000000 0 N/C
SE CPU SU 0 GLOBAL CONTENTION 0.000000 0 N/C
TCP/IP LOB XML 0.000000 0 N/C
DB2 ENTRY/EXIT 2 ACCELERATOR 0.000000 0 N/C
PQ SYNCHRONIZATION N/A N/A N/A
FAST INSERT PIPE N/A N/A N/A
TOTAL CL8 SUSPENS. 0.000000 0 N/C
ADBMAIN VALUE ADBMAIN TIMES ADBMAIN TIME EVENTS TIME/EVENT
------------------ ------------------ ------------------ ------------ ------------------ ------------ ------ ------------
TYPE PACKAGE ELAPSED TIME - CL7 0.052952 LOCK/LATCH 0.000000 0 N/C
LOCATION OMPDA5 CP CPU TIME 0.003046 IRLM LOCK+LATCH 0.000000 0 N/C
COLLECTION ID ADBL AGENT 0.003046 DB2 LATCH 0.000000 0 N/C
PROGRAM NAME ADBMAIN PAR.TASKS 0.000000 SYNCHRONOUS I/O 0.011191 4 0.002798
CONSISTENCY TOKEN 1990BC141CA76A7C SE CPU TIME 0.000000 OTHER READ I/O 0.000000 0 N/C
ACTIVITY TYPE NONNESTED SUSPENSION-CL8 0.049679 OTHER WRITE I/O 0.000000 0 N/C
ACTIVITY NAME 'BLANK' AGENT 0.049679 SERV.TASK SWITCH 0.038488 3 0.012829
SCHEMA NAME 'BLANK' PAR.TASKS 0.000000 ARCH.LOG(QUIESCE) 0.000000 0 N/C
SUCC AUTH CHECK NO NOT ACCOUNTED 0.000228 ARCHIVE LOG READ 0.000000 0 N/C
NBR OF ALLOCATIONS 1 DRAIN LOCK 0.000000 0 N/C
SQL STMT - AVERAGE 6.00 CP CPU SU 197 CLAIM RELEASE 0.000000 0 N/C
SQL STMT - TOTAL 6 AGENT 197 PAGE LATCH 0.000000 0 N/C
NBR RLUP THREADS 1 PAR.TASKS 0 NOTIFY MESSAGES 0.000000 0 N/C
SE CPU SU 0 GLOBAL CONTENTION 0.000000 0 N/C
TCP/IP LOB XML 0.000000 0 N/C
DB2 ENTRY/EXIT 18 ACCELERATOR 0.000000 0 N/C
PQ SYNCHRONIZATION N/A N/A N/A
FAST INSERT PIPE N/A N/A N/A
TOTAL CL8 SUSPENS. 0.049679 7 0.007097
LOCATION: OMPDA5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-8
GROUP: N/P ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: DA5 ACTUAL FROM: 08/24/16 08:18:18.92
DB2 VERSION: V10
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 08:18:18.92 PLANNAME: ADB WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 08:17:30.65 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : 08/24/16 08:18:18.92 PROD VER: N/P LUW LUN: IPUAPZA5 CICS INS: N/A
REQUESTER : OMPDA5 CORRNAME: MIS LUW INS: D13DD32594B7
MAINPACK : ADB2GET CORRNMBR: 'BLANK' LUW SEQ: 4 ENDUSER : MIS
PRIMAUTH : MIS CONNTYPE: TSO TRANSACT: MIS
ORIGAUTH : MIS CONNECT : TSO WSNAME : TSO
ADB2GET ELAPSED TIME EVENTS ADB2GET ELAPSED TIME EVENTS
------------------------- ------------ -------- ------------------------- ------------ --------
GLOBAL CONTENTION L-LOCKS 0.000000 0 GLOBAL CONTENTION P-LOCKS 0.000000 0
PARENT (DB,TS,TAB,PART) 0.000000 0 PAGESET/PARTITION 0.000000 0
CHILD (PAGE,ROW) 0.000000 0 PAGE 0.000000 0
OTHER 0.000000 0 OTHER 0.000000 0
ADB2CON ELAPSED TIME EVENTS ADB2CON ELAPSED TIME EVENTS
------------------------- ------------ -------- ------------------------- ------------ --------
GLOBAL CONTENTION L-LOCKS 0.000000 0 GLOBAL CONTENTION P-LOCKS 0.000000 0
PARENT (DB,TS,TAB,PART) 0.000000 0 PAGESET/PARTITION 0.000000 0
CHILD (PAGE,ROW) 0.000000 0 PAGE 0.000000 0
OTHER 0.000000 0 OTHER 0.000000 0
ADBMAIN ELAPSED TIME EVENTS ADBMAIN ELAPSED TIME EVENTS
------------------------- ------------ -------- ------------------------- ------------ --------
GLOBAL CONTENTION L-LOCKS 0.000000 0 GLOBAL CONTENTION P-LOCKS 0.000000 0
PARENT (DB,TS,TAB,PART) 0.000000 0 PAGESET/PARTITION 0.000000 0
CHILD (PAGE,ROW) 0.000000 0 PAGE 0.000000 0
OTHER 0.000000 0 OTHER 0.000000 0
ADB2GET TOTAL ADB2CON TOTAL ADBMAIN TOTAL
------------------ -------- ------------------ -------- ------------------ --------
SELECT 0 SELECT 0 SELECT 0
INSERT 0 INSERT 0 INSERT 0
UPDATE 0 UPDATE 0 UPDATE 0
DELETE 0 DELETE 0 DELETE 0
DESCRIBE 0 DESCRIBE 0 DESCRIBE 1
PREPARE 0 PREPARE 0 PREPARE 1
OPEN 0 OPEN 0 OPEN 1
FETCH 0 FETCH 0 FETCH 2
CLOSE 0 CLOSE 0 CLOSE 1
LOCK TABLE 0 LOCK TABLE 0 LOCK TABLE 0
CALL 0 CALL 0 CALL 0
LOCATION: OMPDA5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-9
GROUP: N/P ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: DA5 ACTUAL FROM: 08/24/16 08:18:18.92
DB2 VERSION: V10
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 08:18:18.92 PLANNAME: ADB WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 08:17:30.65 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : 08/24/16 08:18:18.92 PROD VER: N/P LUW LUN: IPUAPZA5 CICS INS: N/A
REQUESTER : OMPDA5 CORRNAME: MIS LUW INS: D13DD32594B7
MAINPACK : ADB2GET CORRNMBR: 'BLANK' LUW SEQ: 4 ENDUSER : MIS
PRIMAUTH : MIS CONNTYPE: TSO TRANSACT: MIS
ORIGAUTH : MIS CONNECT : TSO WSNAME : TSO
ADB2GET TOTAL ADB2CON TOTAL ADBMAIN TOTAL
------------------- -------- ------------------- -------- ------------------- --------
BPOOL HIT RATIO (%) 0 BPOOL HIT RATIO (%) 0 BPOOL HIT RATIO (%) 86
GETPAGES 0 GETPAGES 0 GETPAGES 30
BUFFER UPDATES 0 BUFFER UPDATES 0 BUFFER UPDATES 0
SYNCHRONOUS WRITE 0 SYNCHRONOUS WRITE 0 SYNCHRONOUS WRITE 0
SYNCHRONOUS READ 0 SYNCHRONOUS READ 0 SYNCHRONOUS READ 4
SEQ. PREFETCH REQS 0 SEQ. PREFETCH REQS 0 SEQ. PREFETCH REQS 0
LIST PREFETCH REQS 0 LIST PREFETCH REQS 0 LIST PREFETCH REQS 0
DYN. PREFETCH REQS 0 DYN. PREFETCH REQS 0 DYN. PREFETCH REQS 1
PAGES READ ASYNCHR. 0 PAGES READ ASYNCHR. 0 PAGES READ ASYNCHR. 0
ADB2GET TOTAL ADB2CON TOTAL ADBMAIN TOTAL
--------------------- -------- --------------------- -------- --------------------- --------
TIMEOUTS 0 TIMEOUTS 0 TIMEOUTS 0
DEADLOCKS 0 DEADLOCKS 0 DEADLOCKS 0
ESCAL.(SHARED) 0 ESCAL.(SHARED) 0 ESCAL.(SHARED) 0
ESCAL.(EXCLUS) 0 ESCAL.(EXCLUS) 0 ESCAL.(EXCLUS) 0
MAX PG/ROW LOCKS HELD 0 MAX PG/ROW LOCKS HELD 0 MAX PG/ROW LOCKS HELD 0
LOCK REQUEST 2 LOCK REQUEST 0 LOCK REQUEST 36
UNLOCK REQUEST 1 UNLOCK REQUEST 0 UNLOCK REQUEST 3
QUERY REQUEST 0 QUERY REQUEST 0 QUERY REQUEST 0
CHANGE REQUEST 0 CHANGE REQUEST 0 CHANGE REQUEST 1
OTHER REQUEST 0 OTHER REQUEST 0 OTHER REQUEST 0
TOTAL SUSPENSIONS 0 TOTAL SUSPENSIONS 0 TOTAL SUSPENSIONS 0
LOCK SUSPENS 0 LOCK SUSPENS 0 LOCK SUSPENS 0
IRLM LATCH SUSPENS 0 IRLM LATCH SUSPENS 0 IRLM LATCH SUSPENS 0
OTHER SUSPENS 0 OTHER SUSPENS 0 OTHER SUSPENS 0
TIMES CLASS 5 IFI (CL.5)
------------- ----------
ELAPSED TIME 0.000000
CP CPU TIME 0.000000
DCAPT.DESCR. 0.000000
LOG EXTRACT. 0.000000
LOCATION: OMPDA5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-10
GROUP: N/P ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: DA5 ACTUAL FROM: 08/24/16 08:18:18.92
DB2 VERSION: V10
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 08:18:52.80 PLANNAME: DSNUTIL WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 08:18:51.01 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : 08/24/16 08:18:52.80 PROD VER: N/P LUW LUN: IPUAPZA5 CICS INS: N/A
REQUESTER : OMPDA5 CORRNAME: MISIDC LUW INS: D13DD372387C
MAINPACK : DSNUTIL CORRNMBR: 'BLANK' LUW SEQ: 12 ENDUSER : MIS
PRIMAUTH : MIS CONNTYPE: UTILITY TRANSACT: MISIDC
ORIGAUTH : MIS CONNECT : UTILITY WSNAME : UTILITY
MVS ACCOUNTING DATA : 00816,B000,MIS
ACCOUNTING TOKEN(CHAR): N/A
ACCOUNTING TOKEN(HEX) : N/A
ELAPSED TIME DISTRIBUTION CLASS 2 TIME DISTRIBUTION
---------------------------------------------------------------- ----------------------------------------------------------------
APPL !==========================================> 84% CPU !===> 6%
DB2 !> 1% SECPU !
SUSP !=======> 15% NOTACC !> 1%
SUSP !==============================================> 92%
LOCATION: OMPDA5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-11
GROUP: N/P ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: DA5 ACTUAL FROM: 08/24/16 08:18:18.92
DB2 VERSION: V10
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 08:18:52.80 PLANNAME: DSNUTIL WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 08:18:51.01 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : 08/24/16 08:18:52.80 PROD VER: N/P LUW LUN: IPUAPZA5 CICS INS: N/A
REQUESTER : OMPDA5 CORRNAME: MISIDC LUW INS: D13DD372387C
MAINPACK : DSNUTIL CORRNMBR: 'BLANK' LUW SEQ: 12 ENDUSER : MIS
PRIMAUTH : MIS CONNTYPE: UTILITY TRANSACT: MISIDC
ORIGAUTH : MIS CONNECT : UTILITY WSNAME : UTILITY
TIMES/EVENTS APPL(CL.1) DB2 (CL.2) CLASS 3 SUSPENSIONS ELAPSED TIME EVENTS TIME/EVENT HIGHLIGHTS
------------ ---------- ---------- -------------------- ------------ -------- ---------- --------------------------
ELAPSED TIME 1.790735 0.293246 LOCK/LATCH(DB2+IRLM) 0.000000 0 N/C THREAD TYPE : ALLIED
NONNESTED 1.790735 0.293246 IRLM LOCK+LATCH 0.000000 0 N/C TERM.CONDITION: ABNORMAL
STORED PROC 0.000000 0.000000 DB2 LATCH 0.000000 0 N/C INVOKE REASON : PROG ABEND
UDF 0.000000 0.000000 SYNCHRON. I/O 0.113679 37 0.003072 PARALLELISM : NO
TRIGGER 0.000000 0.000000 DATABASE I/O 0.113336 36 0.003148 PCA RUP COUNT : N/A
LOG WRITE I/O 0.000343 1 0.000343 RUP AUTONOM.PR: N/A
CP CPU TIME 0.044812 0.018438 OTHER READ I/O 0.058167 23 0.002529 AUTONOMOUS PR : N/A
AGENT 0.044812 0.018438 OTHER WRTE I/O 0.000000 0 N/C QUANTITY : 0
NONNESTED 0.044812 0.018438 SER.TASK SWTCH 0.099313 14 0.007094 COMMITS : 10
STORED PRC 0.000000 0.000000 UPDATE COMMIT 0.004054 8 0.000507 ROLLBACK : 1
UDF 0.000000 0.000000 OPEN/CLOSE 0.040600 2 0.020300 SVPT REQUESTS : 0
TRIGGER 0.000000 0.000000 SYSLGRNG REC 0.007556 1 0.007556 SVPT RELEASE : 0
PAR.TASKS 0.000000 0.000000 EXT/DEL/DEF 0.045423 2 0.022711 SVPT ROLLBACK : 0
OTHER SERVICE 0.001680 1 0.001680 INCREM.BINDS : N/P
SE CPU TIME 0.000000 0.000000 ARC.LOG(QUIES) 0.000000 0 N/C UPDATE/COMMIT : N/P
NONNESTED 0.000000 0.000000 LOG READ 0.000000 0 N/C SYNCH I/O AVG.: 0.003072
STORED PROC 0.000000 0.000000 DRAIN LOCK 0.000000 0 N/C PROGRAMS : 0
UDF 0.000000 0.000000 CLAIM RELEASE 0.000000 0 N/C MAX CASCADE : N/P
TRIGGER 0.000000 0.000000 PAGE LATCH 0.000000 0 N/C MAX WFILE BLKS: N/A
NOTIFY MSGS 0.000000 0 N/C
PAR.TASKS 0.000000 0.000000 GLOBAL CONTENTION 0.000000 0 N/C
COMMIT PH1 WRITE I/O 0.000000 0 N/C
SUSPEND TIME 0.000000 0.271160 ASYNCH CF REQUESTS 0.000000 0 N/C
AGENT N/A 0.271160 TCP/IP LOB XML 0.000000 0 N/C
PAR.TASKS N/A 0.000000 ACCELERATOR 0.000000 0 N/C
STORED PROC 0.000000 N/A AUTONOMOUS PROCEDURE N/A N/A N/A
UDF 0.000000 N/A PQ SYNCHRONIZATION N/A N/A N/A
LOB COMPRESSION N/A N/A N/A
NOT ACCOUNT. N/A 0.003648 FAST INSERT PIPE N/A N/A N/A
DB2 ENT/EXIT N/A 52 TOTAL CLASS 3 0.271160 74 0.003664
EN/EX-STPROC N/A 0
EN/EX-UDF N/A 0
DCAPT.DESCR. N/A N/A
LOG EXTRACT. N/A N/A
LOCATION: OMPDA5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-12
GROUP: N/P ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: DA5 ACTUAL FROM: 08/24/16 08:18:18.92
DB2 VERSION: V10
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 08:18:52.80 PLANNAME: DSNUTIL WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 08:18:51.01 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : 08/24/16 08:18:52.80 PROD VER: N/P LUW LUN: IPUAPZA5 CICS INS: N/A
REQUESTER : OMPDA5 CORRNAME: MISIDC LUW INS: D13DD372387C
MAINPACK : DSNUTIL CORRNMBR: 'BLANK' LUW SEQ: 12 ENDUSER : MIS
PRIMAUTH : MIS CONNTYPE: UTILITY TRANSACT: MISIDC
ORIGAUTH : MIS CONNECT : UTILITY WSNAME : UTILITY
SQL DML TOTAL SQL DCL TOTAL SQL DDL CREATE DROP ALTER DYNAMIC SQL STMT TOTAL
-------- -------- ---------- -------- ---------- ------ ------ ------ -------------------- --------
SELECT N/P LOCK TABLE N/P TABLE N/P N/P N/P REOPTIMIZATION N/P
INSERT N/P GRANT N/P CRT TTABLE N/P N/A N/A NOT FOUND IN CACHE N/P
ROWS N/P REVOKE N/P DCL TTABLE N/P N/A N/A FOUND IN CACHE N/P
UPDATE N/P SET SQLID N/P AUX TABLE N/P N/A N/A IMPLICIT PREPARES N/P
ROWS N/P SET H.VAR. N/P INDEX N/P N/P N/P PREPARES AVOIDED N/P
MERGE N/P SET DEGREE N/P TABLESPACE N/P N/P N/P CACHE_LIMIT_EXCEEDED N/P
DELETE N/P SET RULES N/P DATABASE N/P N/P N/P PREP_STMT_PURGED N/P
ROWS N/P SET PATH N/P STOGROUP N/P N/P N/P STABILIZED PREPARE N/A
SET PREC. N/P SYNONYM N/P N/P N/A CSWL - STMTS PARSED N/P
DESCRIBE N/P CONNECT 1 N/P VIEW N/P N/P N/P CSWL - LITS REPLACED N/P
DESC.TBL N/P CONNECT 2 N/P ALIAS N/P N/P N/A CSWL - MATCHES FOUND N/P
PREPARE N/P SET CONNEC N/P PACKAGE N/A N/P N/A CSWL - DUPLS CREATED N/P
OPEN N/P RELEASE N/P PROCEDURE N/P N/P N/P
FETCH N/P CALL N/P FUNCTION N/P N/P N/P
ROWS N/P ASSOC LOC. N/P TRIGGER N/P N/P N/A
CLOSE N/P ALLOC CUR. N/P DIST TYPE N/P N/P N/A
HOLD LOC. N/P SEQUENCE N/P N/P N/P
DML-ALL N/P FREE LOC. N/P TRUST. CTX N/P N/P N/P
DCL-ALL N/P ROLE N/P N/P N/A
JAR N/A N/A N/P
MASK/PERM N/P N/P N/P
VARIABLE N/A N/A N/A
TOTAL N/P N/P N/P
TRUNC TBL N/P
RENAME TBL N/P
RENAME IX N/P
COMMENT ON N/P
LABEL ON N/P
LOCATION: OMPDA5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-13
GROUP: N/P ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: DA5 ACTUAL FROM: 08/24/16 08:18:18.92
DB2 VERSION: V10
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 08:18:52.80 PLANNAME: DSNUTIL WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 08:18:51.01 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : 08/24/16 08:18:52.80 PROD VER: N/P LUW LUN: IPUAPZA5 CICS INS: N/A
REQUESTER : OMPDA5 CORRNAME: MISIDC LUW INS: D13DD372387C
MAINPACK : DSNUTIL CORRNMBR: 'BLANK' LUW SEQ: 12 ENDUSER : MIS
PRIMAUTH : MIS CONNTYPE: UTILITY TRANSACT: MISIDC
ORIGAUTH : MIS CONNECT : UTILITY WSNAME : UTILITY
MEASURED/ELIG TIMES APPL (CL1) DB2 (CL2) RID LIST TOTAL DATA CAPTURE TOTAL ROWID TOTAL
------------------- ---------- ---------- ---------------------- -------- ------------ -------- ---------- --------
ELAPSED TIME 1.790735 0.293246 USED N/P IFI CALLS N/P DIR ACCESS N/P
ELIGIBLE FOR ACCEL N/A 0.000000 REC.CAPTURED N/P INDEX USED N/P
FAIL-NO STORAGE N/P LOG REC.READ N/P TS SCAN N/P
CP CPU TIME 0.044812 0.018438 FAIL-LIMIT EXC. N/P ROWS RETURN N/P
ELIGIBLE FOR SECP 0.000000 N/A RECORDS RET. N/P
ELIGIBLE FOR ACCEL N/A 0.000000 INTERRUPTED-NO STORAGE N/P DATA DES.RET N/P
INTERRUPTED-LIMIT EXC. N/P TABLES RET. N/P
SE CPU TIME 0.000000 0.000000 DESCRIBES N/P
ELIGIBLE FOR ACCEL N/A 0.000000 OVERFLOWED-NO STORAGE N/P
OVERFLOWED-LIMIT EXC. N/P
SKIPPED-INDEX KNOWN N/P
GLOBAL CONTENTION L-LOCKS ELAPSED TIME EVENTS GLOBAL CONTENTION P-LOCKS ELAPSED TIME EVENTS
------------------------------------- ------------ -------- ------------------------------------- ------------ --------
L-LOCKS 0.000000 0 P-LOCKS 0.000000 0
PARENT (DB,TS,TAB,PART) 0.000000 0 PAGESET/PARTITION 0.000000 0
CHILD (PAGE,ROW) 0.000000 0 PAGE 0.000000 0
OTHER 0.000000 0 OTHER 0.000000 0
LOCKING TOTAL DATA SHARING TOTAL QUERY PARALLELISM TOTAL DRAIN/CLAIM TOTAL
------------------- -------- ------------ -------- ------------------------- -------- ------------ --------
TIMEOUTS 0 GLOB CONT(%) N/C MAXIMUM DEGREE-ESTIMATED N/A DRAIN REQST 1
DEADLOCKS 0 FALS CONT(%) N/C MAXIMUM DEGREE-PLANNED N/A DRAIN FAILED 0
ESCAL.(SHAR) 0 P/L-LOCKS(%) N/P MAXIMUM DEGREE-EXECUTED N/P CLAIM REQST 51
ESCAL.(EXCL) 0 P-LOCK REQ N/P MAXIMUM MEMBERS USED N/P CLAIM FAILED 0
MAX PG/ROW LCK HELD 4 P-UNLOCK REQ N/P PARALLEL GROUPS EXECUTED N/P
LOCK REQUEST 51 P-CHANGE REQ N/P RAN AS PLANNED N/P
UNLOCK REQST 26 LOCK - XES N/P RAN REDUCED-STORAGE N/P
QUERY REQST 2 UNLOCK-XES N/P RAN REDUCED-NEGOTIATION N/A
CHANGE REQST 6 CHANGE-XES N/P SEQ-CURSOR N/P
OTHER REQST 0 SUSP - IRLM N/P SEQ-NO ESA SORT N/P
TOTAL SUSPENSIONS 0 SUSP - XES N/P SEQ-NO BUFFER N/P
LOCK SUSPENS 0 CONV - XES N/P SEQ-AUTONOMOUS PROC N/A
IRLM LATCH SUSPENS 0 FALSE CONT N/P SEQ-NEGOTIATION N/A
OTHER SUSPENS 0 INCOMP.LOCK N/P ONE DB2-COORDINATOR = NO N/P
NOTIFY SENT N/P ONE DB2-ISOLATION LEVEL N/P
ONE DB2-DCL TTABLE N/P
MEMB SKIPPED(%) N/P
DISABLED BY RLF N/P
REFORM PARAL-CONFIG N/P
REFORM PARAL-NO BUF N/P
LOCATION: OMPDA5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-14
GROUP: N/P ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: DA5 ACTUAL FROM: 08/24/16 08:18:18.92
DB2 VERSION: V10
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 08:18:52.80 PLANNAME: DSNUTIL WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 08:18:51.01 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : 08/24/16 08:18:52.80 PROD VER: N/P LUW LUN: IPUAPZA5 CICS INS: N/A
REQUESTER : OMPDA5 CORRNAME: MISIDC LUW INS: D13DD372387C
MAINPACK : DSNUTIL CORRNMBR: 'BLANK' LUW SEQ: 12 ENDUSER : MIS
PRIMAUTH : MIS CONNTYPE: UTILITY TRANSACT: MISIDC
ORIGAUTH : MIS CONNECT : UTILITY WSNAME : UTILITY
STORED PROC. TOTAL UDF TOTAL TRIGGERS TOTAL LOGGING TOTAL
------------ -------- --------- -------- ------------ -------- ----------------- --------
CALL STMTS N/P EXECUTED N/P STMT TRIGGER N/P LOG RECS WRITTEN 47
ABENDED N/P ABENDED N/P ROW TRIGGER N/P TOT BYTES WRITTEN 34283
TIMED OUT N/P TIMED OUT N/P SQL ERROR N/P
REJECTED N/P REJECTED N/P
TOTAL SU CLASS 1 CLASS 2 MISCELLANEOUS TOTAL
------------ -------------- -------------- -------------------- --------
CP CPU 2902 1194 MAX STO LOB VAL (KB) N/P
AGENT 2902 1194 MAX STO XML VAL (KB) N/P
NONNESTED 2902 1194 ARRAY EXPANSIONS N/A
STORED PRC 0 0 SPARSE IX DISABLED N/A
UDF 0 0 SPARSE IX BUILT WF N/A
TRIGGER 0 0
PAR.TASKS 0 0
ELIG SECP 0 N/A
ELIG ACCEL N/A 0
SE CPU 0 0
NONNESTED 0 0
STORED PROC 0 0
UDF 0 0
TRIGGER 0 0
PAR.TASKS 0 0
ELIG ACCEL N/A 0
---- RESOURCE LIMIT FACILITY --------------------------------------------------------------------------------------------------
TYPE: N/P TABLE ID: N/P SERV.UNITS: N/P CPU SECONDS: 0.000000 MAX CPU SEC: N/P
BP0 BPOOL ACTIVITY TOTAL BP32K BPOOL ACTIVITY TOTAL BP8K BPOOL ACTIVITY TOTAL
--------------------- -------- --------------------- -------- --------------------- --------
BPOOL HIT RATIO (%) 53 BPOOL HIT RATIO (%) -23 BPOOL HIT RATIO (%) 96
GETPAGES 95 GETPAGES 215 GETPAGES 490
BUFFER UPDATES 3 BUFFER UPDATES 9 BUFFER UPDATES 0
SYNCHRONOUS WRITE 0 SYNCHRONOUS WRITE 0 SYNCHRONOUS WRITE 0
SYNCHRONOUS READ 28 SYNCHRONOUS READ 8 SYNCHRONOUS READ 0
SEQ. PREFETCH REQS 0 SEQ. PREFETCH REQS 16 SEQ. PREFETCH REQS 0
LIST PREFETCH REQS 0 LIST PREFETCH REQS 0 LIST PREFETCH REQS 0
DYN. PREFETCH REQS 4 DYN. PREFETCH REQS 36 DYN. PREFETCH REQS 62
PAGES READ ASYNCHR. 17 PAGES READ ASYNCHR. 256 PAGES READ ASYNCHR. 22
LOCATION: OMPDA5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-15
GROUP: N/P ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: DA5 ACTUAL FROM: 08/24/16 08:18:18.92
DB2 VERSION: V10
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 08:18:52.80 PLANNAME: DSNUTIL WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 08:18:51.01 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : 08/24/16 08:18:52.80 PROD VER: N/P LUW LUN: IPUAPZA5 CICS INS: N/A
REQUESTER : OMPDA5 CORRNAME: MISIDC LUW INS: D13DD372387C
MAINPACK : DSNUTIL CORRNMBR: 'BLANK' LUW SEQ: 12 ENDUSER : MIS
PRIMAUTH : MIS CONNTYPE: UTILITY TRANSACT: MISIDC
ORIGAUTH : MIS CONNECT : UTILITY WSNAME : UTILITY
TOTAL BPOOL ACTIVITY TOTAL
--------------------- --------
BPOOL HIT RATIO (%) 59
GETPAGES 800
BUFFER UPDATES 12
SYNCHRONOUS WRITE 0
SYNCHRONOUS READ 36
SEQ. PREFETCH REQS 16
LIST PREFETCH REQS 0
DYN. PREFETCH REQS 102
PAGES READ ASYNCHR. 295
TIMES CLASS 5 IFI (CL.5)
------------- ----------
ELAPSED TIME N/P
CP CPU TIME N/P
DCAPT.DESCR. N/P
LOG EXTRACT. N/P
LOCATION: OMPDA5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-16
GROUP: N/P ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: DA5 ACTUAL FROM: 08/24/16 08:18:18.92
DB2 VERSION: V10
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 08:21:00.90 PLANNAME: ADB27SPC WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 08:21:00.82 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : 08/24/16 08:21:00.90 PROD VER: N/P LUW LUN: IPUAPZA5 CICS INS: N/A
REQUESTER : OMPDA5 CORRNAME: MIS LUW INS: D13DD3EE0073
MAINPACK : ADB27SP CORRNMBR: 'BLANK' LUW SEQ: 2 ENDUSER : MIS
PRIMAUTH : MIS CONNTYPE: TSO TRANSACT: MIS
ORIGAUTH : MIS CONNECT : TSO WSNAME : TSO
MVS ACCOUNTING DATA : DE03704
ACCOUNTING TOKEN(CHAR): N/A
ACCOUNTING TOKEN(HEX) : N/A
ELAPSED TIME DISTRIBUTION CLASS 2 TIME DISTRIBUTION
---------------------------------------------------------------- ----------------------------------------------------------------
APPL !=> 2% CPU !=> 2%
DB2 !=> 2% SECPU !
SUSP !================================================> 96% NOTACC !
SUSP !=================================================> 98%
LOCATION: OMPDA5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-17
GROUP: N/P ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: DA5 ACTUAL FROM: 08/24/16 08:18:18.92
DB2 VERSION: V10
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 08:21:00.90 PLANNAME: ADB27SPC WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 08:21:00.82 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : 08/24/16 08:21:00.90 PROD VER: N/P LUW LUN: IPUAPZA5 CICS INS: N/A
REQUESTER : OMPDA5 CORRNAME: MIS LUW INS: D13DD3EE0073
MAINPACK : ADB27SP CORRNMBR: 'BLANK' LUW SEQ: 2 ENDUSER : MIS
PRIMAUTH : MIS CONNTYPE: TSO TRANSACT: MIS
ORIGAUTH : MIS CONNECT : TSO WSNAME : TSO
TIMES/EVENTS APPL(CL.1) DB2 (CL.2) CLASS 3 SUSPENSIONS ELAPSED TIME EVENTS TIME/EVENT HIGHLIGHTS
------------ ---------- ---------- -------------------- ------------ -------- ---------- --------------------------
ELAPSED TIME 0.077495 0.075858 LOCK/LATCH(DB2+IRLM) 0.000000 0 N/C THREAD TYPE : ALLIED
NONNESTED 0.077495 0.075858 IRLM LOCK+LATCH 0.000000 0 N/C TERM.CONDITION: NORMAL
STORED PROC 0.000000 0.000000 DB2 LATCH 0.000000 0 N/C INVOKE REASON : DEALLOC
UDF 0.000000 0.000000 SYNCHRON. I/O 0.037141 9 0.004127 PARALLELISM : NO
TRIGGER 0.000000 0.000000 DATABASE I/O 0.037141 9 0.004127 PCA RUP COUNT : N/A
LOG WRITE I/O 0.000000 0 N/C RUP AUTONOM.PR: N/A
CP CPU TIME 0.002113 0.001597 OTHER READ I/O 0.037073 11 0.003370 AUTONOMOUS PR : N/A
AGENT 0.002113 0.001597 OTHER WRTE I/O 0.000000 0 N/C QUANTITY : 0
NONNESTED 0.002113 0.001597 SER.TASK SWTCH 0.000000 0 N/C COMMITS : 1
STORED PRC 0.000000 0.000000 UPDATE COMMIT 0.000000 0 N/C ROLLBACK : 0
UDF 0.000000 0.000000 OPEN/CLOSE 0.000000 0 N/C SVPT REQUESTS : 0
TRIGGER 0.000000 0.000000 SYSLGRNG REC 0.000000 0 N/C SVPT RELEASE : 0
PAR.TASKS 0.000000 0.000000 EXT/DEL/DEF 0.000000 0 N/C SVPT ROLLBACK : 0
OTHER SERVICE 0.000000 0 N/C INCREM.BINDS : 0
SE CPU TIME 0.000000 0.000000 ARC.LOG(QUIES) 0.000000 0 N/C UPDATE/COMMIT : 0.00
NONNESTED 0.000000 0.000000 LOG READ 0.000000 0 N/C SYNCH I/O AVG.: 0.004127
STORED PROC 0.000000 0.000000 DRAIN LOCK 0.000000 0 N/C PROGRAMS : 1
UDF 0.000000 0.000000 CLAIM RELEASE 0.000000 0 N/C MAX CASCADE : 0
TRIGGER 0.000000 0.000000 PAGE LATCH 0.000000 0 N/C MAX WFILE BLKS: N/A
NOTIFY MSGS 0.000000 0 N/C
PAR.TASKS 0.000000 0.000000 GLOBAL CONTENTION 0.000000 0 N/C
COMMIT PH1 WRITE I/O 0.000000 0 N/C
SUSPEND TIME 0.000000 0.074214 ASYNCH CF REQUESTS 0.000000 0 N/C
AGENT N/A 0.074214 TCP/IP LOB XML 0.000000 0 N/C
PAR.TASKS N/A 0.000000 ACCELERATOR 0.000000 0 N/C
STORED PROC 0.000000 N/A AUTONOMOUS PROCEDURE N/A N/A N/A
UDF 0.000000 N/A PQ SYNCHRONIZATION N/A N/A N/A
LOB COMPRESSION N/A N/A N/A
NOT ACCOUNT. N/A 0.000047 FAST INSERT PIPE N/A N/A N/A
DB2 ENT/EXIT N/A 22 TOTAL CLASS 3 0.074214 20 0.003711
EN/EX-STPROC N/A 0
EN/EX-UDF N/A 0
DCAPT.DESCR. N/A N/A
LOG EXTRACT. N/A N/A
LOCATION: OMPDA5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-18
GROUP: N/P ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: DA5 ACTUAL FROM: 08/24/16 08:18:18.92
DB2 VERSION: V10
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 08:21:00.90 PLANNAME: ADB27SPC WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 08:21:00.82 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : 08/24/16 08:21:00.90 PROD VER: N/P LUW LUN: IPUAPZA5 CICS INS: N/A
REQUESTER : OMPDA5 CORRNAME: MIS LUW INS: D13DD3EE0073
MAINPACK : ADB27SP CORRNMBR: 'BLANK' LUW SEQ: 2 ENDUSER : MIS
PRIMAUTH : MIS CONNTYPE: TSO TRANSACT: MIS
ORIGAUTH : MIS CONNECT : TSO WSNAME : TSO
SQL DML TOTAL SQL DCL TOTAL SQL DDL CREATE DROP ALTER DYNAMIC SQL STMT TOTAL
-------- -------- ---------- -------- ---------- ------ ------ ------ -------------------- --------
SELECT 0 LOCK TABLE 0 TABLE 0 0 0 REOPTIMIZATION 0
INSERT 0 GRANT 0 CRT TTABLE 0 N/A N/A NOT FOUND IN CACHE 0
ROWS 0 REVOKE 0 DCL TTABLE 0 N/A N/A FOUND IN CACHE 0
UPDATE 0 SET SQLID 0 AUX TABLE 0 N/A N/A IMPLICIT PREPARES 0
ROWS 0 SET H.VAR. 3 INDEX 0 0 0 PREPARES AVOIDED 0
MERGE 0 SET DEGREE 0 TABLESPACE 0 0 0 CACHE_LIMIT_EXCEEDED 0
DELETE 0 SET RULES 0 DATABASE 0 0 0 PREP_STMT_PURGED 0
ROWS 0 SET PATH 0 STOGROUP 0 0 0 STABILIZED PREPARE N/A
SET PREC. 0 SYNONYM 0 0 N/A CSWL - STMTS PARSED 0
DESCRIBE 0 CONNECT 1 0 VIEW 0 0 0 CSWL - LITS REPLACED 0
DESC.TBL 0 CONNECT 2 1 ALIAS 0 0 N/A CSWL - MATCHES FOUND 0
PREPARE 0 SET CONNEC 0 PACKAGE N/A 0 N/A CSWL - DUPLS CREATED 0
OPEN 1 RELEASE 0 PROCEDURE 0 0 0
FETCH 2 CALL 0 FUNCTION 0 0 0
ROWS 1 ASSOC LOC. 0 TRIGGER 0 0 N/A
CLOSE 1 ALLOC CUR. 0 DIST TYPE 0 0 N/A
HOLD LOC. 0 SEQUENCE 0 0 0
DML-ALL 4 FREE LOC. 0 TRUST. CTX 0 0 0
DCL-ALL 4 ROLE 0 0 N/A
JAR N/A N/A 0
MASK/PERM 0 0 0
VARIABLE N/A N/A N/A
TOTAL 0 0 0
TRUNC TBL 0
RENAME TBL 0
RENAME IX 0
COMMENT ON 0
LABEL ON 0
LOCATION: OMPDA5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-19
GROUP: N/P ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: DA5 ACTUAL FROM: 08/24/16 08:18:18.92
DB2 VERSION: V10
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 08:21:00.90 PLANNAME: ADB27SPC WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 08:21:00.82 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : 08/24/16 08:21:00.90 PROD VER: N/P LUW LUN: IPUAPZA5 CICS INS: N/A
REQUESTER : OMPDA5 CORRNAME: MIS LUW INS: D13DD3EE0073
MAINPACK : ADB27SP CORRNMBR: 'BLANK' LUW SEQ: 2 ENDUSER : MIS
PRIMAUTH : MIS CONNTYPE: TSO TRANSACT: MIS
ORIGAUTH : MIS CONNECT : TSO WSNAME : TSO
MEASURED/ELIG TIMES APPL (CL1) DB2 (CL2) RID LIST TOTAL DATA CAPTURE TOTAL ROWID TOTAL
------------------- ---------- ---------- ---------------------- -------- ------------ -------- ---------- --------
ELAPSED TIME 0.077495 0.075858 USED 0 IFI CALLS N/P DIR ACCESS 0
ELIGIBLE FOR ACCEL N/A 0.000000 REC.CAPTURED N/P INDEX USED 0
FAIL-NO STORAGE 0 LOG REC.READ N/P TS SCAN 0
CP CPU TIME 0.002113 0.001597 FAIL-LIMIT EXC. 0 ROWS RETURN N/P
ELIGIBLE FOR SECP 0.000000 N/A RECORDS RET. N/P
ELIGIBLE FOR ACCEL N/A 0.000000 INTERRUPTED-NO STORAGE 0 DATA DES.RET N/P
INTERRUPTED-LIMIT EXC. 0 TABLES RET. N/P
SE CPU TIME 0.000000 0.000000 DESCRIBES N/P
ELIGIBLE FOR ACCEL N/A 0.000000 OVERFLOWED-NO STORAGE 0
OVERFLOWED-LIMIT EXC. 0
SKIPPED-INDEX KNOWN 0
GLOBAL CONTENTION L-LOCKS ELAPSED TIME EVENTS GLOBAL CONTENTION P-LOCKS ELAPSED TIME EVENTS
------------------------------------- ------------ -------- ------------------------------------- ------------ --------
L-LOCKS 0.000000 0 P-LOCKS 0.000000 0
PARENT (DB,TS,TAB,PART) 0.000000 0 PAGESET/PARTITION 0.000000 0
CHILD (PAGE,ROW) 0.000000 0 PAGE 0.000000 0
OTHER 0.000000 0 OTHER 0.000000 0
LOCKING TOTAL DATA SHARING TOTAL QUERY PARALLELISM TOTAL DRAIN/CLAIM TOTAL
------------------- -------- ------------ -------- ------------------------- -------- ------------ --------
TIMEOUTS 0 GLOB CONT(%) N/C MAXIMUM DEGREE-ESTIMATED N/A DRAIN REQST 0
DEADLOCKS 0 FALS CONT(%) N/C MAXIMUM DEGREE-PLANNED N/A DRAIN FAILED 0
ESCAL.(SHAR) 0 P/L-LOCKS(%) N/P MAXIMUM DEGREE-EXECUTED 0 CLAIM REQST 7
ESCAL.(EXCL) 0 P-LOCK REQ N/P MAXIMUM MEMBERS USED N/P CLAIM FAILED 0
MAX PG/ROW LCK HELD 2 P-UNLOCK REQ N/P PARALLEL GROUPS EXECUTED 0
LOCK REQUEST 5 P-CHANGE REQ N/P RAN AS PLANNED 0
UNLOCK REQST 3 LOCK - XES N/P RAN REDUCED-STORAGE 0
QUERY REQST 0 UNLOCK-XES N/P RAN REDUCED-NEGOTIATION N/A
CHANGE REQST 0 CHANGE-XES N/P SEQ-CURSOR 0
OTHER REQST 0 SUSP - IRLM N/P SEQ-NO ESA SORT 0
TOTAL SUSPENSIONS 0 SUSP - XES N/P SEQ-NO BUFFER 0
LOCK SUSPENS 0 CONV - XES N/P SEQ-AUTONOMOUS PROC N/A
IRLM LATCH SUSPENS 0 FALSE CONT N/P SEQ-NEGOTIATION N/A
OTHER SUSPENS 0 INCOMP.LOCK N/P ONE DB2-COORDINATOR = NO 0
NOTIFY SENT N/P ONE DB2-ISOLATION LEVEL 0
ONE DB2-DCL TTABLE 0
MEMB SKIPPED(%) 0
DISABLED BY RLF NO
REFORM PARAL-CONFIG 0
REFORM PARAL-NO BUF 0
LOCATION: OMPDA5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-20
GROUP: N/P ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: DA5 ACTUAL FROM: 08/24/16 08:18:18.92
DB2 VERSION: V10
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 08:21:00.90 PLANNAME: ADB27SPC WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 08:21:00.82 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : 08/24/16 08:21:00.90 PROD VER: N/P LUW LUN: IPUAPZA5 CICS INS: N/A
REQUESTER : OMPDA5 CORRNAME: MIS LUW INS: D13DD3EE0073
MAINPACK : ADB27SP CORRNMBR: 'BLANK' LUW SEQ: 2 ENDUSER : MIS
PRIMAUTH : MIS CONNTYPE: TSO TRANSACT: MIS
ORIGAUTH : MIS CONNECT : TSO WSNAME : TSO
STORED PROC. TOTAL UDF TOTAL TRIGGERS TOTAL LOGGING TOTAL
------------ -------- --------- -------- ------------ -------- ----------------- --------
CALL STMTS 0 EXECUTED 0 STMT TRIGGER 0 LOG RECS WRITTEN 0
ABENDED 0 ABENDED 0 ROW TRIGGER 0 TOT BYTES WRITTEN 0
TIMED OUT 0 TIMED OUT 0 SQL ERROR 0
REJECTED 0 REJECTED 0
TOTAL SU CLASS 1 CLASS 2 MISCELLANEOUS TOTAL
------------ -------------- -------------- -------------------- --------
CP CPU 136 103 MAX STO LOB VAL (KB) 0
AGENT 136 103 MAX STO XML VAL (KB) 0
NONNESTED 136 103 ARRAY EXPANSIONS N/A
STORED PRC 0 0 SPARSE IX DISABLED N/A
UDF 0 0 SPARSE IX BUILT WF N/A
TRIGGER 0 0
PAR.TASKS 0 0
ELIG SECP 0 N/A
ELIG ACCEL N/A 0
SE CPU 0 0
NONNESTED 0 0
STORED PROC 0 0
UDF 0 0
TRIGGER 0 0
PAR.TASKS 0 0
ELIG ACCEL N/A 0
---- RESOURCE LIMIT FACILITY --------------------------------------------------------------------------------------------------
TYPE: N/P TABLE ID: N/P SERV.UNITS: N/P CPU SECONDS: 0.000000 MAX CPU SEC: N/P
BP0 BPOOL ACTIVITY TOTAL BP32K BPOOL ACTIVITY TOTAL TOTAL BPOOL ACTIVITY TOTAL
--------------------- -------- --------------------- -------- --------------------- --------
BPOOL HIT RATIO (%) -9 BPOOL HIT RATIO (%) 0 BPOOL HIT RATIO (%) -9
GETPAGES 342 GETPAGES 4 GETPAGES 346
BUFFER UPDATES 0 BUFFER UPDATES 0 BUFFER UPDATES 0
SYNCHRONOUS WRITE 0 SYNCHRONOUS WRITE 0 SYNCHRONOUS WRITE 0
SYNCHRONOUS READ 5 SYNCHRONOUS READ 4 SYNCHRONOUS READ 9
SEQ. PREFETCH REQS 12 SEQ. PREFETCH REQS 0 SEQ. PREFETCH REQS 12
LIST PREFETCH REQS 0 LIST PREFETCH REQS 0 LIST PREFETCH REQS 0
DYN. PREFETCH REQS 0 DYN. PREFETCH REQS 0 DYN. PREFETCH REQS 0
PAGES READ ASYNCHR. 368 PAGES READ ASYNCHR. 0 PAGES READ ASYNCHR. 368
LOCATION: OMPDA5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-21
GROUP: N/P ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: DA5 ACTUAL FROM: 08/24/16 08:18:18.92
DB2 VERSION: V10
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 08:21:00.90 PLANNAME: ADB27SPC WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 08:21:00.82 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : 08/24/16 08:21:00.90 PROD VER: N/P LUW LUN: IPUAPZA5 CICS INS: N/A
REQUESTER : OMPDA5 CORRNAME: MIS LUW INS: D13DD3EE0073
MAINPACK : ADB27SP CORRNMBR: 'BLANK' LUW SEQ: 2 ENDUSER : MIS
PRIMAUTH : MIS CONNTYPE: TSO TRANSACT: MIS
ORIGAUTH : MIS CONNECT : TSO WSNAME : TSO
ADB27SP VALUE ADB27SP TIMES ADB27SP TIME EVENTS TIME/EVENT
------------------ ------------------ ------------------ ------------ ------------------ ------------ ------ ------------
TYPE PACKAGE ELAPSED TIME - CL7 0.051289 LOCK/LATCH 0.000000 0 N/C
LOCATION OMPDA5 CP CPU TIME 0.001345 IRLM LOCK+LATCH 0.000000 0 N/C
COLLECTION ID ADBL AGENT 0.001345 DB2 LATCH 0.000000 0 N/C
PROGRAM NAME ADB27SP PAR.TASKS 0.000000 SYNCHRONOUS I/O 0.012782 4 0.003196
CONSISTENCY TOKEN 193DB59E0EC52F17 SE CPU TIME 0.000000 OTHER READ I/O 0.037073 11 0.003370
ACTIVITY TYPE NONNESTED SUSPENSION-CL8 0.049855 OTHER WRITE I/O 0.000000 0 N/C
ACTIVITY NAME 'BLANK' AGENT 0.049855 SERV.TASK SWITCH 0.000000 0 N/C
SCHEMA NAME 'BLANK' PAR.TASKS 0.000000 ARCH.LOG(QUIESCE) 0.000000 0 N/C
SUCC AUTH CHECK NO NOT ACCOUNTED 0.000088 ARCHIVE LOG READ 0.000000 0 N/C
NBR OF ALLOCATIONS 1 DRAIN LOCK 0.000000 0 N/C
SQL STMT - AVERAGE 9.00 CP CPU SU 87 CLAIM RELEASE 0.000000 0 N/C
SQL STMT - TOTAL 9 AGENT 87 PAGE LATCH 0.000000 0 N/C
NBR RLUP THREADS 1 PAR.TASKS 0 NOTIFY MESSAGES 0.000000 0 N/C
SE CPU SU 0 GLOBAL CONTENTION 0.000000 0 N/C
TCP/IP LOB XML 0.000000 0 N/C
DB2 ENTRY/EXIT 20 ACCELERATOR 0.000000 0 N/C
PQ SYNCHRONIZATION N/A N/A N/A
FAST INSERT PIPE N/A N/A N/A
TOTAL CL8 SUSPENS. 0.049855 15 0.003324
ADB27SP ELAPSED TIME EVENTS ADB27SP ELAPSED TIME EVENTS
------------------------- ------------ -------- ------------------------- ------------ --------
GLOBAL CONTENTION L-LOCKS 0.000000 0 GLOBAL CONTENTION P-LOCKS 0.000000 0
PARENT (DB,TS,TAB,PART) 0.000000 0 PAGESET/PARTITION 0.000000 0
CHILD (PAGE,ROW) 0.000000 0 PAGE 0.000000 0
OTHER 0.000000 0 OTHER 0.000000 0
ADB27SP TOTAL
------------------ --------
SELECT 0
INSERT 0
UPDATE 0
DELETE 0
DESCRIBE 0
PREPARE 0
OPEN 1
FETCH 2
CLOSE 1
LOCK TABLE 0
CALL 0
LOCATION: OMPDA5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-22
GROUP: N/P ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: DA5 ACTUAL FROM: 08/24/16 08:18:18.92
DB2 VERSION: V10
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 08:21:00.90 PLANNAME: ADB27SPC WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 08:21:00.82 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : 08/24/16 08:21:00.90 PROD VER: N/P LUW LUN: IPUAPZA5 CICS INS: N/A
REQUESTER : OMPDA5 CORRNAME: MIS LUW INS: D13DD3EE0073
MAINPACK : ADB27SP CORRNMBR: 'BLANK' LUW SEQ: 2 ENDUSER : MIS
PRIMAUTH : MIS CONNTYPE: TSO TRANSACT: MIS
ORIGAUTH : MIS CONNECT : TSO WSNAME : TSO
ADB27SP TOTAL
------------------- --------
BPOOL HIT RATIO (%) -9
GETPAGES 339
BUFFER UPDATES 0
SYNCHRONOUS WRITE 0
SYNCHRONOUS READ 4
SEQ. PREFETCH REQS 12
LIST PREFETCH REQS 0
DYN. PREFETCH REQS 0
PAGES READ ASYNCHR. 368
ADB27SP TOTAL
--------------------- --------
TIMEOUTS 0
DEADLOCKS 0
ESCAL.(SHARED) 0
ESCAL.(EXCLUS) 0
MAX PG/ROW LOCKS HELD 2
LOCK REQUEST 2
UNLOCK REQUEST 2
QUERY REQUEST 0
CHANGE REQUEST 0
OTHER REQUEST 0
TOTAL SUSPENSIONS 0
LOCK SUSPENS 0
IRLM LATCH SUSPENS 0
OTHER SUSPENS 0
TIMES CLASS 5 IFI (CL.5)
------------- ----------
ELAPSED TIME N/P
CP CPU TIME N/P
DCAPT.DESCR. N/P
LOG EXTRACT. N/P
LOCATION: OMPDA5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-23
GROUP: N/P ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: DA5 ACTUAL FROM: 08/24/16 08:18:18.92
DB2 VERSION: V10
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 08:21:01.25 PLANNAME: ADB27SPC WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 08:21:01.12 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : 08/24/16 08:21:01.25 PROD VER: N/P LUW LUN: IPUAPZA5 CICS INS: N/A
REQUESTER : OMPDA5 CORRNAME: MIS LUW INS: D13DD3EE4E35
MAINPACK : ADB27SP CORRNMBR: 'BLANK' LUW SEQ: 2 ENDUSER : MIS
PRIMAUTH : MIS CONNTYPE: TSO TRANSACT: MIS
ORIGAUTH : MIS CONNECT : TSO WSNAME : TSO
MVS ACCOUNTING DATA : DE03704
ACCOUNTING TOKEN(CHAR): N/A
ACCOUNTING TOKEN(HEX) : N/A
ELAPSED TIME DISTRIBUTION CLASS 2 TIME DISTRIBUTION
---------------------------------------------------------------- ----------------------------------------------------------------
APPL !=> 2% CPU !===> 7%
DB2 !========> 17% SECPU !
SUSP !========================================> 81% NOTACC !=====> 10%
SUSP !=========================================> 83%
LOCATION: OMPDA5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-24
GROUP: N/P ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: DA5 ACTUAL FROM: 08/24/16 08:18:18.92
DB2 VERSION: V10
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 08:21:01.25 PLANNAME: ADB27SPC WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 08:21:01.12 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : 08/24/16 08:21:01.25 PROD VER: N/P LUW LUN: IPUAPZA5 CICS INS: N/A
REQUESTER : OMPDA5 CORRNAME: MIS LUW INS: D13DD3EE4E35
MAINPACK : ADB27SP CORRNMBR: 'BLANK' LUW SEQ: 2 ENDUSER : MIS
PRIMAUTH : MIS CONNTYPE: TSO TRANSACT: MIS
ORIGAUTH : MIS CONNECT : TSO WSNAME : TSO
TIMES/EVENTS APPL(CL.1) DB2 (CL.2) CLASS 3 SUSPENSIONS ELAPSED TIME EVENTS TIME/EVENT HIGHLIGHTS
------------ ---------- ---------- -------------------- ------------ -------- ---------- --------------------------
ELAPSED TIME 0.127365 0.125321 LOCK/LATCH(DB2+IRLM) 0.000000 0 N/C THREAD TYPE : ALLIED
NONNESTED 0.127365 0.125321 IRLM LOCK+LATCH 0.000000 0 N/C TERM.CONDITION: NORMAL
STORED PROC 0.000000 0.000000 DB2 LATCH 0.000000 0 N/C INVOKE REASON : DEALLOC
UDF 0.000000 0.000000 SYNCHRON. I/O 0.017855 11 0.001623 PARALLELISM : NO
TRIGGER 0.000000 0.000000 DATABASE I/O 0.017855 11 0.001623 PCA RUP COUNT : N/A
LOG WRITE I/O 0.000000 0 N/C RUP AUTONOM.PR: N/A
CP CPU TIME 0.010110 0.009326 OTHER READ I/O 0.040477 2 0.020239 AUTONOMOUS PR : N/A
AGENT 0.010110 0.009326 OTHER WRTE I/O 0.000000 0 N/C QUANTITY : 0
NONNESTED 0.010110 0.009326 SER.TASK SWTCH 0.045219 2 0.022610 COMMITS : 1
STORED PRC 0.000000 0.000000 UPDATE COMMIT 0.000000 0 N/C ROLLBACK : 0
UDF 0.000000 0.000000 OPEN/CLOSE 0.018981 1 0.018981 SVPT REQUESTS : 0
TRIGGER 0.000000 0.000000 SYSLGRNG REC 0.000000 0 N/C SVPT RELEASE : 0
PAR.TASKS 0.000000 0.000000 EXT/DEL/DEF 0.026238 1 0.026238 SVPT ROLLBACK : 0
OTHER SERVICE 0.000000 0 N/C INCREM.BINDS : 0
SE CPU TIME 0.000000 0.000000 ARC.LOG(QUIES) 0.000000 0 N/C UPDATE/COMMIT : 0.00
NONNESTED 0.000000 0.000000 LOG READ 0.000000 0 N/C SYNCH I/O AVG.: 0.001623
STORED PROC 0.000000 0.000000 DRAIN LOCK 0.000000 0 N/C PROGRAMS : 1
UDF 0.000000 0.000000 CLAIM RELEASE 0.000000 0 N/C MAX CASCADE : 0
TRIGGER 0.000000 0.000000 PAGE LATCH 0.000000 0 N/C MAX WFILE BLKS: N/A
NOTIFY MSGS 0.000000 0 N/C
PAR.TASKS 0.000000 0.000000 GLOBAL CONTENTION 0.000000 0 N/C
COMMIT PH1 WRITE I/O 0.000000 0 N/C
SUSPEND TIME 0.000000 0.103551 ASYNCH CF REQUESTS 0.000000 0 N/C
AGENT N/A 0.103551 TCP/IP LOB XML 0.000000 0 N/C
PAR.TASKS N/A 0.000000 ACCELERATOR 0.000000 0 N/C
STORED PROC 0.000000 N/A AUTONOMOUS PROCEDURE N/A N/A N/A
UDF 0.000000 N/A PQ SYNCHRONIZATION N/A N/A N/A
LOB COMPRESSION N/A N/A N/A
NOT ACCOUNT. N/A 0.012443 FAST INSERT PIPE N/A N/A N/A
DB2 ENT/EXIT N/A 34 TOTAL CLASS 3 0.103551 15 0.006903
EN/EX-STPROC N/A 0
EN/EX-UDF N/A 0
DCAPT.DESCR. N/A N/A
LOG EXTRACT. N/A N/A
LOCATION: OMPDA5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-25
GROUP: N/P ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: DA5 ACTUAL FROM: 08/24/16 08:18:18.92
DB2 VERSION: V10
...
LOCATION: OMPDBC1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-1
GROUP: DBC1 ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SC11 TO: NOT SPECIFIED
SUBSYSTEM: SC11 ACTUAL FROM: 08/24/16 07:02:00.00
DB2 VERSION: V12
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 07:02:00.00 PLANNAME: KO2PLAN WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 06:49:59.14 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : N/P PROD VER: N/P LUW LUN: IPUAPC11 CICS INS: N/A
REQUESTER : OMPDBC1 CORRNAME: 'BLANK' LUW INS: D13DC1A0FC96
MAINPACK : KO2PLAN CORRNMBR: 'BLANK' LUW SEQ: 7 ENDUSER : DB2PM
PRIMAUTH : DB2PM CONNTYPE: RRS TRANSACT: 'BLANK'
ORIGAUTH : DB2PM CONNECT : RRSAF WSNAME : RRSAF
MVS ACCOUNTING DATA : 'BLANK'
ACCOUNTING TOKEN(CHAR): 'BLANK'
ACCOUNTING TOKEN(HEX) : 00000000000000000000000000000000000000000000
ELAPSED TIME DISTRIBUTION CLASS 2 TIME DISTRIBUTION
---------------------------------------------------------------- ----------------------------------------------------------------
APPL !> 1% CPU !=====> 11%
DB2 !=======> 15% SECPU !
SUSP !==========================================> 84% NOTACC !==> 4%
SUSP !==========================================> 85%
LOCATION: OMPDBC1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-2
GROUP: DBC1 ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SC11 TO: NOT SPECIFIED
SUBSYSTEM: SC11 ACTUAL FROM: 08/24/16 07:02:00.00
DB2 VERSION: V12
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 07:02:00.00 PLANNAME: KO2PLAN WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 06:49:59.14 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : N/P PROD VER: N/P LUW LUN: IPUAPC11 CICS INS: N/A
REQUESTER : OMPDBC1 CORRNAME: 'BLANK' LUW INS: D13DC1A0FC96
MAINPACK : KO2PLAN CORRNMBR: 'BLANK' LUW SEQ: 7 ENDUSER : DB2PM
PRIMAUTH : DB2PM CONNTYPE: RRS TRANSACT: 'BLANK'
ORIGAUTH : DB2PM CONNECT : RRSAF WSNAME : RRSAF
TIMES/EVENTS APPL(CL.1) DB2 (CL.2) CLASS 3 SUSPENSIONS ELAPSED TIME EVENTS TIME/EVENT HIGHLIGHTS
------------ ---------- ---------- -------------------- ------------ -------- ---------- --------------------------
ELAPSED TIME 0.058896 0.058363 LOCK/LATCH(DB2+IRLM) 0.000000 0 N/C THREAD TYPE : ALLIED
NONNESTED 0.058896 0.058363 IRLM LOCK+LATCH 0.000000 0 N/C TERM.CONDITION: NORMAL
STORED PROC 0.000000 0.000000 DB2 LATCH 0.000000 0 N/C INVOKE REASON : STALENESS
UDF 0.000000 0.000000 SYNCHRON. I/O 0.000957 3 0.000319 PARALLELISM : N/A
TRIGGER 0.000000 0.000000 DATABASE I/O 0.000239 1 0.000239 PCA RUP COUNT : 0
LOG WRITE I/O 0.000718 2 0.000359 RUP AUTONOM.PR: 0
CP CPU TIME 0.006817 0.006288 OTHER READ I/O 0.000000 0 N/C AUTONOMOUS PR : 0
AGENT 0.006817 0.006288 OTHER WRTE I/O 0.000000 0 N/C QUANTITY : 6
NONNESTED 0.006817 0.006288 SER.TASK SWTCH 0.014162 9 0.001574 COMMITS : 24
STORED PRC 0.000000 0.000000 UPDATE COMMIT 0.002054 4 0.000513 ROLLBACK : 0
UDF 0.000000 0.000000 OPEN/CLOSE 0.000000 0 N/C SVPT REQUESTS : 0
TRIGGER 0.000000 0.000000 SYSLGRNG REC 0.001873 1 0.001873 SVPT RELEASE : 0
PAR.TASKS 0.000000 0.000000 EXT/DEL/DEF 0.000000 0 N/C SVPT ROLLBACK : 0
OTHER SERVICE 0.010236 4 0.002559 INCREM.BINDS : 0
SE CPU TIME 0.000000 0.000000 ARC.LOG(QUIES) 0.000000 0 N/C UPDATE/COMMIT : 0.17
NONNESTED 0.000000 0.000000 LOG READ 0.000000 0 N/C SYNCH I/O AVG.: 0.000319
STORED PROC 0.000000 0.000000 DRAIN LOCK 0.000000 0 N/C PROGRAMS : 1
UDF 0.000000 0.000000 CLAIM RELEASE 0.000000 0 N/C MAX CASCADE : 0
TRIGGER 0.000000 0.000000 PAGE LATCH 0.000000 0 N/C MAX WFILE BLKS: 0
NOTIFY MSGS 0.000000 0 N/C
PAR.TASKS 0.000000 0.000000 GLOBAL CONTENTION 0.034432 6 0.005739
COMMIT PH1 WRITE I/O 0.000000 0 N/C
SUSPEND TIME 0.000000 0.049551 ASYNCH CF REQUESTS 0.000000 0 N/C
AGENT N/A 0.049551 TCP/IP LOB XML 0.000000 0 N/C
PAR.TASKS N/A 0.000000 ACCELERATOR 0.000000 0 N/C
STORED PROC 0.000000 N/A AUTONOMOUS PROCEDURE 0.000000 0 N/C
UDF 0.000000 N/A PQ SYNCHRONIZATION 0.000000 0 N/C
LOB COMPRESSION 0.000000 0 N/C
NOT ACCOUNT. N/A 0.002524 FAST INSERT PIPE 0.000000 0 N/C
DB2 ENT/EXIT N/A 252 TOTAL CLASS 3 0.049551 18 0.002753
EN/EX-STPROC N/A 0
EN/EX-UDF N/A 0
DCAPT.DESCR. N/A N/A
LOG EXTRACT. N/A N/A
LOCATION: OMPDBC1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-3
GROUP: DBC1 ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SC11 TO: NOT SPECIFIED
SUBSYSTEM: SC11 ACTUAL FROM: 08/24/16 07:02:00.00
DB2 VERSION: V12
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 07:02:00.00 PLANNAME: KO2PLAN WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 06:49:59.14 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : N/P PROD VER: N/P LUW LUN: IPUAPC11 CICS INS: N/A
REQUESTER : OMPDBC1 CORRNAME: 'BLANK' LUW INS: D13DC1A0FC96
MAINPACK : KO2PLAN CORRNMBR: 'BLANK' LUW SEQ: 7 ENDUSER : DB2PM
PRIMAUTH : DB2PM CONNTYPE: RRS TRANSACT: 'BLANK'
ORIGAUTH : DB2PM CONNECT : RRSAF WSNAME : RRSAF
SQL DML TOTAL SQL DCL TOTAL SQL DDL CREATE DROP ALTER DYNAMIC SQL STMT TOTAL
-------- -------- ---------- -------- ---------- ------ ------ ------ -------------------- --------
SELECT 0 LOCK TABLE 0 TABLE 0 0 0 REOPTIMIZATION 0
INSERT 0 GRANT 0 CRT TTABLE 0 N/A N/A NOT FOUND IN CACHE 0
ROWS 0 REVOKE 0 DCL TTABLE 0 N/A N/A FOUND IN CACHE 24
UPDATE 4 SET SQLID 0 AUX TABLE 0 N/A N/A IMPLICIT PREPARES 0
ROWS 4 SET H.VAR. 0 INDEX 0 0 0 PREPARES AVOIDED 0
MERGE 0 SET DEGREE 0 TABLESPACE 0 0 0 CACHE_LIMIT_EXCEEDED 0
DELETE 0 SET RULES 0 DATABASE 0 0 0 PREP_STMT_PURGED 0
ROWS 0 SET PATH 0 STOGROUP 0 0 0 STABILIZED PREPARE 0
SET PREC. 0 SYNONYM 0 0 N/A CSWL - STMTS PARSED 0
DESCRIBE 0 CONNECT 1 0 VIEW 0 0 0 CSWL - LITS REPLACED 0
DESC.TBL 0 CONNECT 2 0 ALIAS 0 0 N/A CSWL - MATCHES FOUND 0
PREPARE 24 SET CONNEC 0 PACKAGE N/A 0 N/A CSWL - DUPLS CREATED 0
OPEN 20 RELEASE 0 PROCEDURE 0 0 0
FETCH 20 CALL 0 FUNCTION 0 0 0
ROWS 20 ASSOC LOC. 0 TRIGGER 0 0 N/A
CLOSE 20 ALLOC CUR. 0 DIST TYPE 0 0 N/A
HOLD LOC. 0 SEQUENCE 0 0 0
DML-ALL 88 FREE LOC. 0 TRUST. CTX 0 0 0
DCL-ALL 0 ROLE 0 0 N/A
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
LOCATION: OMPDBC1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-4
GROUP: DBC1 ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SC11 TO: NOT SPECIFIED
SUBSYSTEM: SC11 ACTUAL FROM: 08/24/16 07:02:00.00
DB2 VERSION: V12
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 07:02:00.00 PLANNAME: KO2PLAN WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 06:49:59.14 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : N/P PROD VER: N/P LUW LUN: IPUAPC11 CICS INS: N/A
REQUESTER : OMPDBC1 CORRNAME: 'BLANK' LUW INS: D13DC1A0FC96
MAINPACK : KO2PLAN CORRNMBR: 'BLANK' LUW SEQ: 7 ENDUSER : DB2PM
PRIMAUTH : DB2PM CONNTYPE: RRS TRANSACT: 'BLANK'
ORIGAUTH : DB2PM CONNECT : RRSAF WSNAME : RRSAF
MEASURED/ELIG TIMES APPL (CL1) DB2 (CL2) RID LIST TOTAL DATA CAPTURE TOTAL ROWID TOTAL
------------------- ---------- ---------- ---------------------- -------- ------------ -------- ---------- --------
ELAPSED TIME 0.058896 0.058363 USED 0 IFI CALLS 0 DIR ACCESS 0
ELIGIBLE FOR ACCEL N/A 0.000000 REC.CAPTURED 0 INDEX USED 0
FAIL-NO STORAGE 0 LOG REC.READ 0 TS SCAN 0
CP CPU TIME 0.006817 0.006288 FAIL-LIMIT EXC. 0 ROWS RETURN 0
ELIGIBLE FOR SECP 0.000000 N/A RECORDS RET. 0
ELIGIBLE FOR ACCEL N/A 0.000000 INTERRUPTED-NO STORAGE 0 DATA DES.RET 0
INTERRUPTED-LIMIT EXC. 0 TABLES RET. 0
SE CPU TIME 0.000000 0.000000 DESCRIBES 0
ELIGIBLE FOR ACCEL N/A 0.000000 OVERFLOWED-NO STORAGE 0
OVERFLOWED-LIMIT EXC. 0
SKIPPED-INDEX KNOWN 0
GLOBAL CONTENTION L-LOCKS ELAPSED TIME EVENTS GLOBAL CONTENTION P-LOCKS ELAPSED TIME EVENTS
------------------------------------- ------------ -------- ------------------------------------- ------------ --------
L-LOCKS 0.000000 0 P-LOCKS 0.034432 6
PARENT (DB,TS,TAB,PART) 0.000000 0 PAGESET/PARTITION 0.017702 2
CHILD (PAGE,ROW) 0.000000 0 PAGE 0.006694 2
OTHER 0.000000 0 OTHER 0.010035 2
LOCKING TOTAL DATA SHARING TOTAL QUERY PARALLELISM TOTAL DRAIN/CLAIM TOTAL
------------------- -------- ------------ -------- ------------------------- -------- ------------ --------
TIMEOUTS 0 GLOB CONT(%) 5.68 MAXIMUM DEGREE-ESTIMATED 0 DRAIN REQST 0
DEADLOCKS 0 FALS CONT(%) 0.00 MAXIMUM DEGREE-PLANNED 0 DRAIN FAILED 0
ESCAL.(SHAR) 0 P/L-LOCKS(%) 70 MAXIMUM DEGREE-EXECUTED 0 CLAIM REQST 28
ESCAL.(EXCL) 0 P-LOCK REQ 21 MAXIMUM MEMBERS USED N/P CLAIM FAILED 0
MAX PG/ROW LCK HELD 1 P-UNLOCK REQ 18 PARALLEL GROUPS EXECUTED 0
LOCK REQUEST 59 P-CHANGE REQ 1 RAN AS PLANNED 0
UNLOCK REQST 27 LOCK - XES 56 RAN REDUCED-STORAGE 0
QUERY REQST 0 UNLOCK-XES 21 RAN REDUCED-NEGOTIATION 0
CHANGE REQST 4 CHANGE-XES 5 SEQ-CURSOR 0
OTHER REQST 0 SUSP - IRLM 4 SEQ-NO ESA SORT 0
TOTAL SUSPENSIONS 0 SUSP - XES 1 SEQ-NO BUFFER 0
LOCK SUSPENS 0 CONV - XES 1 SEQ-AUTONOMOUS PROC 0
IRLM LATCH SUSPENS 0 FALSE CONT 0 SEQ-NEGOTIATION 0
OTHER SUSPENS 0 INCOMP.LOCK 0 ONE DB2-COORDINATOR = NO 0
NOTIFY SENT 0 ONE DB2-ISOLATION LEVEL 0
ONE DB2-DCL TTABLE 0
MEMB SKIPPED(%) 0
DISABLED BY RLF NO
REFORM PARAL-CONFIG 0
REFORM PARAL-NO BUF 0
LOCATION: OMPDBC1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-5
GROUP: DBC1 ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SC11 TO: NOT SPECIFIED
SUBSYSTEM: SC11 ACTUAL FROM: 08/24/16 07:02:00.00
DB2 VERSION: V12
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 07:02:00.00 PLANNAME: KO2PLAN WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 06:49:59.14 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : N/P PROD VER: N/P LUW LUN: IPUAPC11 CICS INS: N/A
REQUESTER : OMPDBC1 CORRNAME: 'BLANK' LUW INS: D13DC1A0FC96
MAINPACK : KO2PLAN CORRNMBR: 'BLANK' LUW SEQ: 7 ENDUSER : DB2PM
PRIMAUTH : DB2PM CONNTYPE: RRS TRANSACT: 'BLANK'
ORIGAUTH : DB2PM CONNECT : RRSAF WSNAME : RRSAF
STORED PROC. TOTAL UDF TOTAL TRIGGERS TOTAL LOGGING TOTAL
------------ -------- --------- -------- ------------ -------- ----------------- --------
CALL STMTS 0 EXECUTED 0 STMT TRIGGER 0 LOG RECS WRITTEN 26
ABENDED 0 ABENDED 0 ROW TRIGGER 0 TOT BYTES WRITTEN 3530
TIMED OUT 0 TIMED OUT 0 SQL ERROR 0
REJECTED 0 REJECTED 0
TOTAL SU CLASS 1 CLASS 2 MISCELLANEOUS TOTAL
------------ -------------- -------------- -------------------- --------
CP CPU 441 407 MAX STO LOB VAL (KB) 0
AGENT 441 407 MAX STO XML VAL (KB) 0
NONNESTED 441 407 ARRAY EXPANSIONS 0
STORED PRC 0 0 SPARSE IX DISABLED 0
UDF 0 0 SPARSE IX BUILT WF 0
TRIGGER 0 0
PAR.TASKS 0 0
ELIG SECP 0 N/A
ELIG ACCEL N/A 0
SE CPU 0 0
NONNESTED 0 0
STORED PROC 0 0
UDF 0 0
TRIGGER 0 0
PAR.TASKS 0 0
ELIG ACCEL N/A 0
---- RESOURCE LIMIT FACILITY --------------------------------------------------------------------------------------------------
TYPE: N/P TABLE ID: N/P SERV.UNITS: N/P CPU SECONDS: N/P MAX CPU SEC: N/P
BP0 BPOOL ACTIVITY TOTAL BP32K BPOOL ACTIVITY TOTAL TOTAL BPOOL ACTIVITY TOTAL
--------------------- -------- --------------------- -------- --------------------- --------
BPOOL HIT RATIO (%) 97 BPOOL HIT RATIO (%) 100 BPOOL HIT RATIO (%) 98
GETPAGES 32 GETPAGES 16 GETPAGES 48
BUFFER UPDATES 4 BUFFER UPDATES 0 BUFFER UPDATES 4
SYNCHRONOUS WRITE 0 SYNCHRONOUS WRITE 0 SYNCHRONOUS WRITE 0
SYNCHRONOUS READ 1 SYNCHRONOUS READ 0 SYNCHRONOUS READ 1
SEQ. PREFETCH REQS 0 SEQ. PREFETCH REQS 0 SEQ. PREFETCH REQS 0
LIST PREFETCH REQS 0 LIST PREFETCH REQS 0 LIST PREFETCH REQS 0
DYN. PREFETCH REQS 0 DYN. PREFETCH REQS 0 DYN. PREFETCH REQS 0
PAGES READ ASYNCHR. 0 PAGES READ ASYNCHR. 0 PAGES READ ASYNCHR. 0
LOCATION: OMPDBC1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-6
GROUP: DBC1 ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SC11 TO: NOT SPECIFIED
SUBSYSTEM: SC11 ACTUAL FROM: 08/24/16 07:02:00.00
DB2 VERSION: V12
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 07:02:00.00 PLANNAME: KO2PLAN WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 06:49:59.14 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : N/P PROD VER: N/P LUW LUN: IPUAPC11 CICS INS: N/A
REQUESTER : OMPDBC1 CORRNAME: 'BLANK' LUW INS: D13DC1A0FC96
MAINPACK : KO2PLAN CORRNMBR: 'BLANK' LUW SEQ: 7 ENDUSER : DB2PM
PRIMAUTH : DB2PM CONNTYPE: RRS TRANSACT: 'BLANK'
ORIGAUTH : DB2PM CONNECT : RRSAF WSNAME : RRSAF
GROUP BP0 TOTAL GROUP BP32K TOTAL GROUP TOTAL TOTAL
--------------------- -------- --------------------- -------- --------------------- --------
GBP-DEPEND GETPAGES 32 GBP-DEPEND GETPAGES 16 GBP-DEPEND GETPAGES 48
READ(XI)-DATA RETUR 1 READ(XI)-DATA RETUR 0 READ(XI)-DATA RETUR 1
READ(XI)-NO DATA RT 1 READ(XI)-NO DATA RT 0 READ(XI)-NO DATA RT 1
READ(NF)-DATA RETUR 0 READ(NF)-DATA RETUR 0 READ(NF)-DATA RETUR 0
READ(NF)-NO DATA RT 0 READ(NF)-NO DATA RT 0 READ(NF)-NO DATA RT 0
PREFETCH PAGES READ 0 PREFETCH PAGES READ 0 PREFETCH PAGES READ 0
CLEAN PAGES WRITTEN 0 CLEAN PAGES WRITTEN 0 CLEAN PAGES WRITTEN 0
UNREGISTER PAGE 0 UNREGISTER PAGE 0 UNREGISTER PAGE 0
ASYNCH GBP REQUESTS 0 ASYNCH GBP REQUESTS 0 ASYNCH GBP REQUESTS 0
EXPLICIT X-INVALID 0 EXPLICIT X-INVALID 0 EXPLICIT X-INVALID 0
ASYNCH SEC-GBP REQ 0 ASYNCH SEC-GBP REQ 0 ASYNCH SEC-GBP REQ 0
PG P-LOCK LOCK REQ 16 PG P-LOCK LOCK REQ 2 PG P-LOCK LOCK REQ 18
SPACE MAP PAGES 16 SPACE MAP PAGES 2 SPACE MAP PAGES 18
DATA PAGES 0 DATA PAGES 0 DATA PAGES 0
INDEX LEAF PAGES 0 INDEX LEAF PAGES 0 INDEX LEAF PAGES 0
PG P-LOCK UNLOCK REQ 16 PG P-LOCK UNLOCK REQ 2 PG P-LOCK UNLOCK REQ 18
PG P-LOCK LOCK SUSP 2 PG P-LOCK LOCK SUSP 0 PG P-LOCK LOCK SUSP 2
SPACE MAP PAGES 2 SPACE MAP PAGES 0 SPACE MAP PAGES 2
DATA PAGES 0 DATA PAGES 0 DATA PAGES 0
INDEX LEAF PAGES 0 INDEX LEAF PAGES 0 INDEX LEAF PAGES 0
WRITE AND REGISTER 4 WRITE AND REGISTER 0 WRITE AND REGISTER 4
WRITE & REGISTER MULT 0 WRITE & REGISTER MULT 0 WRITE & REGISTER MULT 0
CHANGED PAGES WRITTEN 4 CHANGED PAGES WRITTEN 0 CHANGED PAGES WRITTEN 4
COMPL CHECKS SUSPEND 0 COMPL CHECKS SUSPEND 0 COMPL CHECKS SUSPEND 0
LOCATION: OMPDBC1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-7
GROUP: DBC1 ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SC11 TO: NOT SPECIFIED
SUBSYSTEM: SC11 ACTUAL FROM: 08/24/16 07:02:00.00
DB2 VERSION: V12
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 07:02:00.00 PLANNAME: KO2PLAN WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 06:49:59.14 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : N/P PROD VER: N/P LUW LUN: IPUAPC11 CICS INS: N/A
REQUESTER : OMPDBC1 CORRNAME: 'BLANK' LUW INS: D13DC1A0FC96
MAINPACK : KO2PLAN CORRNMBR: 'BLANK' LUW SEQ: 7 ENDUSER : DB2PM
PRIMAUTH : DB2PM CONNTYPE: RRS TRANSACT: 'BLANK'
ORIGAUTH : DB2PM CONNECT : RRSAF WSNAME : RRSAF
FPEVWRP2 VALUE FPEVWRP2 TIMES FPEVWRP2 TIME EVENTS TIME/EVENT
------------------ ------------------ ------------------ ------------ ------------------ ------------ ------ ------------
TYPE PACKAGE ELAPSED TIME - CL7 0.047027 LOCK/LATCH 0.000000 0 N/C
LOCATION OMPDBC1 CP CPU TIME 0.005399 IRLM LOCK+LATCH 0.000000 0 N/C
COLLECTION ID KO2OM530 AGENT 0.005399 DB2 LATCH 0.000000 0 N/C
PROGRAM NAME FPEVWRP2 PAR.TASKS 0.000000 SYNCHRONOUS I/O 0.000957 3 0.000319
CONSISTENCY TOKEN 1A20F0C107FBA51D SE CPU TIME 0.000000 OTHER READ I/O 0.000000 0 N/C
ACTIVITY TYPE NONNESTED SUSPENSION-CL8 0.039315 OTHER WRITE I/O 0.000000 0 N/C
ACTIVITY NAME 'BLANK' AGENT 0.039315 SERV.TASK SWITCH 0.003927 5 0.000785
SCHEMA NAME 'BLANK' PAR.TASKS 0.000000 ARCH.LOG(QUIESCE) 0.000000 0 N/C
SUCC AUTH CHECK N/P NOT ACCOUNTED 0.002313 ARCHIVE LOG READ 0.000000 0 N/C
NBR OF ALLOCATIONS 4 DRAIN LOCK 0.000000 0 N/C
SQL STMT - AVERAGE 22.00 CP CPU SU 350 CLAIM RELEASE 0.000000 0 N/C
SQL STMT - TOTAL 88 AGENT 350 PAGE LATCH 0.000000 0 N/C
NBR RLUP THREADS 4 PAR.TASKS 0 NOTIFY MESSAGES 0.000000 0 N/C
SE CPU SU 0 GLOBAL CONTENTION 0.034432 6 0.005739
TCP/IP LOB XML 0.000000 0 N/C
DB2 ENTRY/EXIT 232 ACCELERATOR 0.000000 0 N/C
PQ SYNCHRONIZATION 0.000000 0 N/C
FAST INSERT PIPE 0.000000 0 N/C
TOTAL CL8 SUSPENS. 0.039315 14 0.002808
FPEVWRP2 ELAPSED TIME EVENTS FPEVWRP2 ELAPSED TIME EVENTS
------------------------- ------------ -------- ------------------------- ------------ --------
GLOBAL CONTENTION L-LOCKS 0.000000 0 GLOBAL CONTENTION P-LOCKS 0.034432 6
PARENT (DB,TS,TAB,PART) 0.000000 0 PAGESET/PARTITION 0.017702 2
CHILD (PAGE,ROW) 0.000000 0 PAGE 0.006694 2
OTHER 0.000000 0 OTHER 0.010035 2
FPEVWRP2 TOTAL
------------------ --------
SELECT 0
INSERT 0
UPDATE 4
DELETE 0
DESCRIBE 0
PREPARE 24
OPEN 20
FETCH 20
CLOSE 20
LOCK TABLE 0
CALL 0
LOCATION: OMPDBC1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-8
GROUP: DBC1 ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SC11 TO: NOT SPECIFIED
SUBSYSTEM: SC11 ACTUAL FROM: 08/24/16 07:02:00.00
DB2 VERSION: V12
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 07:02:00.00 PLANNAME: KO2PLAN WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 06:49:59.14 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : N/P PROD VER: N/P LUW LUN: IPUAPC11 CICS INS: N/A
REQUESTER : OMPDBC1 CORRNAME: 'BLANK' LUW INS: D13DC1A0FC96
MAINPACK : KO2PLAN CORRNMBR: 'BLANK' LUW SEQ: 7 ENDUSER : DB2PM
PRIMAUTH : DB2PM CONNTYPE: RRS TRANSACT: 'BLANK'
ORIGAUTH : DB2PM CONNECT : RRSAF WSNAME : RRSAF
FPEVWRP2 TOTAL
------------------- --------
BPOOL HIT RATIO (%) 97
GETPAGES 48
BUFFER UPDATES 4
SYNCHRONOUS WRITE 0
SYNCHRONOUS READ 1
SEQ. PREFETCH REQS 0
LIST PREFETCH REQS 0
DYN. PREFETCH REQS 0
PAGES READ ASYNCHR. 0
FPEVWRP2 TOTAL
--------------------- --------
TIMEOUTS 0
DEADLOCKS 0
ESCAL.(SHARED) 0
ESCAL.(EXCLUS) 0
MAX PG/ROW LOCKS HELD 1
LOCK REQUEST 55
UNLOCK REQUEST 27
QUERY REQUEST 0
CHANGE REQUEST 4
OTHER REQUEST 0
TOTAL SUSPENSIONS 0
LOCK SUSPENS 0
IRLM LATCH SUSPENS 0
OTHER SUSPENS 0
TIMES CLASS 5 IFI (CL.5)
------------- ----------
ELAPSED TIME 0.000000
CP CPU TIME 0.000000
DCAPT.DESCR. 0.000000
LOG EXTRACT. 0.000000
LOCATION: OMPDBC1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-9
GROUP: DBC1 ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SC11 TO: NOT SPECIFIED
SUBSYSTEM: SC11 ACTUAL FROM: 08/24/16 07:02:00.00
DB2 VERSION: V12
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 07:16:00.00 PLANNAME: KO2PLAN WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 07:02:20.03 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : N/P PROD VER: N/P LUW LUN: IPUAPC11 CICS INS: N/A
REQUESTER : OMPDBC1 CORRNAME: 'BLANK' LUW INS: D13DC513780A
MAINPACK : KO2PLAN CORRNMBR: 'BLANK' LUW SEQ: 7 ENDUSER : DB2PM
PRIMAUTH : DB2PM CONNTYPE: RRS TRANSACT: 'BLANK'
ORIGAUTH : DB2PM CONNECT : RRSAF WSNAME : RRSAF
MVS ACCOUNTING DATA : 'BLANK'
ACCOUNTING TOKEN(CHAR): 'BLANK'
ACCOUNTING TOKEN(HEX) : 00000000000000000000000000000000000000000000
ELAPSED TIME DISTRIBUTION CLASS 2 TIME DISTRIBUTION
---------------------------------------------------------------- ----------------------------------------------------------------
APPL !=> 2% CPU !=============> 26%
DB2 !=================> 35% SECPU !
SUSP !===============================> 62% NOTACC !=====> 10%
SUSP !================================> 64%
LOCATION: OMPDBC1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-10
GROUP: DBC1 ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SC11 TO: NOT SPECIFIED
SUBSYSTEM: SC11 ACTUAL FROM: 08/24/16 07:02:00.00
DB2 VERSION: V12
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 07:16:00.00 PLANNAME: KO2PLAN WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 07:02:20.03 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : N/P PROD VER: N/P LUW LUN: IPUAPC11 CICS INS: N/A
REQUESTER : OMPDBC1 CORRNAME: 'BLANK' LUW INS: D13DC513780A
MAINPACK : KO2PLAN CORRNMBR: 'BLANK' LUW SEQ: 7 ENDUSER : DB2PM
PRIMAUTH : DB2PM CONNTYPE: RRS TRANSACT: 'BLANK'
ORIGAUTH : DB2PM CONNECT : RRSAF WSNAME : RRSAF
TIMES/EVENTS APPL(CL.1) DB2 (CL.2) CLASS 3 SUSPENSIONS ELAPSED TIME EVENTS TIME/EVENT HIGHLIGHTS
------------ ---------- ---------- -------------------- ------------ -------- ---------- --------------------------
ELAPSED TIME 0.030244 0.029507 LOCK/LATCH(DB2+IRLM) 0.000000 0 N/C THREAD TYPE : ALLIED
NONNESTED 0.030244 0.029507 IRLM LOCK+LATCH 0.000000 0 N/C TERM.CONDITION: NORMAL
STORED PROC 0.000000 0.000000 DB2 LATCH 0.000000 0 N/C INVOKE REASON : STALENESS
UDF 0.000000 0.000000 SYNCHRON. I/O 0.000750 2 0.000375 PARALLELISM : N/A
TRIGGER 0.000000 0.000000 DATABASE I/O 0.000000 0 N/C PCA RUP COUNT : 0
LOG WRITE I/O 0.000750 2 0.000375 RUP AUTONOM.PR: 0
CP CPU TIME 0.008521 0.007807 OTHER READ I/O 0.000000 0 N/C AUTONOMOUS PR : 0
AGENT 0.008521 0.007807 OTHER WRTE I/O 0.000000 0 N/C QUANTITY : 8
NONNESTED 0.008521 0.007807 SER.TASK SWTCH 0.018026 9 0.002003 COMMITS : 30
STORED PRC 0.000000 0.000000 UPDATE COMMIT 0.001967 3 0.000656 ROLLBACK : 0
UDF 0.000000 0.000000 OPEN/CLOSE 0.000000 0 N/C SVPT REQUESTS : 0
TRIGGER 0.000000 0.000000 SYSLGRNG REC 0.000000 0 N/C SVPT RELEASE : 0
PAR.TASKS 0.000000 0.000000 EXT/DEL/DEF 0.000000 0 N/C SVPT ROLLBACK : 0
OTHER SERVICE 0.016059 6 0.002676 INCREM.BINDS : 0
SE CPU TIME 0.000000 0.000000 ARC.LOG(QUIES) 0.000000 0 N/C UPDATE/COMMIT : 0.17
NONNESTED 0.000000 0.000000 LOG READ 0.000000 0 N/C SYNCH I/O AVG.: 0.000375
STORED PROC 0.000000 0.000000 DRAIN LOCK 0.000000 0 N/C PROGRAMS : 1
UDF 0.000000 0.000000 CLAIM RELEASE 0.000000 0 N/C MAX CASCADE : 0
TRIGGER 0.000000 0.000000 PAGE LATCH 0.000000 0 N/C MAX WFILE BLKS: 0
NOTIFY MSGS 0.000000 0 N/C
PAR.TASKS 0.000000 0.000000 GLOBAL CONTENTION 0.000000 0 N/C
COMMIT PH1 WRITE I/O 0.000000 0 N/C
SUSPEND TIME 0.000000 0.018776 ASYNCH CF REQUESTS 0.000000 0 N/C
AGENT N/A 0.018776 TCP/IP LOB XML 0.000000 0 N/C
PAR.TASKS N/A 0.000000 ACCELERATOR 0.000000 0 N/C
STORED PROC 0.000000 N/A AUTONOMOUS PROCEDURE 0.000000 0 N/C
UDF 0.000000 N/A PQ SYNCHRONIZATION 0.000000 0 N/C
LOB COMPRESSION 0.000000 0 N/C
NOT ACCOUNT. N/A 0.002924 FAST INSERT PIPE 0.000000 0 N/C
DB2 ENT/EXIT N/A 318 TOTAL CLASS 3 0.018776 11 0.001707
EN/EX-STPROC N/A 0
EN/EX-UDF N/A 0
DCAPT.DESCR. N/A N/A
LOG EXTRACT. N/A N/A
LOCATION: OMPDBC1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-11
GROUP: DBC1 ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SC11 TO: NOT SPECIFIED
SUBSYSTEM: SC11 ACTUAL FROM: 08/24/16 07:02:00.00
DB2 VERSION: V12
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 07:16:00.00 PLANNAME: KO2PLAN WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 07:02:20.03 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : N/P PROD VER: N/P LUW LUN: IPUAPC11 CICS INS: N/A
REQUESTER : OMPDBC1 CORRNAME: 'BLANK' LUW INS: D13DC513780A
MAINPACK : KO2PLAN CORRNMBR: 'BLANK' LUW SEQ: 7 ENDUSER : DB2PM
PRIMAUTH : DB2PM CONNTYPE: RRS TRANSACT: 'BLANK'
ORIGAUTH : DB2PM CONNECT : RRSAF WSNAME : RRSAF
SQL DML TOTAL SQL DCL TOTAL SQL DDL CREATE DROP ALTER DYNAMIC SQL STMT TOTAL
-------- -------- ---------- -------- ---------- ------ ------ ------ -------------------- --------
SELECT 0 LOCK TABLE 0 TABLE 0 0 0 REOPTIMIZATION 0
INSERT 0 GRANT 0 CRT TTABLE 0 N/A N/A NOT FOUND IN CACHE 0
ROWS 0 REVOKE 0 DCL TTABLE 0 N/A N/A FOUND IN CACHE 30
UPDATE 5 SET SQLID 0 AUX TABLE 0 N/A N/A IMPLICIT PREPARES 0
ROWS 5 SET H.VAR. 0 INDEX 0 0 0 PREPARES AVOIDED 0
MERGE 0 SET DEGREE 0 TABLESPACE 0 0 0 CACHE_LIMIT_EXCEEDED 0
DELETE 0 SET RULES 0 DATABASE 0 0 0 PREP_STMT_PURGED 0
ROWS 0 SET PATH 0 STOGROUP 0 0 0 STABILIZED PREPARE 0
SET PREC. 0 SYNONYM 0 0 N/A CSWL - STMTS PARSED 0
DESCRIBE 0 CONNECT 1 0 VIEW 0 0 0 CSWL - LITS REPLACED 0
DESC.TBL 0 CONNECT 2 0 ALIAS 0 0 N/A CSWL - MATCHES FOUND 0
PREPARE 30 SET CONNEC 0 PACKAGE N/A 0 N/A CSWL - DUPLS CREATED 0
OPEN 25 RELEASE 0 PROCEDURE 0 0 0
FETCH 25 CALL 0 FUNCTION 0 0 0
ROWS 25 ASSOC LOC. 0 TRIGGER 0 0 N/A
CLOSE 25 ALLOC CUR. 0 DIST TYPE 0 0 N/A
HOLD LOC. 0 SEQUENCE 0 0 0
DML-ALL 110 FREE LOC. 0 TRUST. CTX 0 0 0
DCL-ALL 0 ROLE 0 0 N/A
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
LOCATION: OMPDBC1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-12
GROUP: DBC1 ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SC11 TO: NOT SPECIFIED
SUBSYSTEM: SC11 ACTUAL FROM: 08/24/16 07:02:00.00
DB2 VERSION: V12
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 07:16:00.00 PLANNAME: KO2PLAN WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 07:02:20.03 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : N/P PROD VER: N/P LUW LUN: IPUAPC11 CICS INS: N/A
REQUESTER : OMPDBC1 CORRNAME: 'BLANK' LUW INS: D13DC513780A
MAINPACK : KO2PLAN CORRNMBR: 'BLANK' LUW SEQ: 7 ENDUSER : DB2PM
PRIMAUTH : DB2PM CONNTYPE: RRS TRANSACT: 'BLANK'
ORIGAUTH : DB2PM CONNECT : RRSAF WSNAME : RRSAF
MEASURED/ELIG TIMES APPL (CL1) DB2 (CL2) RID LIST TOTAL DATA CAPTURE TOTAL ROWID TOTAL
------------------- ---------- ---------- ---------------------- -------- ------------ -------- ---------- --------
ELAPSED TIME 0.030244 0.029507 USED 0 IFI CALLS 0 DIR ACCESS 0
ELIGIBLE FOR ACCEL N/A 0.000000 REC.CAPTURED 0 INDEX USED 0
FAIL-NO STORAGE 0 LOG REC.READ 0 TS SCAN 0
CP CPU TIME 0.008521 0.007807 FAIL-LIMIT EXC. 0 ROWS RETURN 0
ELIGIBLE FOR SECP 0.000000 N/A RECORDS RET. 0
ELIGIBLE FOR ACCEL N/A 0.000000 INTERRUPTED-NO STORAGE 0 DATA DES.RET 0
INTERRUPTED-LIMIT EXC. 0 TABLES RET. 0
SE CPU TIME 0.000000 0.000000 DESCRIBES 0
ELIGIBLE FOR ACCEL N/A 0.000000 OVERFLOWED-NO STORAGE 0
OVERFLOWED-LIMIT EXC. 0
SKIPPED-INDEX KNOWN 0
GLOBAL CONTENTION L-LOCKS ELAPSED TIME EVENTS GLOBAL CONTENTION P-LOCKS ELAPSED TIME EVENTS
------------------------------------- ------------ -------- ------------------------------------- ------------ --------
L-LOCKS 0.000000 0 P-LOCKS 0.000000 0
PARENT (DB,TS,TAB,PART) 0.000000 0 PAGESET/PARTITION 0.000000 0
CHILD (PAGE,ROW) 0.000000 0 PAGE 0.000000 0
OTHER 0.000000 0 OTHER 0.000000 0
LOCKING TOTAL DATA SHARING TOTAL QUERY PARALLELISM TOTAL DRAIN/CLAIM TOTAL
------------------- -------- ------------ -------- ------------------------- -------- ------------ --------
TIMEOUTS 0 GLOB CONT(%) 0.00 MAXIMUM DEGREE-ESTIMATED 0 DRAIN REQST 0
DEADLOCKS 0 FALS CONT(%) 0.00 MAXIMUM DEGREE-PLANNED 0 DRAIN FAILED 0
ESCAL.(SHAR) 0 P/L-LOCKS(%) 57 MAXIMUM DEGREE-EXECUTED 0 CLAIM REQST 35
ESCAL.(EXCL) 0 P-LOCK REQ 0 MAXIMUM MEMBERS USED N/P CLAIM FAILED 0
MAX PG/ROW LCK HELD 1 P-UNLOCK REQ 0 PARALLEL GROUPS EXECUTED 0
LOCK REQUEST 70 P-CHANGE REQ 0 RAN AS PLANNED 0
UNLOCK REQST 30 LOCK - XES 40 RAN REDUCED-STORAGE 0
QUERY REQST 0 UNLOCK-XES 0 RAN REDUCED-NEGOTIATION 0
CHANGE REQST 5 CHANGE-XES 5 SEQ-CURSOR 0
OTHER REQST 0 SUSP - IRLM 0 SEQ-NO ESA SORT 0
TOTAL SUSPENSIONS 0 SUSP - XES 0 SEQ-NO BUFFER 0
LOCK SUSPENS 0 CONV - XES 0 SEQ-AUTONOMOUS PROC 0
IRLM LATCH SUSPENS 0 FALSE CONT 0 SEQ-NEGOTIATION 0
OTHER SUSPENS 0 INCOMP.LOCK 0 ONE DB2-COORDINATOR = NO 0
NOTIFY SENT 0 ONE DB2-ISOLATION LEVEL 0
ONE DB2-DCL TTABLE 0
MEMB SKIPPED(%) 0
DISABLED BY RLF NO
REFORM PARAL-CONFIG 0
REFORM PARAL-NO BUF 0
LOCATION: OMPDBC1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-13
GROUP: DBC1 ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SC11 TO: NOT SPECIFIED
SUBSYSTEM: SC11 ACTUAL FROM: 08/24/16 07:02:00.00
DB2 VERSION: V12
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 07:16:00.00 PLANNAME: KO2PLAN WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 07:02:20.03 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : N/P PROD VER: N/P LUW LUN: IPUAPC11 CICS INS: N/A
REQUESTER : OMPDBC1 CORRNAME: 'BLANK' LUW INS: D13DC513780A
MAINPACK : KO2PLAN CORRNMBR: 'BLANK' LUW SEQ: 7 ENDUSER : DB2PM
PRIMAUTH : DB2PM CONNTYPE: RRS TRANSACT: 'BLANK'
ORIGAUTH : DB2PM CONNECT : RRSAF WSNAME : RRSAF
STORED PROC. TOTAL UDF TOTAL TRIGGERS TOTAL LOGGING TOTAL
------------ -------- --------- -------- ------------ -------- ----------------- --------
CALL STMTS 0 EXECUTED 0 STMT TRIGGER 0 LOG RECS WRITTEN 30
ABENDED 0 ABENDED 0 ROW TRIGGER 0 TOT BYTES WRITTEN 3781
TIMED OUT 0 TIMED OUT 0 SQL ERROR 0
REJECTED 0 REJECTED 0
TOTAL SU CLASS 1 CLASS 2 MISCELLANEOUS TOTAL
------------ -------------- -------------- -------------------- --------
CP CPU 551 505 MAX STO LOB VAL (KB) 0
AGENT 551 505 MAX STO XML VAL (KB) 0
NONNESTED 551 505 ARRAY EXPANSIONS 0
STORED PRC 0 0 SPARSE IX DISABLED 0
UDF 0 0 SPARSE IX BUILT WF 0
TRIGGER 0 0
PAR.TASKS 0 0
ELIG SECP 0 N/A
ELIG ACCEL N/A 0
SE CPU 0 0
NONNESTED 0 0
STORED PROC 0 0
UDF 0 0
TRIGGER 0 0
PAR.TASKS 0 0
ELIG ACCEL N/A 0
---- RESOURCE LIMIT FACILITY --------------------------------------------------------------------------------------------------
TYPE: N/P TABLE ID: N/P SERV.UNITS: N/P CPU SECONDS: N/P MAX CPU SEC: N/P
BP0 BPOOL ACTIVITY TOTAL BP32K BPOOL ACTIVITY TOTAL TOTAL BPOOL ACTIVITY TOTAL
--------------------- -------- --------------------- -------- --------------------- --------
BPOOL HIT RATIO (%) 100 BPOOL HIT RATIO (%) 100 BPOOL HIT RATIO (%) 100
GETPAGES 40 GETPAGES 20 GETPAGES 60
BUFFER UPDATES 5 BUFFER UPDATES 0 BUFFER UPDATES 5
SYNCHRONOUS WRITE 0 SYNCHRONOUS WRITE 0 SYNCHRONOUS WRITE 0
SYNCHRONOUS READ 0 SYNCHRONOUS READ 0 SYNCHRONOUS READ 0
SEQ. PREFETCH REQS 0 SEQ. PREFETCH REQS 0 SEQ. PREFETCH REQS 0
LIST PREFETCH REQS 0 LIST PREFETCH REQS 0 LIST PREFETCH REQS 0
DYN. PREFETCH REQS 0 DYN. PREFETCH REQS 0 DYN. PREFETCH REQS 0
PAGES READ ASYNCHR. 0 PAGES READ ASYNCHR. 0 PAGES READ ASYNCHR. 0
LOCATION: OMPDBC1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-14
GROUP: DBC1 ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SC11 TO: NOT SPECIFIED
SUBSYSTEM: SC11 ACTUAL FROM: 08/24/16 07:02:00.00
DB2 VERSION: V12
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 07:16:00.00 PLANNAME: KO2PLAN WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 07:02:20.03 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : N/P PROD VER: N/P LUW LUN: IPUAPC11 CICS INS: N/A
REQUESTER : OMPDBC1 CORRNAME: 'BLANK' LUW INS: D13DC513780A
MAINPACK : KO2PLAN CORRNMBR: 'BLANK' LUW SEQ: 7 ENDUSER : DB2PM
PRIMAUTH : DB2PM CONNTYPE: RRS TRANSACT: 'BLANK'
ORIGAUTH : DB2PM CONNECT : RRSAF WSNAME : RRSAF
GROUP BP0 TOTAL GROUP BP32K TOTAL GROUP TOTAL TOTAL
--------------------- -------- --------------------- -------- --------------------- --------
GBP-DEPEND GETPAGES 40 GBP-DEPEND GETPAGES 20 GBP-DEPEND GETPAGES 60
READ(XI)-DATA RETUR 0 READ(XI)-DATA RETUR 0 READ(XI)-DATA RETUR 0
READ(XI)-NO DATA RT 0 READ(XI)-NO DATA RT 0 READ(XI)-NO DATA RT 0
READ(NF)-DATA RETUR 0 READ(NF)-DATA RETUR 0 READ(NF)-DATA RETUR 0
READ(NF)-NO DATA RT 0 READ(NF)-NO DATA RT 0 READ(NF)-NO DATA RT 0
PREFETCH PAGES READ 0 PREFETCH PAGES READ 0 PREFETCH PAGES READ 0
CLEAN PAGES WRITTEN 0 CLEAN PAGES WRITTEN 0 CLEAN PAGES WRITTEN 0
UNREGISTER PAGE 0 UNREGISTER PAGE 0 UNREGISTER PAGE 0
ASYNCH GBP REQUESTS 0 ASYNCH GBP REQUESTS 0 ASYNCH GBP REQUESTS 0
EXPLICIT X-INVALID 0 EXPLICIT X-INVALID 0 EXPLICIT X-INVALID 0
ASYNCH SEC-GBP REQ 0 ASYNCH SEC-GBP REQ 0 ASYNCH SEC-GBP REQ 0
PG P-LOCK LOCK REQ 0 PG P-LOCK LOCK REQ 0 PG P-LOCK LOCK REQ 0
SPACE MAP PAGES 0 SPACE MAP PAGES 0 SPACE MAP PAGES 0
DATA PAGES 0 DATA PAGES 0 DATA PAGES 0
INDEX LEAF PAGES 0 INDEX LEAF PAGES 0 INDEX LEAF PAGES 0
PG P-LOCK UNLOCK REQ 0 PG P-LOCK UNLOCK REQ 0 PG P-LOCK UNLOCK REQ 0
PG P-LOCK LOCK SUSP 0 PG P-LOCK LOCK SUSP 0 PG P-LOCK LOCK SUSP 0
SPACE MAP PAGES 0 SPACE MAP PAGES 0 SPACE MAP PAGES 0
DATA PAGES 0 DATA PAGES 0 DATA PAGES 0
INDEX LEAF PAGES 0 INDEX LEAF PAGES 0 INDEX LEAF PAGES 0
WRITE AND REGISTER 5 WRITE AND REGISTER 0 WRITE AND REGISTER 5
WRITE & REGISTER MULT 0 WRITE & REGISTER MULT 0 WRITE & REGISTER MULT 0
CHANGED PAGES WRITTEN 5 CHANGED PAGES WRITTEN 0 CHANGED PAGES WRITTEN 5
COMPL CHECKS SUSPEND 0 COMPL CHECKS SUSPEND 0 COMPL CHECKS SUSPEND 0
LOCATION: OMPDBC1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-15
GROUP: DBC1 ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SC11 TO: NOT SPECIFIED
SUBSYSTEM: SC11 ACTUAL FROM: 08/24/16 07:02:00.00
DB2 VERSION: V12
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 07:16:00.00 PLANNAME: KO2PLAN WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 07:02:20.03 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : N/P PROD VER: N/P LUW LUN: IPUAPC11 CICS INS: N/A
REQUESTER : OMPDBC1 CORRNAME: 'BLANK' LUW INS: D13DC513780A
MAINPACK : KO2PLAN CORRNMBR: 'BLANK' LUW SEQ: 7 ENDUSER : DB2PM
PRIMAUTH : DB2PM CONNTYPE: RRS TRANSACT: 'BLANK'
ORIGAUTH : DB2PM CONNECT : RRSAF WSNAME : RRSAF
FPEVWRP2 VALUE FPEVWRP2 TIMES FPEVWRP2 TIME EVENTS TIME/EVENT
------------------ ------------------ ------------------ ------------ ------------------ ------------ ------ ------------
TYPE PACKAGE ELAPSED TIME - CL7 0.011752 LOCK/LATCH 0.000000 0 N/C
LOCATION OMPDBC1 CP CPU TIME 0.006384 IRLM LOCK+LATCH 0.000000 0 N/C
COLLECTION ID KO2OM530 AGENT 0.006384 DB2 LATCH 0.000000 0 N/C
PROGRAM NAME FPEVWRP2 PAR.TASKS 0.000000 SYNCHRONOUS I/O 0.000750 2 0.000375
CONSISTENCY TOKEN 1A20F0C107FBA51D SE CPU TIME 0.000000 OTHER READ I/O 0.000000 0 N/C
ACTIVITY TYPE NONNESTED SUSPENSION-CL8 0.002717 OTHER WRITE I/O 0.000000 0 N/C
ACTIVITY NAME 'BLANK' AGENT 0.002717 SERV.TASK SWITCH 0.001967 3 0.000656
SCHEMA NAME 'BLANK' PAR.TASKS 0.000000 ARCH.LOG(QUIESCE) 0.000000 0 N/C
SUCC AUTH CHECK N/P NOT ACCOUNTED 0.002650 ARCHIVE LOG READ 0.000000 0 N/C
NBR OF ALLOCATIONS 5 DRAIN LOCK 0.000000 0 N/C
SQL STMT - AVERAGE 22.00 CP CPU SU 414 CLAIM RELEASE 0.000000 0 N/C
SQL STMT - TOTAL 110 AGENT 414 PAGE LATCH 0.000000 0 N/C
NBR RLUP THREADS 5 PAR.TASKS 0 NOTIFY MESSAGES 0.000000 0 N/C
SE CPU SU 0 GLOBAL CONTENTION 0.000000 0 N/C
TCP/IP LOB XML 0.000000 0 N/C
DB2 ENTRY/EXIT 290 ACCELERATOR 0.000000 0 N/C
PQ SYNCHRONIZATION 0.000000 0 N/C
FAST INSERT PIPE 0.000000 0 N/C
TOTAL CL8 SUSPENS. 0.002717 5 0.000543
FPEVWRP2 ELAPSED TIME EVENTS FPEVWRP2 ELAPSED TIME EVENTS
------------------------- ------------ -------- ------------------------- ------------ --------
GLOBAL CONTENTION L-LOCKS 0.000000 0 GLOBAL CONTENTION P-LOCKS 0.000000 0
PARENT (DB,TS,TAB,PART) 0.000000 0 PAGESET/PARTITION 0.000000 0
CHILD (PAGE,ROW) 0.000000 0 PAGE 0.000000 0
OTHER 0.000000 0 OTHER 0.000000 0
FPEVWRP2 TOTAL
------------------ --------
SELECT 0
INSERT 0
UPDATE 5
DELETE 0
DESCRIBE 0
PREPARE 30
OPEN 25
FETCH 25
CLOSE 25
LOCK TABLE 0
CALL 0
LOCATION: OMPDBC1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-16
GROUP: DBC1 ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SC11 TO: NOT SPECIFIED
SUBSYSTEM: SC11 ACTUAL FROM: 08/24/16 07:02:00.00
DB2 VERSION: V12
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 07:16:00.00 PLANNAME: KO2PLAN WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 07:02:20.03 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : N/P PROD VER: N/P LUW LUN: IPUAPC11 CICS INS: N/A
REQUESTER : OMPDBC1 CORRNAME: 'BLANK' LUW INS: D13DC513780A
MAINPACK : KO2PLAN CORRNMBR: 'BLANK' LUW SEQ: 7 ENDUSER : DB2PM
PRIMAUTH : DB2PM CONNTYPE: RRS TRANSACT: 'BLANK'
ORIGAUTH : DB2PM CONNECT : RRSAF WSNAME : RRSAF
FPEVWRP2 TOTAL
------------------- --------
BPOOL HIT RATIO (%) 100
GETPAGES 60
BUFFER UPDATES 5
SYNCHRONOUS WRITE 0
SYNCHRONOUS READ 0
SEQ. PREFETCH REQS 0
LIST PREFETCH REQS 0
DYN. PREFETCH REQS 0
PAGES READ ASYNCHR. 0
FPEVWRP2 TOTAL
--------------------- --------
TIMEOUTS 0
DEADLOCKS 0
ESCAL.(SHARED) 0
ESCAL.(EXCLUS) 0
MAX PG/ROW LOCKS HELD 1
LOCK REQUEST 65
UNLOCK REQUEST 30
QUERY REQUEST 0
CHANGE REQUEST 5
OTHER REQUEST 0
TOTAL SUSPENSIONS 0
LOCK SUSPENS 0
IRLM LATCH SUSPENS 0
OTHER SUSPENS 0
TIMES CLASS 5 IFI (CL.5)
------------- ----------
ELAPSED TIME 0.000000
CP CPU TIME 0.000000
DCAPT.DESCR. 0.000000
LOG EXTRACT. 0.000000
LOCATION: OMPDBC1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-17
GROUP: DBC1 ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SC11 TO: NOT SPECIFIED
SUBSYSTEM: SC11 ACTUAL FROM: 08/24/16 07:02:00.00
DB2 VERSION: V12
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 07:30:00.01 PLANNAME: KO2PLAN WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 07:17:38.21 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : N/P PROD VER: N/P LUW LUN: IPUAPC11 CICS INS: N/A
REQUESTER : OMPDBC1 CORRNAME: 'BLANK' LUW INS: D13DC880FD5E
MAINPACK : KO2PLAN CORRNMBR: 'BLANK' LUW SEQ: 7 ENDUSER : DB2PM
PRIMAUTH : DB2PM CONNTYPE: RRS TRANSACT: 'BLANK'
ORIGAUTH : DB2PM CONNECT : RRSAF WSNAME : RRSAF
MVS ACCOUNTING DATA : 'BLANK'
ACCOUNTING TOKEN(CHAR): 'BLANK'
ACCOUNTING TOKEN(HEX) : 00000000000000000000000000000000000000000000
ELAPSED TIME DISTRIBUTION CLASS 2 TIME DISTRIBUTION
---------------------------------------------------------------- ----------------------------------------------------------------
APPL !=> 3% CPU !=============> 26%
DB2 !================> 33% SECPU !
SUSP !================================> 64% NOTACC !====> 8%
SUSP !=================================> 66%
LOCATION: OMPDBC1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-18
GROUP: DBC1 ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SC11 TO: NOT SPECIFIED
SUBSYSTEM: SC11 ACTUAL FROM: 08/24/16 07:02:00.00
DB2 VERSION: V12
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 07:30:00.01 PLANNAME: KO2PLAN WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 07:17:38.21 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : N/P PROD VER: N/P LUW LUN: IPUAPC11 CICS INS: N/A
REQUESTER : OMPDBC1 CORRNAME: 'BLANK' LUW INS: D13DC880FD5E
MAINPACK : KO2PLAN CORRNMBR: 'BLANK' LUW SEQ: 7 ENDUSER : DB2PM
PRIMAUTH : DB2PM CONNTYPE: RRS TRANSACT: 'BLANK'
ORIGAUTH : DB2PM CONNECT : RRSAF WSNAME : RRSAF
TIMES/EVENTS APPL(CL.1) DB2 (CL.2) CLASS 3 SUSPENSIONS ELAPSED TIME EVENTS TIME/EVENT HIGHLIGHTS
------------ ---------- ---------- -------------------- ------------ -------- ---------- --------------------------
ELAPSED TIME 0.029757 0.028963 LOCK/LATCH(DB2+IRLM) 0.000000 0 N/C THREAD TYPE : ALLIED
NONNESTED 0.029757 0.028963 IRLM LOCK+LATCH 0.000000 0 N/C TERM.CONDITION: NORMAL
STORED PROC 0.000000 0.000000 DB2 LATCH 0.000000 0 N/C INVOKE REASON : STALENESS
UDF 0.000000 0.000000 SYNCHRON. I/O 0.000000 0 N/C PARALLELISM : N/A
TRIGGER 0.000000 0.000000 DATABASE I/O 0.000000 0 N/C PCA RUP COUNT : 0
LOG WRITE I/O 0.000000 0 N/C RUP AUTONOM.PR: 0
CP CPU TIME 0.008263 0.007562 OTHER READ I/O 0.000000 0 N/C AUTONOMOUS PR : 0
AGENT 0.008263 0.007562 OTHER WRTE I/O 0.000000 0 N/C QUANTITY : 8
NONNESTED 0.008263 0.007562 SER.TASK SWTCH 0.019115 11 0.001738 COMMITS : 30
STORED PRC 0.000000 0.000000 UPDATE COMMIT 0.003202 5 0.000640 ROLLBACK : 0
UDF 0.000000 0.000000 OPEN/CLOSE 0.000000 0 N/C SVPT REQUESTS : 0
TRIGGER 0.000000 0.000000 SYSLGRNG REC 0.000000 0 N/C SVPT RELEASE : 0
PAR.TASKS 0.000000 0.000000 EXT/DEL/DEF 0.000000 0 N/C SVPT ROLLBACK : 0
OTHER SERVICE 0.015912 6 0.002652 INCREM.BINDS : 0
SE CPU TIME 0.000000 0.000000 ARC.LOG(QUIES) 0.000000 0 N/C UPDATE/COMMIT : 0.17
NONNESTED 0.000000 0.000000 LOG READ 0.000000 0 N/C SYNCH I/O AVG.: N/C
STORED PROC 0.000000 0.000000 DRAIN LOCK 0.000000 0 N/C PROGRAMS : 1
UDF 0.000000 0.000000 CLAIM RELEASE 0.000000 0 N/C MAX CASCADE : 0
TRIGGER 0.000000 0.000000 PAGE LATCH 0.000000 0 N/C MAX WFILE BLKS: 0
NOTIFY MSGS 0.000000 0 N/C
PAR.TASKS 0.000000 0.000000 GLOBAL CONTENTION 0.000000 0 N/C
COMMIT PH1 WRITE I/O 0.000000 0 N/C
SUSPEND TIME 0.000000 0.019115 ASYNCH CF REQUESTS 0.000000 0 N/C
AGENT N/A 0.019115 TCP/IP LOB XML 0.000000 0 N/C
PAR.TASKS N/A 0.000000 ACCELERATOR 0.000000 0 N/C
STORED PROC 0.000000 N/A AUTONOMOUS PROCEDURE 0.000000 0 N/C
UDF 0.000000 N/A PQ SYNCHRONIZATION 0.000000 0 N/C
LOB COMPRESSION 0.000000 0 N/C
NOT ACCOUNT. N/A 0.002286 FAST INSERT PIPE 0.000000 0 N/C
DB2 ENT/EXIT N/A 318 TOTAL CLASS 3 0.019115 11 0.001738
EN/EX-STPROC N/A 0
EN/EX-UDF N/A 0
DCAPT.DESCR. N/A N/A
LOG EXTRACT. N/A N/A
LOCATION: OMPDBC1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-19
GROUP: DBC1 ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SC11 TO: NOT SPECIFIED
SUBSYSTEM: SC11 ACTUAL FROM: 08/24/16 07:02:00.00
DB2 VERSION: V12
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 07:30:00.01 PLANNAME: KO2PLAN WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 07:17:38.21 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : N/P PROD VER: N/P LUW LUN: IPUAPC11 CICS INS: N/A
REQUESTER : OMPDBC1 CORRNAME: 'BLANK' LUW INS: D13DC880FD5E
MAINPACK : KO2PLAN CORRNMBR: 'BLANK' LUW SEQ: 7 ENDUSER : DB2PM
PRIMAUTH : DB2PM CONNTYPE: RRS TRANSACT: 'BLANK'
ORIGAUTH : DB2PM CONNECT : RRSAF WSNAME : RRSAF
SQL DML TOTAL SQL DCL TOTAL SQL DDL CREATE DROP ALTER DYNAMIC SQL STMT TOTAL
-------- -------- ---------- -------- ---------- ------ ------ ------ -------------------- --------
SELECT 0 LOCK TABLE 0 TABLE 0 0 0 REOPTIMIZATION 0
INSERT 0 GRANT 0 CRT TTABLE 0 N/A N/A NOT FOUND IN CACHE 0
ROWS 0 REVOKE 0 DCL TTABLE 0 N/A N/A FOUND IN CACHE 30
UPDATE 5 SET SQLID 0 AUX TABLE 0 N/A N/A IMPLICIT PREPARES 0
ROWS 5 SET H.VAR. 0 INDEX 0 0 0 PREPARES AVOIDED 0
MERGE 0 SET DEGREE 0 TABLESPACE 0 0 0 CACHE_LIMIT_EXCEEDED 0
DELETE 0 SET RULES 0 DATABASE 0 0 0 PREP_STMT_PURGED 0
ROWS 0 SET PATH 0 STOGROUP 0 0 0 STABILIZED PREPARE 0
SET PREC. 0 SYNONYM 0 0 N/A CSWL - STMTS PARSED 0
DESCRIBE 0 CONNECT 1 0 VIEW 0 0 0 CSWL - LITS REPLACED 0
DESC.TBL 0 CONNECT 2 0 ALIAS 0 0 N/A CSWL - MATCHES FOUND 0
PREPARE 30 SET CONNEC 0 PACKAGE N/A 0 N/A CSWL - DUPLS CREATED 0
OPEN 25 RELEASE 0 PROCEDURE 0 0 0
FETCH 25 CALL 0 FUNCTION 0 0 0
ROWS 25 ASSOC LOC. 0 TRIGGER 0 0 N/A
CLOSE 25 ALLOC CUR. 0 DIST TYPE 0 0 N/A
HOLD LOC. 0 SEQUENCE 0 0 0
DML-ALL 110 FREE LOC. 0 TRUST. CTX 0 0 0
DCL-ALL 0 ROLE 0 0 N/A
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
LOCATION: OMPDBC1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-20
GROUP: DBC1 ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SC11 TO: NOT SPECIFIED
SUBSYSTEM: SC11 ACTUAL FROM: 08/24/16 07:02:00.00
DB2 VERSION: V12
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 07:30:00.01 PLANNAME: KO2PLAN WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 07:17:38.21 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : N/P PROD VER: N/P LUW LUN: IPUAPC11 CICS INS: N/A
REQUESTER : OMPDBC1 CORRNAME: 'BLANK' LUW INS: D13DC880FD5E
MAINPACK : KO2PLAN CORRNMBR: 'BLANK' LUW SEQ: 7 ENDUSER : DB2PM
PRIMAUTH : DB2PM CONNTYPE: RRS TRANSACT: 'BLANK'
ORIGAUTH : DB2PM CONNECT : RRSAF WSNAME : RRSAF
MEASURED/ELIG TIMES APPL (CL1) DB2 (CL2) RID LIST TOTAL DATA CAPTURE TOTAL ROWID TOTAL
------------------- ---------- ---------- ---------------------- -------- ------------ -------- ---------- --------
ELAPSED TIME 0.029757 0.028963 USED 0 IFI CALLS 0 DIR ACCESS 0
ELIGIBLE FOR ACCEL N/A 0.000000 REC.CAPTURED 0 INDEX USED 0
FAIL-NO STORAGE 0 LOG REC.READ 0 TS SCAN 0
CP CPU TIME 0.008263 0.007562 FAIL-LIMIT EXC. 0 ROWS RETURN 0
ELIGIBLE FOR SECP 0.000000 N/A RECORDS RET. 0
ELIGIBLE FOR ACCEL N/A 0.000000 INTERRUPTED-NO STORAGE 0 DATA DES.RET 0
INTERRUPTED-LIMIT EXC. 0 TABLES RET. 0
SE CPU TIME 0.000000 0.000000 DESCRIBES 0
ELIGIBLE FOR ACCEL N/A 0.000000 OVERFLOWED-NO STORAGE 0
OVERFLOWED-LIMIT EXC. 0
SKIPPED-INDEX KNOWN 0
GLOBAL CONTENTION L-LOCKS ELAPSED TIME EVENTS GLOBAL CONTENTION P-LOCKS ELAPSED TIME EVENTS
------------------------------------- ------------ -------- ------------------------------------- ------------ --------
L-LOCKS 0.000000 0 P-LOCKS 0.000000 0
PARENT (DB,TS,TAB,PART) 0.000000 0 PAGESET/PARTITION 0.000000 0
CHILD (PAGE,ROW) 0.000000 0 PAGE 0.000000 0
OTHER 0.000000 0 OTHER 0.000000 0
LOCKING TOTAL DATA SHARING TOTAL QUERY PARALLELISM TOTAL DRAIN/CLAIM TOTAL
------------------- -------- ------------ -------- ------------------------- -------- ------------ --------
TIMEOUTS 0 GLOB CONT(%) 0.00 MAXIMUM DEGREE-ESTIMATED 0 DRAIN REQST 0
DEADLOCKS 0 FALS CONT(%) 0.00 MAXIMUM DEGREE-PLANNED 0 DRAIN FAILED 0
ESCAL.(SHAR) 0 P/L-LOCKS(%) 57 MAXIMUM DEGREE-EXECUTED 0 CLAIM REQST 35
ESCAL.(EXCL) 0 P-LOCK REQ 0 MAXIMUM MEMBERS USED N/P CLAIM FAILED 0
MAX PG/ROW LCK HELD 1 P-UNLOCK REQ 0 PARALLEL GROUPS EXECUTED 0
LOCK REQUEST 70 P-CHANGE REQ 0 RAN AS PLANNED 0
UNLOCK REQST 30 LOCK - XES 40 RAN REDUCED-STORAGE 0
QUERY REQST 0 UNLOCK-XES 0 RAN REDUCED-NEGOTIATION 0
CHANGE REQST 5 CHANGE-XES 5 SEQ-CURSOR 0
OTHER REQST 0 SUSP - IRLM 0 SEQ-NO ESA SORT 0
TOTAL SUSPENSIONS 0 SUSP - XES 0 SEQ-NO BUFFER 0
LOCK SUSPENS 0 CONV - XES 0 SEQ-AUTONOMOUS PROC 0
IRLM LATCH SUSPENS 0 FALSE CONT 0 SEQ-NEGOTIATION 0
OTHER SUSPENS 0 INCOMP.LOCK 0 ONE DB2-COORDINATOR = NO 0
NOTIFY SENT 0 ONE DB2-ISOLATION LEVEL 0
ONE DB2-DCL TTABLE 0
MEMB SKIPPED(%) 0
DISABLED BY RLF NO
REFORM PARAL-CONFIG 0
REFORM PARAL-NO BUF 0
LOCATION: OMPDBC1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-21
GROUP: DBC1 ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SC11 TO: NOT SPECIFIED
SUBSYSTEM: SC11 ACTUAL FROM: 08/24/16 07:02:00.00
DB2 VERSION: V12
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 07:30:00.01 PLANNAME: KO2PLAN WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 07:17:38.21 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : N/P PROD VER: N/P LUW LUN: IPUAPC11 CICS INS: N/A
REQUESTER : OMPDBC1 CORRNAME: 'BLANK' LUW INS: D13DC880FD5E
MAINPACK : KO2PLAN CORRNMBR: 'BLANK' LUW SEQ: 7 ENDUSER : DB2PM
PRIMAUTH : DB2PM CONNTYPE: RRS TRANSACT: 'BLANK'
ORIGAUTH : DB2PM CONNECT : RRSAF WSNAME : RRSAF
STORED PROC. TOTAL UDF TOTAL TRIGGERS TOTAL LOGGING TOTAL
------------ -------- --------- -------- ------------ -------- ----------------- --------
CALL STMTS 0 EXECUTED 0 STMT TRIGGER 0 LOG RECS WRITTEN 30
ABENDED 0 ABENDED 0 ROW TRIGGER 0 TOT BYTES WRITTEN 3783
TIMED OUT 0 TIMED OUT 0 SQL ERROR 0
REJECTED 0 REJECTED 0
TOTAL SU CLASS 1 CLASS 2 MISCELLANEOUS TOTAL
------------ -------------- -------------- -------------------- --------
CP CPU 535 489 MAX STO LOB VAL (KB) 0
AGENT 535 489 MAX STO XML VAL (KB) 0
NONNESTED 535 489 ARRAY EXPANSIONS 0
STORED PRC 0 0 SPARSE IX DISABLED 0
UDF 0 0 SPARSE IX BUILT WF 0
TRIGGER 0 0
PAR.TASKS 0 0
ELIG SECP 0 N/A
ELIG ACCEL N/A 0
SE CPU 0 0
NONNESTED 0 0
STORED PROC 0 0
UDF 0 0
TRIGGER 0 0
PAR.TASKS 0 0
ELIG ACCEL N/A 0
---- RESOURCE LIMIT FACILITY --------------------------------------------------------------------------------------------------
TYPE: N/P TABLE ID: N/P SERV.UNITS: N/P CPU SECONDS: N/P MAX CPU SEC: N/P
BP0 BPOOL ACTIVITY TOTAL BP32K BPOOL ACTIVITY TOTAL TOTAL BPOOL ACTIVITY TOTAL
--------------------- -------- --------------------- -------- --------------------- --------
BPOOL HIT RATIO (%) 100 BPOOL HIT RATIO (%) 100 BPOOL HIT RATIO (%) 100
GETPAGES 40 GETPAGES 20 GETPAGES 60
BUFFER UPDATES 5 BUFFER UPDATES 0 BUFFER UPDATES 5
SYNCHRONOUS WRITE 0 SYNCHRONOUS WRITE 0 SYNCHRONOUS WRITE 0
SYNCHRONOUS READ 0 SYNCHRONOUS READ 0 SYNCHRONOUS READ 0
SEQ. PREFETCH REQS 0 SEQ. PREFETCH REQS 0 SEQ. PREFETCH REQS 0
LIST PREFETCH REQS 0 LIST PREFETCH REQS 0 LIST PREFETCH REQS 0
DYN. PREFETCH REQS 0 DYN. PREFETCH REQS 0 DYN. PREFETCH REQS 0
PAGES READ ASYNCHR. 0 PAGES READ ASYNCHR. 0 PAGES READ ASYNCHR. 0
LOCATION: OMPDBC1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-22
GROUP: DBC1 ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SC11 TO: NOT SPECIFIED
SUBSYSTEM: SC11 ACTUAL FROM: 08/24/16 07:02:00.00
DB2 VERSION: V12
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 07:30:00.01 PLANNAME: KO2PLAN WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 07:17:38.21 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : N/P PROD VER: N/P LUW LUN: IPUAPC11 CICS INS: N/A
REQUESTER : OMPDBC1 CORRNAME: 'BLANK' LUW INS: D13DC880FD5E
MAINPACK : KO2PLAN CORRNMBR: 'BLANK' LUW SEQ: 7 ENDUSER : DB2PM
PRIMAUTH : DB2PM CONNTYPE: RRS TRANSACT: 'BLANK'
ORIGAUTH : DB2PM CONNECT : RRSAF WSNAME : RRSAF
GROUP BP0 TOTAL GROUP BP32K TOTAL GROUP TOTAL TOTAL
--------------------- -------- --------------------- -------- --------------------- --------
GBP-DEPEND GETPAGES 40 GBP-DEPEND GETPAGES 20 GBP-DEPEND GETPAGES 60
READ(XI)-DATA RETUR 0 READ(XI)-DATA RETUR 0 READ(XI)-DATA RETUR 0
READ(XI)-NO DATA RT 0 READ(XI)-NO DATA RT 0 READ(XI)-NO DATA RT 0
READ(NF)-DATA RETUR 0 READ(NF)-DATA RETUR 0 READ(NF)-DATA RETUR 0
READ(NF)-NO DATA RT 0 READ(NF)-NO DATA RT 0 READ(NF)-NO DATA RT 0
PREFETCH PAGES READ 0 PREFETCH PAGES READ 0 PREFETCH PAGES READ 0
CLEAN PAGES WRITTEN 0 CLEAN PAGES WRITTEN 0 CLEAN PAGES WRITTEN 0
UNREGISTER PAGE 0 UNREGISTER PAGE 0 UNREGISTER PAGE 0
ASYNCH GBP REQUESTS 0 ASYNCH GBP REQUESTS 0 ASYNCH GBP REQUESTS 0
EXPLICIT X-INVALID 0 EXPLICIT X-INVALID 0 EXPLICIT X-INVALID 0
ASYNCH SEC-GBP REQ 0 ASYNCH SEC-GBP REQ 0 ASYNCH SEC-GBP REQ 0
PG P-LOCK LOCK REQ 0 PG P-LOCK LOCK REQ 0 PG P-LOCK LOCK REQ 0
SPACE MAP PAGES 0 SPACE MAP PAGES 0 SPACE MAP PAGES 0
DATA PAGES 0 DATA PAGES 0 DATA PAGES 0
INDEX LEAF PAGES 0 INDEX LEAF PAGES 0 INDEX LEAF PAGES 0
PG P-LOCK UNLOCK REQ 0 PG P-LOCK UNLOCK REQ 0 PG P-LOCK UNLOCK REQ 0
PG P-LOCK LOCK SUSP 0 PG P-LOCK LOCK SUSP 0 PG P-LOCK LOCK SUSP 0
SPACE MAP PAGES 0 SPACE MAP PAGES 0 SPACE MAP PAGES 0
DATA PAGES 0 DATA PAGES 0 DATA PAGES 0
INDEX LEAF PAGES 0 INDEX LEAF PAGES 0 INDEX LEAF PAGES 0
WRITE AND REGISTER 5 WRITE AND REGISTER 0 WRITE AND REGISTER 5
WRITE & REGISTER MULT 0 WRITE & REGISTER MULT 0 WRITE & REGISTER MULT 0
CHANGED PAGES WRITTEN 5 CHANGED PAGES WRITTEN 0 CHANGED PAGES WRITTEN 5
COMPL CHECKS SUSPEND 0 COMPL CHECKS SUSPEND 0 COMPL CHECKS SUSPEND 0
LOCATION: OMPDBC1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-23
GROUP: DBC1 ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SC11 TO: NOT SPECIFIED
SUBSYSTEM: SC11 ACTUAL FROM: 08/24/16 07:02:00.00
DB2 VERSION: V12
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 07:30:00.01 PLANNAME: KO2PLAN WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 07:17:38.21 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : N/P PROD VER: N/P LUW LUN: IPUAPC11 CICS INS: N/A
REQUESTER : OMPDBC1 CORRNAME: 'BLANK' LUW INS: D13DC880FD5E
MAINPACK : KO2PLAN CORRNMBR: 'BLANK' LUW SEQ: 7 ENDUSER : DB2PM
PRIMAUTH : DB2PM CONNTYPE: RRS TRANSACT: 'BLANK'
ORIGAUTH : DB2PM CONNECT : RRSAF WSNAME : RRSAF
FPEVWRP2 VALUE FPEVWRP2 TIMES FPEVWRP2 TIME EVENTS TIME/EVENT
------------------ ------------------ ------------------ ------------ ------------------ ------------ ------ ------------
TYPE PACKAGE ELAPSED TIME - CL7 0.011564 LOCK/LATCH 0.000000 0 N/C
LOCATION OMPDBC1 CP CPU TIME 0.006231 IRLM LOCK+LATCH 0.000000 0 N/C
COLLECTION ID KO2OM530 AGENT 0.006231 DB2 LATCH 0.000000 0 N/C
PROGRAM NAME FPEVWRP2 PAR.TASKS 0.000000 SYNCHRONOUS I/O 0.000000 0 N/C
CONSISTENCY TOKEN 1A20F0C107FBA51D SE CPU TIME 0.000000 OTHER READ I/O 0.000000 0 N/C
ACTIVITY TYPE NONNESTED SUSPENSION-CL8 0.003202 OTHER WRITE I/O 0.000000 0 N/C
ACTIVITY NAME 'BLANK' AGENT 0.003202 SERV.TASK SWITCH 0.003202 5 0.000640
SCHEMA NAME 'BLANK' PAR.TASKS 0.000000 ARCH.LOG(QUIESCE) 0.000000 0 N/C
SUCC AUTH CHECK N/P NOT ACCOUNTED 0.002131 ARCHIVE LOG READ 0.000000 0 N/C
NBR OF ALLOCATIONS 5 DRAIN LOCK 0.000000 0 N/C
SQL STMT - AVERAGE 22.00 CP CPU SU 404 CLAIM RELEASE 0.000000 0 N/C
SQL STMT - TOTAL 110 AGENT 404 PAGE LATCH 0.000000 0 N/C
NBR RLUP THREADS 5 PAR.TASKS 0 NOTIFY MESSAGES 0.000000 0 N/C
SE CPU SU 0 GLOBAL CONTENTION 0.000000 0 N/C
TCP/IP LOB XML 0.000000 0 N/C
DB2 ENTRY/EXIT 290 ACCELERATOR 0.000000 0 N/C
PQ SYNCHRONIZATION 0.000000 0 N/C
FAST INSERT PIPE 0.000000 0 N/C
TOTAL CL8 SUSPENS. 0.003202 5 0.000640
FPEVWRP2 ELAPSED TIME EVENTS FPEVWRP2 ELAPSED TIME EVENTS
------------------------- ------------ -------- ------------------------- ------------ --------
GLOBAL CONTENTION L-LOCKS 0.000000 0 GLOBAL CONTENTION P-LOCKS 0.000000 0
PARENT (DB,TS,TAB,PART) 0.000000 0 PAGESET/PARTITION 0.000000 0
CHILD (PAGE,ROW) 0.000000 0 PAGE 0.000000 0
OTHER 0.000000 0 OTHER 0.000000 0
FPEVWRP2 TOTAL
------------------ --------
SELECT 0
INSERT 0
UPDATE 5
DELETE 0
DESCRIBE 0
PREPARE 30
OPEN 25
FETCH 25
CLOSE 25
LOCK TABLE 0
CALL 0
LOCATION: OMPDBC1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-24
GROUP: DBC1 ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SC11 TO: NOT SPECIFIED
SUBSYSTEM: SC11 ACTUAL FROM: 08/24/16 07:02:00.00
DB2 VERSION: V12
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 07:30:00.01 PLANNAME: KO2PLAN WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 07:17:38.21 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : N/P PROD VER: N/P LUW LUN: IPUAPC11 CICS INS: N/A
REQUESTER : OMPDBC1 CORRNAME: 'BLANK' LUW INS: D13DC880FD5E
MAINPACK : KO2PLAN CORRNMBR: 'BLANK' LUW SEQ: 7 ENDUSER : DB2PM
PRIMAUTH : DB2PM CONNTYPE: RRS TRANSACT: 'BLANK'
ORIGAUTH : DB2PM CONNECT : RRSAF WSNAME : RRSAF
FPEVWRP2 TOTAL
------------------- --------
BPOOL HIT RATIO (%) 100
GETPAGES 60
BUFFER UPDATES 5
SYNCHRONOUS WRITE 0
SYNCHRONOUS READ 0
SEQ. PREFETCH REQS 0
LIST PREFETCH REQS 0
DYN. PREFETCH REQS 0
PAGES READ ASYNCHR. 0
FPEVWRP2 TOTAL
--------------------- --------
TIMEOUTS 0
DEADLOCKS 0
ESCAL.(SHARED) 0
ESCAL.(EXCLUS) 0
MAX PG/ROW LOCKS HELD 1
LOCK REQUEST 65
UNLOCK REQUEST 30
QUERY REQUEST 0
CHANGE REQUEST 5
OTHER REQUEST 0
TOTAL SUSPENSIONS 0
LOCK SUSPENS 0
IRLM LATCH SUSPENS 0
OTHER SUSPENS 0
TIMES CLASS 5 IFI (CL.5)
------------- ----------
ELAPSED TIME 0.000000
CP CPU TIME 0.000000
DCAPT.DESCR. 0.000000
LOG EXTRACT. 0.000000
LOCATION: OMPDBC1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-25
GROUP: DBC1 ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SC11 TO: NOT SPECIFIED
SUBSYSTEM: SC11 ACTUAL FROM: 08/24/16 07:02:00.00
DB2 VERSION: V12
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 07:45:00.00 PLANNAME: KO2PLAN WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 07:32:58.16 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : N/P PROD VER: N/P LUW LUN: IPUAPC11 CICS INS: N/A
REQUESTER : OMPDBC1 CORRNAME: 'BLANK' LUW INS: D13DCBA02BC7
MAINPACK : KO2PLAN CORRNMBR: 'BLANK' LUW SEQ: 1 ENDUSER : DB2PM
PRIMAUTH : DB2PM CONNTYPE: RRS TRANSACT: 'BLANK'
ORIGAUTH : DB2PM CONNECT : RRSAF WSNAME : RRSAF
MVS ACCOUNTING DATA : 'BLANK'
ACCOUNTING TOKEN(CHAR): 'BLANK'
ACCOUNTING TOKEN(HEX) : 00000000000000000000000000000000000000000000
ELAPSED TIME DISTRIBUTION CLASS 2 TIME DISTRIBUTION
---------------------------------------------------------------- ----------------------------------------------------------------
APPL !=> 2% CPU !============> 24%
DB2 !===============> 31% SECPU !
SUSP !=================================> 66% NOTACC !====> 8%
SUSP !==================================> 68%
...
LOCATION: OMPDBEE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 3-1
GROUP: DBEE ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SEE1 TO: NOT SPECIFIED
SUBSYSTEM: SEE1 ACTUAL FROM: 08/24/16 08:16:02.78
DB2 VERSION: V11
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 08:16:02.78 PLANNAME: DSNUTIL WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 08:16:00.37 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : 08/24/16 08:16:02.78 PROD VER: N/P LUW LUN: IPUAPEE1 CICS INS: N/A
REQUESTER : OMPDBEE CORRNAME: MISIDC LUW INS: D13DD2CF7CB8
MAINPACK : DSNUTIL CORRNMBR: 'BLANK' LUW SEQ: 27 ENDUSER : MIS
PRIMAUTH : MIS CONNTYPE: UTILITY TRANSACT: MISIDC
ORIGAUTH : MIS CONNECT : UTILITY WSNAME : UTILITY
MVS ACCOUNTING DATA : 00816,B000,MIS
ACCOUNTING TOKEN(CHAR): N/A
ACCOUNTING TOKEN(HEX) : N/A
TIMES/EVENTS APPL(CL.1) DB2 (CL.2) CLASS 3 SUSPENSIONS ELAPSED TIME EVENTS TIME/EVENT HIGHLIGHTS
------------ ---------- ---------- -------------------- ------------ -------- ---------- --------------------------
ELAPSED TIME 2.411696 N/P LOCK/LATCH(DB2+IRLM) N/P N/P N/P THREAD TYPE : ALLIED
NONNESTED 2.411696 N/P IRLM LOCK+LATCH N/P N/P N/P TERM.CONDITION: NORMAL
STORED PROC N/P N/P DB2 LATCH N/P N/P N/P INVOKE REASON : DEALLOC
UDF 0.000000 0.000000 SYNCHRON. I/O N/P N/P N/P PARALLELISM : N/A
TRIGGER 0.000000 0.000000 DATABASE I/O N/P N/P N/P PCA RUP COUNT : N/P
LOG WRITE I/O N/P N/P N/P RUP AUTONOM.PR: 0
CP CPU TIME 0.305161 N/P OTHER READ I/O N/P N/P N/P AUTONOMOUS PR : N/P
AGENT 0.305161 N/P OTHER WRTE I/O N/P N/P N/P QUANTITY : 0
NONNESTED 0.305161 N/P SER.TASK SWTCH N/P N/P N/P COMMITS : 26
STORED PRC 0.000000 N/P UPDATE COMMIT N/P N/P N/P ROLLBACK : 0
UDF 0.000000 0.000000 OPEN/CLOSE N/P N/P N/P SVPT REQUESTS : 0
TRIGGER 0.000000 0.000000 SYSLGRNG REC N/P N/P N/P SVPT RELEASE : 0
PAR.TASKS 0.000000 N/P EXT/DEL/DEF N/P N/P N/P SVPT ROLLBACK : 0
OTHER SERVICE N/P N/P N/P INCREM.BINDS : N/P
SE CPU TIME 0.000000 0.000000 ARC.LOG(QUIES) N/P N/P N/P UPDATE/COMMIT : N/P
NONNESTED 0.000000 0.000000 LOG READ N/P N/P N/P SYNCH I/O AVG.: N/P
STORED PROC 0.000000 0.000000 DRAIN LOCK N/P N/P N/P PROGRAMS : 0
UDF 0.000000 0.000000 CLAIM RELEASE N/P N/P N/P MAX CASCADE : N/P
TRIGGER 0.000000 0.000000 PAGE LATCH N/P N/P N/P MAX WFILE BLKS: N/A
NOTIFY MSGS N/P N/P N/P
PAR.TASKS 0.000000 0.000000 GLOBAL CONTENTION N/P N/P N/P
COMMIT PH1 WRITE I/O N/P N/P N/P
SUSPEND TIME N/P N/P ASYNCH CF REQUESTS N/P N/P N/P
AGENT N/A N/P TCP/IP LOB XML N/P N/P N/P
PAR.TASKS N/A N/P ACCELERATOR N/P N/P N/P
STORED PROC N/P N/A AUTONOMOUS PROCEDURE N/P N/P N/P
UDF N/P N/A PQ SYNCHRONIZATION N/P N/P N/P
LOB COMPRESSION N/A N/A N/A
NOT ACCOUNT. N/A N/P FAST INSERT PIPE N/A N/A N/A
DB2 ENT/EXIT N/A N/P TOTAL CLASS 3 N/P N/P N/P
EN/EX-STPROC N/A N/P
EN/EX-UDF N/A N/P
DCAPT.DESCR. N/A N/A
LOG EXTRACT. N/A N/A
LOCATION: OMPDBEE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 3-2
GROUP: DBEE ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SEE1 TO: NOT SPECIFIED
SUBSYSTEM: SEE1 ACTUAL FROM: 08/24/16 08:16:02.78
DB2 VERSION: V11
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 08:16:02.78 PLANNAME: DSNUTIL WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 08:16:00.37 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : 08/24/16 08:16:02.78 PROD VER: N/P LUW LUN: IPUAPEE1 CICS INS: N/A
REQUESTER : OMPDBEE CORRNAME: MISIDC LUW INS: D13DD2CF7CB8
MAINPACK : DSNUTIL CORRNMBR: 'BLANK' LUW SEQ: 27 ENDUSER : MIS
PRIMAUTH : MIS CONNTYPE: UTILITY TRANSACT: MISIDC
ORIGAUTH : MIS CONNECT : UTILITY WSNAME : UTILITY
SQL DML TOTAL SQL DCL TOTAL SQL DDL CREATE DROP ALTER DYNAMIC SQL STMT TOTAL
-------- -------- ---------- -------- ---------- ------ ------ ------ -------------------- --------
SELECT N/P LOCK TABLE N/P TABLE N/P N/P N/P REOPTIMIZATION N/P
INSERT N/P GRANT N/P CRT TTABLE N/P N/A N/A NOT FOUND IN CACHE N/P
ROWS N/P REVOKE N/P DCL TTABLE N/P N/A N/A FOUND IN CACHE N/P
UPDATE N/P SET SQLID N/P AUX TABLE N/P N/A N/A IMPLICIT PREPARES N/P
ROWS N/P SET H.VAR. N/P INDEX N/P N/P N/P PREPARES AVOIDED N/P
MERGE N/P SET DEGREE N/P TABLESPACE N/P N/P N/P CACHE_LIMIT_EXCEEDED N/P
DELETE N/P SET RULES N/P DATABASE N/P N/P N/P PREP_STMT_PURGED N/P
ROWS N/P SET PATH N/P STOGROUP N/P N/P N/P STABILIZED PREPARE N/A
SET PREC. N/P SYNONYM N/P N/P N/A CSWL - STMTS PARSED N/P
DESCRIBE N/P CONNECT 1 N/P VIEW N/P N/P N/P CSWL - LITS REPLACED N/P
DESC.TBL N/P CONNECT 2 N/P ALIAS N/P N/P N/A CSWL - MATCHES FOUND N/P
PREPARE N/P SET CONNEC N/P PACKAGE N/A N/P N/A CSWL - DUPLS CREATED N/P
OPEN N/P RELEASE N/P PROCEDURE N/P N/P N/P
FETCH N/P CALL N/P FUNCTION N/P N/P N/P
ROWS N/P ASSOC LOC. N/P TRIGGER N/P N/P N/A
CLOSE N/P ALLOC CUR. N/P DIST TYPE N/P N/P N/A
HOLD LOC. N/P SEQUENCE N/P N/P N/P
DML-ALL N/P FREE LOC. N/P TRUST. CTX N/P N/P N/P
DCL-ALL N/P ROLE N/P N/P N/A
JAR N/A N/A N/P
MASK/PERM N/P N/P N/P
VARIABLE N/P N/P N/A
TOTAL N/P N/P N/P
TRUNC TBL N/P
RENAME TBL N/P
RENAME IX N/P
COMMENT ON N/P
LABEL ON N/P
LOCATION: OMPDBEE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 3-3
GROUP: DBEE ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SEE1 TO: NOT SPECIFIED
SUBSYSTEM: SEE1 ACTUAL FROM: 08/24/16 08:16:02.78
DB2 VERSION: V11
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 08:16:02.78 PLANNAME: DSNUTIL WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 08:16:00.37 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : 08/24/16 08:16:02.78 PROD VER: N/P LUW LUN: IPUAPEE1 CICS INS: N/A
REQUESTER : OMPDBEE CORRNAME: MISIDC LUW INS: D13DD2CF7CB8
MAINPACK : DSNUTIL CORRNMBR: 'BLANK' LUW SEQ: 27 ENDUSER : MIS
PRIMAUTH : MIS CONNTYPE: UTILITY TRANSACT: MISIDC
ORIGAUTH : MIS CONNECT : UTILITY WSNAME : UTILITY
MEASURED/ELIG TIMES APPL (CL1) DB2 (CL2) RID LIST TOTAL DATA CAPTURE TOTAL ROWID TOTAL
------------------- ---------- ---------- ---------------------- -------- ------------ -------- ---------- --------
ELAPSED TIME 2.411696 N/P USED N/P IFI CALLS N/P DIR ACCESS N/P
ELIGIBLE FOR ACCEL N/A 0.000000 REC.CAPTURED N/P INDEX USED N/P
FAIL-NO STORAGE N/P LOG REC.READ N/P TS SCAN N/P
CP CPU TIME 0.305161 N/P FAIL-LIMIT EXC. N/P ROWS RETURN N/P
ELIGIBLE FOR SECP 0.000000 N/A RECORDS RET. N/P
ELIGIBLE FOR ACCEL N/A 0.000000 INTERRUPTED-NO STORAGE N/P DATA DES.RET N/P
INTERRUPTED-LIMIT EXC. N/P TABLES RET. N/P
SE CPU TIME 0.000000 0.000000 DESCRIBES N/P
ELIGIBLE FOR ACCEL N/A 0.000000 OVERFLOWED-NO STORAGE N/P
OVERFLOWED-LIMIT EXC. N/P
SKIPPED-INDEX KNOWN N/P
GLOBAL CONTENTION L-LOCKS ELAPSED TIME EVENTS GLOBAL CONTENTION P-LOCKS ELAPSED TIME EVENTS
------------------------------------- ------------ -------- ------------------------------------- ------------ --------
L-LOCKS N/P N/P P-LOCKS N/P N/P
PARENT (DB,TS,TAB,PART) N/P N/P PAGESET/PARTITION N/P N/P
CHILD (PAGE,ROW) N/P N/P PAGE N/P N/P
OTHER N/P N/P OTHER N/P N/P
LOCKING TOTAL DATA SHARING TOTAL QUERY PARALLELISM TOTAL DRAIN/CLAIM TOTAL
------------------- -------- ------------ -------- ------------------------- -------- ------------ --------
TIMEOUTS 0 GLOB CONT(%) 7.25 MAXIMUM DEGREE-ESTIMATED N/P DRAIN REQST 2
DEADLOCKS 0 FALS CONT(%) 3.14 MAXIMUM DEGREE-PLANNED N/P DRAIN FAILED 0
ESCAL.(SHAR) 0 P/L-LOCKS(%) 1 MAXIMUM DEGREE-EXECUTED N/P CLAIM REQST 168
ESCAL.(EXCL) 0 P-LOCK REQ 178 MAXIMUM MEMBERS USED N/P CLAIM FAILED 0
MAX PG/ROW LCK HELD 19 P-UNLOCK REQ 117 PARALLEL GROUPS EXECUTED N/P
LOCK REQUEST 25304 P-CHANGE REQ 18 RAN AS PLANNED N/P
UNLOCK REQST 25137 LOCK - XES 439 RAN REDUCED-STORAGE N/P
QUERY REQST 8 UNLOCK-XES 255 RAN REDUCED-NEGOTIATION N/P
CHANGE REQST 56 CHANGE-XES 74 SEQ-CURSOR N/P
OTHER REQST 0 SUSP - IRLM 29 SEQ-NO ESA SORT N/P
TOTAL SUSPENSIONS 18 SUSP - XES 5 SEQ-NO BUFFER N/P
LOCK SUSPENS 0 CONV - XES 0 SEQ-AUTONOMOUS PROC N/P
IRLM LATCH SUSPENS 0 FALSE CONT 26 SEQ-NEGOTIATION N/P
OTHER SUSPENS 18 INCOMP.LOCK 0 ONE DB2-COORDINATOR = NO N/P
NOTIFY SENT 18 ONE DB2-ISOLATION LEVEL N/P
ONE DB2-DCL TTABLE N/P
MEMB SKIPPED(%) N/P
DISABLED BY RLF N/P
REFORM PARAL-CONFIG N/P
REFORM PARAL-NO BUF N/P
LOCATION: OMPDBEE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 3-4
GROUP: DBEE ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SEE1 TO: NOT SPECIFIED
SUBSYSTEM: SEE1 ACTUAL FROM: 08/24/16 08:16:02.78
DB2 VERSION: V11
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 08:16:02.78 PLANNAME: DSNUTIL WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 08:16:00.37 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : 08/24/16 08:16:02.78 PROD VER: N/P LUW LUN: IPUAPEE1 CICS INS: N/A
REQUESTER : OMPDBEE CORRNAME: MISIDC LUW INS: D13DD2CF7CB8
MAINPACK : DSNUTIL CORRNMBR: 'BLANK' LUW SEQ: 27 ENDUSER : MIS
PRIMAUTH : MIS CONNTYPE: UTILITY TRANSACT: MISIDC
ORIGAUTH : MIS CONNECT : UTILITY WSNAME : UTILITY
STORED PROC. TOTAL UDF TOTAL TRIGGERS TOTAL LOGGING TOTAL
------------ -------- --------- -------- ------------ -------- ----------------- --------
CALL STMTS N/P EXECUTED N/P STMT TRIGGER N/P LOG RECS WRITTEN 596
ABENDED N/P ABENDED N/P ROW TRIGGER N/P TOT BYTES WRITTEN 918905
TIMED OUT N/P TIMED OUT N/P SQL ERROR N/P
REJECTED N/P REJECTED N/P
TOTAL SU CLASS 1 CLASS 2 MISCELLANEOUS TOTAL
------------ -------------- -------------- -------------------- --------
CP CPU 19767 N/P MAX STO LOB VAL (KB) N/P
AGENT 19767 0 MAX STO XML VAL (KB) N/P
NONNESTED 19767 0 ARRAY EXPANSIONS N/P
STORED PRC 0 N/P SPARSE IX DISABLED N/P
UDF 0 0 SPARSE IX BUILT WF N/P
TRIGGER N/P N/P
PAR.TASKS 0 N/P
ELIG SECP 0 N/A
ELIG ACCEL N/A 0
SE CPU 0 0
NONNESTED 0 0
STORED PROC 0 0
UDF 0 0
TRIGGER 0 0
PAR.TASKS 0 0
ELIG ACCEL N/A 0
---- RESOURCE LIMIT FACILITY --------------------------------------------------------------------------------------------------
TYPE: N/P TABLE ID: N/P SERV.UNITS: N/P CPU SECONDS: 0.000000 MAX CPU SEC: N/P
BP0 BPOOL ACTIVITY TOTAL BP32K BPOOL ACTIVITY TOTAL BP8K BPOOL ACTIVITY TOTAL
--------------------- -------- --------------------- -------- --------------------- --------
BPOOL HIT RATIO (%) 97 BPOOL HIT RATIO (%) 86 BPOOL HIT RATIO (%) 100
GETPAGES 7377 GETPAGES 90 GETPAGES 137493
BUFFER UPDATES 401 BUFFER UPDATES 66 BUFFER UPDATES 0
SYNCHRONOUS WRITE 0 SYNCHRONOUS WRITE 3 SYNCHRONOUS WRITE 0
SYNCHRONOUS READ 115 SYNCHRONOUS READ 12 SYNCHRONOUS READ 20
SEQ. PREFETCH REQS 0 SEQ. PREFETCH REQS 0 SEQ. PREFETCH REQS 0
LIST PREFETCH REQS 0 LIST PREFETCH REQS 0 LIST PREFETCH REQS 0
DYN. PREFETCH REQS 2559 DYN. PREFETCH REQS 1 DYN. PREFETCH REQS 10228
PAGES READ ASYNCHR. 115 PAGES READ ASYNCHR. 1 PAGES READ ASYNCHR. 56
LOCATION: OMPDBEE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 3-5
GROUP: DBEE ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SEE1 TO: NOT SPECIFIED
SUBSYSTEM: SEE1 ACTUAL FROM: 08/24/16 08:16:02.78
DB2 VERSION: V11
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 08:16:02.78 PLANNAME: DSNUTIL WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 08:16:00.37 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : 08/24/16 08:16:02.78 PROD VER: N/P LUW LUN: IPUAPEE1 CICS INS: N/A
REQUESTER : OMPDBEE CORRNAME: MISIDC LUW INS: D13DD2CF7CB8
MAINPACK : DSNUTIL CORRNMBR: 'BLANK' LUW SEQ: 27 ENDUSER : MIS
PRIMAUTH : MIS CONNTYPE: UTILITY TRANSACT: MISIDC
ORIGAUTH : MIS CONNECT : UTILITY WSNAME : UTILITY
TOTAL BPOOL ACTIVITY TOTAL
--------------------- --------
BPOOL HIT RATIO (%) 100
GETPAGES 144960
BUFFER UPDATES 467
SYNCHRONOUS WRITE 3
SYNCHRONOUS READ 147
SEQ. PREFETCH REQS 0
LIST PREFETCH REQS 0
DYN. PREFETCH REQS 12788
PAGES READ ASYNCHR. 172
GROUP BP0 TOTAL GROUP BP32K TOTAL GROUP TOTAL TOTAL
--------------------- -------- --------------------- -------- --------------------- --------
GBP-DEPEND GETPAGES 516 GBP-DEPEND GETPAGES 31 GBP-DEPEND GETPAGES 547
READ(XI)-DATA RETUR 1 READ(XI)-DATA RETUR 0 READ(XI)-DATA RETUR 1
READ(XI)-NO DATA RT 12 READ(XI)-NO DATA RT 1 READ(XI)-NO DATA RT 13
READ(NF)-DATA RETUR 1 READ(NF)-DATA RETUR 0 READ(NF)-DATA RETUR 1
READ(NF)-NO DATA RT 44 READ(NF)-NO DATA RT 2 READ(NF)-NO DATA RT 46
PREFETCH PAGES READ 0 PREFETCH PAGES READ 0 PREFETCH PAGES READ 0
CLEAN PAGES WRITTEN 0 CLEAN PAGES WRITTEN 0 CLEAN PAGES WRITTEN 0
UNREGISTER PAGE 52 UNREGISTER PAGE 12 UNREGISTER PAGE 64
ASYNCH GBP REQUESTS 27 ASYNCH GBP REQUESTS 5 ASYNCH GBP REQUESTS 32
EXPLICIT X-INVALID 0 EXPLICIT X-INVALID 0 EXPLICIT X-INVALID 0
ASYNCH SEC-GBP REQ 0 ASYNCH SEC-GBP REQ 0 ASYNCH SEC-GBP REQ 0
PG P-LOCK LOCK REQ 94 PG P-LOCK LOCK REQ 6 PG P-LOCK LOCK REQ 100
SPACE MAP PAGES 43 SPACE MAP PAGES 6 SPACE MAP PAGES 49
DATA PAGES 12 DATA PAGES 0 DATA PAGES 12
INDEX LEAF PAGES 39 INDEX LEAF PAGES 0 INDEX LEAF PAGES 39
PG P-LOCK UNLOCK REQ 107 PG P-LOCK UNLOCK REQ 2 PG P-LOCK UNLOCK REQ 109
PG P-LOCK LOCK SUSP 0 PG P-LOCK LOCK SUSP 0 PG P-LOCK LOCK SUSP 0
SPACE MAP PAGES 0 SPACE MAP PAGES 0 SPACE MAP PAGES 0
DATA PAGES 0 DATA PAGES 0 DATA PAGES 0
INDEX LEAF PAGES 0 INDEX LEAF PAGES 0 INDEX LEAF PAGES 0
WRITE AND REGISTER 37 WRITE AND REGISTER 5 WRITE AND REGISTER 42
WRITE & REGISTER MULT 27 WRITE & REGISTER MULT 0 WRITE & REGISTER MULT 27
CHANGED PAGES WRITTEN 268 CHANGED PAGES WRITTEN 5 CHANGED PAGES WRITTEN 273
COMPL CHECKS SUSPEND 0 COMPL CHECKS SUSPEND 0 COMPL CHECKS SUSPEND 0
TIMES CLASS 5 IFI (CL.5)
------------- ----------
ELAPSED TIME N/P
CP CPU TIME N/P
DCAPT.DESCR. N/P
LOG EXTRACT. N/P
LOCATION: OMPDBEE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 3-6
GROUP: DBEE ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SEE1 TO: NOT SPECIFIED
SUBSYSTEM: SEE1 ACTUAL FROM: 08/24/16 08:16:02.78
DB2 VERSION: V11
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 08:16:02.92 PLANNAME: DSNUTIL WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 08:16:02.85 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : 08/24/16 08:16:02.92 PROD VER: N/P LUW LUN: IPUAPEE1 CICS INS: N/A
REQUESTER : OMPDBEE CORRNAME: MISIDC LUW INS: D13DD2D1D8E0
MAINPACK : DSNUTIL CORRNMBR: 'BLANK' LUW SEQ: 11 ENDUSER : MIS
PRIMAUTH : MIS CONNTYPE: UTILITY TRANSACT: MISIDC
ORIGAUTH : MIS CONNECT : UTILITY WSNAME : UTILITY
MVS ACCOUNTING DATA : 00816,B000,MIS
ACCOUNTING TOKEN(CHAR): N/A
ACCOUNTING TOKEN(HEX) : N/A
TIMES/EVENTS APPL(CL.1) DB2 (CL.2) CLASS 3 SUSPENSIONS ELAPSED TIME EVENTS TIME/EVENT HIGHLIGHTS
------------ ---------- ---------- -------------------- ------------ -------- ---------- --------------------------
ELAPSED TIME 0.075986 N/P LOCK/LATCH(DB2+IRLM) N/P N/P N/P THREAD TYPE : ALLIED
NONNESTED 0.075986 N/P IRLM LOCK+LATCH N/P N/P N/P TERM.CONDITION: NORMAL
STORED PROC N/P N/P DB2 LATCH N/P N/P N/P INVOKE REASON : DEALLOC
UDF 0.000000 0.000000 SYNCHRON. I/O N/P N/P N/P PARALLELISM : N/A
TRIGGER 0.000000 0.000000 DATABASE I/O N/P N/P N/P PCA RUP COUNT : N/P
LOG WRITE I/O N/P N/P N/P RUP AUTONOM.PR: 0
CP CPU TIME 0.003552 N/P OTHER READ I/O N/P N/P N/P AUTONOMOUS PR : N/P
AGENT 0.003552 N/P OTHER WRTE I/O N/P N/P N/P QUANTITY : 0
NONNESTED 0.003552 N/P SER.TASK SWTCH N/P N/P N/P COMMITS : 10
STORED PRC 0.000000 N/P UPDATE COMMIT N/P N/P N/P ROLLBACK : 0
UDF 0.000000 0.000000 OPEN/CLOSE N/P N/P N/P SVPT REQUESTS : 0
TRIGGER 0.000000 0.000000 SYSLGRNG REC N/P N/P N/P SVPT RELEASE : 0
PAR.TASKS 0.000000 N/P EXT/DEL/DEF N/P N/P N/P SVPT ROLLBACK : 0
OTHER SERVICE N/P N/P N/P INCREM.BINDS : N/P
SE CPU TIME 0.000000 0.000000 ARC.LOG(QUIES) N/P N/P N/P UPDATE/COMMIT : N/P
NONNESTED 0.000000 0.000000 LOG READ N/P N/P N/P SYNCH I/O AVG.: N/P
STORED PROC 0.000000 0.000000 DRAIN LOCK N/P N/P N/P PROGRAMS : 0
UDF 0.000000 0.000000 CLAIM RELEASE N/P N/P N/P MAX CASCADE : N/P
TRIGGER 0.000000 0.000000 PAGE LATCH N/P N/P N/P MAX WFILE BLKS: N/A
NOTIFY MSGS N/P N/P N/P
PAR.TASKS 0.000000 0.000000 GLOBAL CONTENTION N/P N/P N/P
COMMIT PH1 WRITE I/O N/P N/P N/P
SUSPEND TIME N/P N/P ASYNCH CF REQUESTS N/P N/P N/P
AGENT N/A N/P TCP/IP LOB XML N/P N/P N/P
PAR.TASKS N/A N/P ACCELERATOR N/P N/P N/P
STORED PROC N/P N/A AUTONOMOUS PROCEDURE N/P N/P N/P
UDF N/P N/A PQ SYNCHRONIZATION N/P N/P N/P
LOB COMPRESSION N/A N/A N/A
NOT ACCOUNT. N/A N/P FAST INSERT PIPE N/A N/A N/A
DB2 ENT/EXIT N/A N/P TOTAL CLASS 3 N/P N/P N/P
EN/EX-STPROC N/A N/P
EN/EX-UDF N/A N/P
DCAPT.DESCR. N/A N/A
LOG EXTRACT. N/A N/A
LOCATION: OMPDBEE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 3-7
GROUP: DBEE ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SEE1 TO: NOT SPECIFIED
SUBSYSTEM: SEE1 ACTUAL FROM: 08/24/16 08:16:02.78
DB2 VERSION: V11
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 08:16:02.92 PLANNAME: DSNUTIL WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 08:16:02.85 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : 08/24/16 08:16:02.92 PROD VER: N/P LUW LUN: IPUAPEE1 CICS INS: N/A
REQUESTER : OMPDBEE CORRNAME: MISIDC LUW INS: D13DD2D1D8E0
MAINPACK : DSNUTIL CORRNMBR: 'BLANK' LUW SEQ: 11 ENDUSER : MIS
PRIMAUTH : MIS CONNTYPE: UTILITY TRANSACT: MISIDC
ORIGAUTH : MIS CONNECT : UTILITY WSNAME : UTILITY
SQL DML TOTAL SQL DCL TOTAL SQL DDL CREATE DROP ALTER DYNAMIC SQL STMT TOTAL
-------- -------- ---------- -------- ---------- ------ ------ ------ -------------------- --------
SELECT N/P LOCK TABLE N/P TABLE N/P N/P N/P REOPTIMIZATION N/P
INSERT N/P GRANT N/P CRT TTABLE N/P N/A N/A NOT FOUND IN CACHE N/P
ROWS N/P REVOKE N/P DCL TTABLE N/P N/A N/A FOUND IN CACHE N/P
UPDATE N/P SET SQLID N/P AUX TABLE N/P N/A N/A IMPLICIT PREPARES N/P
ROWS N/P SET H.VAR. N/P INDEX N/P N/P N/P PREPARES AVOIDED N/P
MERGE N/P SET DEGREE N/P TABLESPACE N/P N/P N/P CACHE_LIMIT_EXCEEDED N/P
DELETE N/P SET RULES N/P DATABASE N/P N/P N/P PREP_STMT_PURGED N/P
ROWS N/P SET PATH N/P STOGROUP N/P N/P N/P STABILIZED PREPARE N/A
SET PREC. N/P SYNONYM N/P N/P N/A CSWL - STMTS PARSED N/P
DESCRIBE N/P CONNECT 1 N/P VIEW N/P N/P N/P CSWL - LITS REPLACED N/P
DESC.TBL N/P CONNECT 2 N/P ALIAS N/P N/P N/A CSWL - MATCHES FOUND N/P
PREPARE N/P SET CONNEC N/P PACKAGE N/A N/P N/A CSWL - DUPLS CREATED N/P
OPEN N/P RELEASE N/P PROCEDURE N/P N/P N/P
FETCH N/P CALL N/P FUNCTION N/P N/P N/P
ROWS N/P ASSOC LOC. N/P TRIGGER N/P N/P N/A
CLOSE N/P ALLOC CUR. N/P DIST TYPE N/P N/P N/A
HOLD LOC. N/P SEQUENCE N/P N/P N/P
DML-ALL N/P FREE LOC. N/P TRUST. CTX N/P N/P N/P
DCL-ALL N/P ROLE N/P N/P N/A
JAR N/A N/A N/P
MASK/PERM N/P N/P N/P
VARIABLE N/P N/P N/A
TOTAL N/P N/P N/P
TRUNC TBL N/P
RENAME TBL N/P
RENAME IX N/P
COMMENT ON N/P
LABEL ON N/P
LOCATION: OMPDBEE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 3-8
GROUP: DBEE ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SEE1 TO: NOT SPECIFIED
SUBSYSTEM: SEE1 ACTUAL FROM: 08/24/16 08:16:02.78
DB2 VERSION: V11
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 08:16:02.92 PLANNAME: DSNUTIL WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 08:16:02.85 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : 08/24/16 08:16:02.92 PROD VER: N/P LUW LUN: IPUAPEE1 CICS INS: N/A
REQUESTER : OMPDBEE CORRNAME: MISIDC LUW INS: D13DD2D1D8E0
MAINPACK : DSNUTIL CORRNMBR: 'BLANK' LUW SEQ: 11 ENDUSER : MIS
PRIMAUTH : MIS CONNTYPE: UTILITY TRANSACT: MISIDC
ORIGAUTH : MIS CONNECT : UTILITY WSNAME : UTILITY
MEASURED/ELIG TIMES APPL (CL1) DB2 (CL2) RID LIST TOTAL DATA CAPTURE TOTAL ROWID TOTAL
------------------- ---------- ---------- ---------------------- -------- ------------ -------- ---------- --------
ELAPSED TIME 0.075986 N/P USED N/P IFI CALLS N/P DIR ACCESS N/P
ELIGIBLE FOR ACCEL N/A 0.000000 REC.CAPTURED N/P INDEX USED N/P
FAIL-NO STORAGE N/P LOG REC.READ N/P TS SCAN N/P
CP CPU TIME 0.003552 N/P FAIL-LIMIT EXC. N/P ROWS RETURN N/P
ELIGIBLE FOR SECP 0.000000 N/A RECORDS RET. N/P
ELIGIBLE FOR ACCEL N/A 0.000000 INTERRUPTED-NO STORAGE N/P DATA DES.RET N/P
INTERRUPTED-LIMIT EXC. N/P TABLES RET. N/P
SE CPU TIME 0.000000 0.000000 DESCRIBES N/P
ELIGIBLE FOR ACCEL N/A 0.000000 OVERFLOWED-NO STORAGE N/P
OVERFLOWED-LIMIT EXC. N/P
SKIPPED-INDEX KNOWN N/P
GLOBAL CONTENTION L-LOCKS ELAPSED TIME EVENTS GLOBAL CONTENTION P-LOCKS ELAPSED TIME EVENTS
------------------------------------- ------------ -------- ------------------------------------- ------------ --------
L-LOCKS N/P N/P P-LOCKS N/P N/P
PARENT (DB,TS,TAB,PART) N/P N/P PAGESET/PARTITION N/P N/P
CHILD (PAGE,ROW) N/P N/P PAGE N/P N/P
OTHER N/P N/P OTHER N/P N/P
LOCKING TOTAL DATA SHARING TOTAL QUERY PARALLELISM TOTAL DRAIN/CLAIM TOTAL
------------------- -------- ------------ -------- ------------------------- -------- ------------ --------
TIMEOUTS 0 GLOB CONT(%) 0.00 MAXIMUM DEGREE-ESTIMATED N/P DRAIN REQST 0
DEADLOCKS 0 FALS CONT(%) 0.00 MAXIMUM DEGREE-PLANNED N/P DRAIN FAILED 0
ESCAL.(SHAR) 0 P/L-LOCKS(%) 77 MAXIMUM DEGREE-EXECUTED N/P CLAIM REQST 50
ESCAL.(EXCL) 0 P-LOCK REQ 6 MAXIMUM MEMBERS USED N/P CLAIM FAILED 0
MAX PG/ROW LCK HELD 11 P-UNLOCK REQ 5 PARALLEL GROUPS EXECUTED N/P
LOCK REQUEST 73 P-CHANGE REQ 0 RAN AS PLANNED N/P
UNLOCK REQST 50 LOCK - XES 61 RAN REDUCED-STORAGE N/P
QUERY REQST 0 UNLOCK-XES 37 RAN REDUCED-NEGOTIATION N/P
CHANGE REQST 7 CHANGE-XES 7 SEQ-CURSOR N/P
OTHER REQST 0 SUSP - IRLM 0 SEQ-NO ESA SORT N/P
TOTAL SUSPENSIONS 3 SUSP - XES 0 SEQ-NO BUFFER N/P
LOCK SUSPENS 0 CONV - XES 0 SEQ-AUTONOMOUS PROC N/P
IRLM LATCH SUSPENS 0 FALSE CONT 0 SEQ-NEGOTIATION N/P
OTHER SUSPENS 3 INCOMP.LOCK 0 ONE DB2-COORDINATOR = NO N/P
NOTIFY SENT 3 ONE DB2-ISOLATION LEVEL N/P
ONE DB2-DCL TTABLE N/P
MEMB SKIPPED(%) N/P
DISABLED BY RLF N/P
REFORM PARAL-CONFIG N/P
REFORM PARAL-NO BUF N/P
LOCATION: OMPDBEE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 3-9
GROUP: DBEE ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SEE1 TO: NOT SPECIFIED
SUBSYSTEM: SEE1 ACTUAL FROM: 08/24/16 08:16:02.78
DB2 VERSION: V11
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 08:16:02.92 PLANNAME: DSNUTIL WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 08:16:02.85 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : 08/24/16 08:16:02.92 PROD VER: N/P LUW LUN: IPUAPEE1 CICS INS: N/A
REQUESTER : OMPDBEE CORRNAME: MISIDC LUW INS: D13DD2D1D8E0
MAINPACK : DSNUTIL CORRNMBR: 'BLANK' LUW SEQ: 11 ENDUSER : MIS
PRIMAUTH : MIS CONNTYPE: UTILITY TRANSACT: MISIDC
ORIGAUTH : MIS CONNECT : UTILITY WSNAME : UTILITY
STORED PROC. TOTAL UDF TOTAL TRIGGERS TOTAL LOGGING TOTAL
------------ -------- --------- -------- ------------ -------- ----------------- --------
CALL STMTS N/P EXECUTED N/P STMT TRIGGER N/P LOG RECS WRITTEN 52
ABENDED N/P ABENDED N/P ROW TRIGGER N/P TOT BYTES WRITTEN 51582
TIMED OUT N/P TIMED OUT N/P SQL ERROR N/P
REJECTED N/P REJECTED N/P
TOTAL SU CLASS 1 CLASS 2 MISCELLANEOUS TOTAL
------------ -------------- -------------- -------------------- --------
CP CPU 230 N/P MAX STO LOB VAL (KB) N/P
AGENT 230 0 MAX STO XML VAL (KB) N/P
NONNESTED 230 0 ARRAY EXPANSIONS N/P
STORED PRC 0 N/P SPARSE IX DISABLED N/P
UDF 0 0 SPARSE IX BUILT WF N/P
TRIGGER N/P N/P
PAR.TASKS 0 N/P
ELIG SECP 0 N/A
ELIG ACCEL N/A 0
SE CPU 0 0
NONNESTED 0 0
STORED PROC 0 0
UDF 0 0
TRIGGER 0 0
PAR.TASKS 0 0
ELIG ACCEL N/A 0
---- RESOURCE LIMIT FACILITY --------------------------------------------------------------------------------------------------
TYPE: N/P TABLE ID: N/P SERV.UNITS: N/P CPU SECONDS: 0.000000 MAX CPU SEC: N/P
BP0 BPOOL ACTIVITY TOTAL BP32K BPOOL ACTIVITY TOTAL TOTAL BPOOL ACTIVITY TOTAL
--------------------- -------- --------------------- -------- --------------------- --------
BPOOL HIT RATIO (%) 100 BPOOL HIT RATIO (%) 100 BPOOL HIT RATIO (%) 100
GETPAGES 129 GETPAGES 13 GETPAGES 142
BUFFER UPDATES 3 BUFFER UPDATES 10 BUFFER UPDATES 13
SYNCHRONOUS WRITE 0 SYNCHRONOUS WRITE 0 SYNCHRONOUS WRITE 0
SYNCHRONOUS READ 0 SYNCHRONOUS READ 0 SYNCHRONOUS READ 0
SEQ. PREFETCH REQS 0 SEQ. PREFETCH REQS 0 SEQ. PREFETCH REQS 0
LIST PREFETCH REQS 7 LIST PREFETCH REQS 0 LIST PREFETCH REQS 7
DYN. PREFETCH REQS 0 DYN. PREFETCH REQS 0 DYN. PREFETCH REQS 0
PAGES READ ASYNCHR. 0 PAGES READ ASYNCHR. 0 PAGES READ ASYNCHR. 0
LOCATION: OMPDBEE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 3-10
GROUP: DBEE ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SEE1 TO: NOT SPECIFIED
SUBSYSTEM: SEE1 ACTUAL FROM: 08/24/16 08:16:02.78
DB2 VERSION: V11
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 08:16:02.92 PLANNAME: DSNUTIL WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 08:16:02.85 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : 08/24/16 08:16:02.92 PROD VER: N/P LUW LUN: IPUAPEE1 CICS INS: N/A
REQUESTER : OMPDBEE CORRNAME: MISIDC LUW INS: D13DD2D1D8E0
MAINPACK : DSNUTIL CORRNMBR: 'BLANK' LUW SEQ: 11 ENDUSER : MIS
PRIMAUTH : MIS CONNTYPE: UTILITY TRANSACT: MISIDC
ORIGAUTH : MIS CONNECT : UTILITY WSNAME : UTILITY
GROUP BP0 TOTAL GROUP BP32K TOTAL GROUP TOTAL TOTAL
--------------------- -------- --------------------- -------- --------------------- --------
GBP-DEPEND GETPAGES 107 GBP-DEPEND GETPAGES 13 GBP-DEPEND GETPAGES 120
READ(XI)-DATA RETUR 0 READ(XI)-DATA RETUR 0 READ(XI)-DATA RETUR 0
READ(XI)-NO DATA RT 0 READ(XI)-NO DATA RT 0 READ(XI)-NO DATA RT 0
READ(NF)-DATA RETUR 0 READ(NF)-DATA RETUR 0 READ(NF)-DATA RETUR 0
READ(NF)-NO DATA RT 0 READ(NF)-NO DATA RT 0 READ(NF)-NO DATA RT 0
PREFETCH PAGES READ 0 PREFETCH PAGES READ 0 PREFETCH PAGES READ 0
CLEAN PAGES WRITTEN 0 CLEAN PAGES WRITTEN 0 CLEAN PAGES WRITTEN 0
UNREGISTER PAGE 0 UNREGISTER PAGE 0 UNREGISTER PAGE 0
ASYNCH GBP REQUESTS 0 ASYNCH GBP REQUESTS 5 ASYNCH GBP REQUESTS 5
EXPLICIT X-INVALID 0 EXPLICIT X-INVALID 0 EXPLICIT X-INVALID 0
ASYNCH SEC-GBP REQ 0 ASYNCH SEC-GBP REQ 0 ASYNCH SEC-GBP REQ 0
PG P-LOCK LOCK REQ 2 PG P-LOCK LOCK REQ 2 PG P-LOCK LOCK REQ 4
SPACE MAP PAGES 0 SPACE MAP PAGES 2 SPACE MAP PAGES 2
DATA PAGES 0 DATA PAGES 0 DATA PAGES 0
INDEX LEAF PAGES 2 INDEX LEAF PAGES 0 INDEX LEAF PAGES 2
PG P-LOCK UNLOCK REQ 2 PG P-LOCK UNLOCK REQ 2 PG P-LOCK UNLOCK REQ 4
PG P-LOCK LOCK SUSP 0 PG P-LOCK LOCK SUSP 0 PG P-LOCK LOCK SUSP 0
SPACE MAP PAGES 0 SPACE MAP PAGES 0 SPACE MAP PAGES 0
DATA PAGES 0 DATA PAGES 0 DATA PAGES 0
INDEX LEAF PAGES 0 INDEX LEAF PAGES 0 INDEX LEAF PAGES 0
WRITE AND REGISTER 3 WRITE AND REGISTER 5 WRITE AND REGISTER 8
WRITE & REGISTER MULT 0 WRITE & REGISTER MULT 0 WRITE & REGISTER MULT 0
CHANGED PAGES WRITTEN 3 CHANGED PAGES WRITTEN 5 CHANGED PAGES WRITTEN 8
COMPL CHECKS SUSPEND 0 COMPL CHECKS SUSPEND 0 COMPL CHECKS SUSPEND 0
TIMES CLASS 5 IFI (CL.5)
------------- ----------
ELAPSED TIME N/P
CP CPU TIME N/P
DCAPT.DESCR. N/P
LOG EXTRACT. N/P
LOCATION: OMPDBEE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 3-11
GROUP: DBEE ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SEE1 TO: NOT SPECIFIED
SUBSYSTEM: SEE1 ACTUAL FROM: 08/24/16 08:16:02.78
DB2 VERSION: V11
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 09:16:33.11 PLANNAME: KO2PLAN WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 09:10:12.37 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : N/P PROD VER: N/P LUW LUN: IPUAPEE1 CICS INS: N/A
REQUESTER : OMPDBEE CORRNAME: 'BLANK' LUW INS: D13DE057D9BB
MAINPACK : KO2PLAN CORRNMBR: 'BLANK' LUW SEQ: 3 ENDUSER : DB2PM
PRIMAUTH : DB2PM CONNTYPE: RRS TRANSACT: 'BLANK'
ORIGAUTH : DB2PM CONNECT : RRSAF WSNAME : RRSAF
MVS ACCOUNTING DATA : 'BLANK'
ACCOUNTING TOKEN(CHAR): 'BLANK'
ACCOUNTING TOKEN(HEX) : 00000000000000000000000000000000000000000000
ELAPSED TIME DISTRIBUTION CLASS 2 TIME DISTRIBUTION
---------------------------------------------------------------- ----------------------------------------------------------------
APPL !=================> 34% CPU !===> 7%
DB2 !==========================> 53% SECPU !
SUSP !======> 13% NOTACC !=====================================> 74%
SUSP !=========> 19%
LOCATION: OMPDBEE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 3-12
GROUP: DBEE ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SEE1 TO: NOT SPECIFIED
SUBSYSTEM: SEE1 ACTUAL FROM: 08/24/16 08:16:02.78
DB2 VERSION: V11
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 09:16:33.11 PLANNAME: KO2PLAN WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 09:10:12.37 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : N/P PROD VER: N/P LUW LUN: IPUAPEE1 CICS INS: N/A
REQUESTER : OMPDBEE CORRNAME: 'BLANK' LUW INS: D13DE057D9BB
MAINPACK : KO2PLAN CORRNMBR: 'BLANK' LUW SEQ: 3 ENDUSER : DB2PM
PRIMAUTH : DB2PM CONNTYPE: RRS TRANSACT: 'BLANK'
ORIGAUTH : DB2PM CONNECT : RRSAF WSNAME : RRSAF
TIMES/EVENTS APPL(CL.1) DB2 (CL.2) CLASS 3 SUSPENSIONS ELAPSED TIME EVENTS TIME/EVENT HIGHLIGHTS
------------ ---------- ---------- -------------------- ------------ -------- ---------- --------------------------
ELAPSED TIME 0.171472 0.113032 LOCK/LATCH(DB2+IRLM) 0.000000 0 N/C THREAD TYPE : ALLIED
NONNESTED 0.171472 0.113032 IRLM LOCK+LATCH 0.000000 0 N/C TERM.CONDITION: NORMAL
STORED PROC 0.000000 0.000000 DB2 LATCH 0.000000 0 N/C INVOKE REASON : END USER
UDF 0.000000 0.000000 SYNCHRON. I/O 0.000000 0 N/C PARALLELISM : N/A
TRIGGER 0.000000 0.000000 DATABASE I/O 0.000000 0 N/C PCA RUP COUNT : 0
LOG WRITE I/O 0.000000 0 N/C RUP AUTONOM.PR: 0
CP CPU TIME 0.010277 0.007403 OTHER READ I/O 0.000000 0 N/C AUTONOMOUS PR : 0
AGENT 0.010277 0.007403 OTHER WRTE I/O 0.000000 0 N/C QUANTITY : 10
NONNESTED 0.010277 0.007403 SER.TASK SWTCH 0.016517 8 0.002065 COMMITS : 16
STORED PRC 0.000000 0.000000 UPDATE COMMIT 0.001120 2 0.000560 ROLLBACK : 0
UDF 0.000000 0.000000 OPEN/CLOSE 0.000000 0 N/C SVPT REQUESTS : 0
TRIGGER 0.000000 0.000000 SYSLGRNG REC 0.000000 0 N/C SVPT RELEASE : 0
PAR.TASKS 0.000000 0.000000 EXT/DEL/DEF 0.000000 0 N/C SVPT ROLLBACK : 0
OTHER SERVICE 0.015397 6 0.002566 INCREM.BINDS : 0
SE CPU TIME 0.000000 0.000000 ARC.LOG(QUIES) 0.000000 0 N/C UPDATE/COMMIT : 0.19
NONNESTED 0.000000 0.000000 LOG READ 0.000000 0 N/C SYNCH I/O AVG.: N/C
STORED PROC 0.000000 0.000000 DRAIN LOCK 0.000000 0 N/C PROGRAMS : 1
UDF 0.000000 0.000000 CLAIM RELEASE 0.000000 0 N/C MAX CASCADE : 0
TRIGGER 0.000000 0.000000 PAGE LATCH 0.000000 0 N/C MAX WFILE BLKS: N/A
NOTIFY MSGS 0.005074 2 0.002537
PAR.TASKS 0.000000 0.000000 GLOBAL CONTENTION 0.000000 0 N/C
COMMIT PH1 WRITE I/O 0.000000 0 N/C
SUSPEND TIME 0.000000 0.021591 ASYNCH CF REQUESTS 0.000000 0 N/C
AGENT N/A 0.021591 TCP/IP LOB XML 0.000000 0 N/C
PAR.TASKS N/A 0.000000 ACCELERATOR 0.000000 0 N/C
STORED PROC 0.000000 N/A AUTONOMOUS PROCEDURE 0.000000 0 N/C
UDF 0.000000 N/A PQ SYNCHRONIZATION 0.000000 0 N/C
LOB COMPRESSION N/A N/A N/A
NOT ACCOUNT. N/A 0.084038 FAST INSERT PIPE N/A N/A N/A
DB2 ENT/EXIT N/A 108 TOTAL CLASS 3 0.021591 10 0.002159
EN/EX-STPROC N/A 0
EN/EX-UDF N/A 0
DCAPT.DESCR. N/A N/A
LOG EXTRACT. N/A N/A
LOCATION: OMPDBEE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 3-13
GROUP: DBEE ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SEE1 TO: NOT SPECIFIED
SUBSYSTEM: SEE1 ACTUAL FROM: 08/24/16 08:16:02.78
DB2 VERSION: V11
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 09:16:33.11 PLANNAME: KO2PLAN WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 09:10:12.37 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : N/P PROD VER: N/P LUW LUN: IPUAPEE1 CICS INS: N/A
REQUESTER : OMPDBEE CORRNAME: 'BLANK' LUW INS: D13DE057D9BB
MAINPACK : KO2PLAN CORRNMBR: 'BLANK' LUW SEQ: 3 ENDUSER : DB2PM
PRIMAUTH : DB2PM CONNTYPE: RRS TRANSACT: 'BLANK'
ORIGAUTH : DB2PM CONNECT : RRSAF WSNAME : RRSAF
SQL DML TOTAL SQL DCL TOTAL SQL DDL CREATE DROP ALTER DYNAMIC SQL STMT TOTAL
-------- -------- ---------- -------- ---------- ------ ------ ------ -------------------- --------
SELECT 2 LOCK TABLE 1 TABLE 0 0 0 REOPTIMIZATION 0
INSERT 2 GRANT 0 CRT TTABLE 0 N/A N/A NOT FOUND IN CACHE 3
ROWS 2 REVOKE 0 DCL TTABLE 0 N/A N/A FOUND IN CACHE 11
UPDATE 1 SET SQLID 0 AUX TABLE 0 N/A N/A IMPLICIT PREPARES 0
ROWS 0 SET H.VAR. 0 INDEX 0 0 0 PREPARES AVOIDED 0
MERGE 0 SET DEGREE 0 TABLESPACE 0 0 0 CACHE_LIMIT_EXCEEDED 0
DELETE 0 SET RULES 0 DATABASE 0 0 0 PREP_STMT_PURGED 0
ROWS 0 SET PATH 0 STOGROUP 0 0 0 STABILIZED PREPARE N/A
SET PREC. 0 SYNONYM 0 0 N/A CSWL - STMTS PARSED 0
DESCRIBE 0 CONNECT 1 0 VIEW 0 0 0 CSWL - LITS REPLACED 0
DESC.TBL 0 CONNECT 2 0 ALIAS 0 0 N/A CSWL - MATCHES FOUND 0
PREPARE 15 SET CONNEC 0 PACKAGE N/A 0 N/A CSWL - DUPLS CREATED 0
OPEN 11 RELEASE 0 PROCEDURE 0 0 0
FETCH 11 CALL 0 FUNCTION 0 0 0
ROWS 10 ASSOC LOC. 0 TRIGGER 0 0 N/A
CLOSE 11 ALLOC CUR. 0 DIST TYPE 0 0 N/A
HOLD LOC. 0 SEQUENCE 0 0 0
DML-ALL 53 FREE LOC. 0 TRUST. CTX 0 0 0
DCL-ALL 1 ROLE 0 0 N/A
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
LOCATION: OMPDBEE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 3-14
GROUP: DBEE ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SEE1 TO: NOT SPECIFIED
SUBSYSTEM: SEE1 ACTUAL FROM: 08/24/16 08:16:02.78
DB2 VERSION: V11
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 09:16:33.11 PLANNAME: KO2PLAN WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 09:10:12.37 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : N/P PROD VER: N/P LUW LUN: IPUAPEE1 CICS INS: N/A
REQUESTER : OMPDBEE CORRNAME: 'BLANK' LUW INS: D13DE057D9BB
MAINPACK : KO2PLAN CORRNMBR: 'BLANK' LUW SEQ: 3 ENDUSER : DB2PM
PRIMAUTH : DB2PM CONNTYPE: RRS TRANSACT: 'BLANK'
ORIGAUTH : DB2PM CONNECT : RRSAF WSNAME : RRSAF
MEASURED/ELIG TIMES APPL (CL1) DB2 (CL2) RID LIST TOTAL DATA CAPTURE TOTAL ROWID TOTAL
------------------- ---------- ---------- ---------------------- -------- ------------ -------- ---------- --------
ELAPSED TIME 0.171472 0.113032 USED 0 IFI CALLS 0 DIR ACCESS 0
ELIGIBLE FOR ACCEL N/A 0.000000 REC.CAPTURED 0 INDEX USED 0
FAIL-NO STORAGE 0 LOG REC.READ 0 TS SCAN 0
CP CPU TIME 0.010277 0.007403 FAIL-LIMIT EXC. 0 ROWS RETURN 0
ELIGIBLE FOR SECP 0.000000 N/A RECORDS RET. 0
ELIGIBLE FOR ACCEL N/A 0.000000 INTERRUPTED-NO STORAGE 0 DATA DES.RET 0
INTERRUPTED-LIMIT EXC. 0 TABLES RET. 0
SE CPU TIME 0.000000 0.000000 DESCRIBES 0
ELIGIBLE FOR ACCEL N/A 0.000000 OVERFLOWED-NO STORAGE 0
OVERFLOWED-LIMIT EXC. 0
SKIPPED-INDEX KNOWN 0
GLOBAL CONTENTION L-LOCKS ELAPSED TIME EVENTS GLOBAL CONTENTION P-LOCKS ELAPSED TIME EVENTS
------------------------------------- ------------ -------- ------------------------------------- ------------ --------
L-LOCKS 0.000000 0 P-LOCKS 0.000000 0
PARENT (DB,TS,TAB,PART) 0.000000 0 PAGESET/PARTITION 0.000000 0
CHILD (PAGE,ROW) 0.000000 0 PAGE 0.000000 0
OTHER 0.000000 0 OTHER 0.000000 0
LOCKING TOTAL DATA SHARING TOTAL QUERY PARALLELISM TOTAL DRAIN/CLAIM TOTAL
------------------- -------- ------------ -------- ------------------------- -------- ------------ --------
TIMEOUTS 0 GLOB CONT(%) 0.00 MAXIMUM DEGREE-ESTIMATED 0 DRAIN REQST 0
DEADLOCKS 0 FALS CONT(%) 0.00 MAXIMUM DEGREE-PLANNED 0 DRAIN FAILED 0
ESCAL.(SHAR) 0 P/L-LOCKS(%) 40 MAXIMUM DEGREE-EXECUTED 0 CLAIM REQST 55
ESCAL.(EXCL) 0 P-LOCK REQ 12 MAXIMUM MEMBERS USED N/P CLAIM FAILED 0
MAX PG/ROW LCK HELD 1 P-UNLOCK REQ 11 PARALLEL GROUPS EXECUTED 0
LOCK REQUEST 76 P-CHANGE REQ 0 RAN AS PLANNED 0
UNLOCK REQST 28 LOCK - XES 36 RAN REDUCED-STORAGE 0
QUERY REQST 0 UNLOCK-XES 17 RAN REDUCED-NEGOTIATION 0
CHANGE REQST 5 CHANGE-XES 0 SEQ-CURSOR 0
OTHER REQST 0 SUSP - IRLM 0 SEQ-NO ESA SORT 0
TOTAL SUSPENSIONS 2 SUSP - XES 0 SEQ-NO BUFFER 0
LOCK SUSPENS 0 CONV - XES 0 SEQ-AUTONOMOUS PROC 0
IRLM LATCH SUSPENS 0 FALSE CONT 0 SEQ-NEGOTIATION 0
OTHER SUSPENS 2 INCOMP.LOCK 0 ONE DB2-COORDINATOR = NO 0
NOTIFY SENT 2 ONE DB2-ISOLATION LEVEL 0
ONE DB2-DCL TTABLE 0
MEMB SKIPPED(%) 0
DISABLED BY RLF NO
REFORM PARAL-CONFIG 0
REFORM PARAL-NO BUF 0
LOCATION: OMPDBEE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 3-15
GROUP: DBEE ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SEE1 TO: NOT SPECIFIED
SUBSYSTEM: SEE1 ACTUAL FROM: 08/24/16 08:16:02.78
DB2 VERSION: V11
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 09:16:33.11 PLANNAME: KO2PLAN WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 09:10:12.37 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : N/P PROD VER: N/P LUW LUN: IPUAPEE1 CICS INS: N/A
REQUESTER : OMPDBEE CORRNAME: 'BLANK' LUW INS: D13DE057D9BB
MAINPACK : KO2PLAN CORRNMBR: 'BLANK' LUW SEQ: 3 ENDUSER : DB2PM
PRIMAUTH : DB2PM CONNTYPE: RRS TRANSACT: 'BLANK'
ORIGAUTH : DB2PM CONNECT : RRSAF WSNAME : RRSAF
STORED PROC. TOTAL UDF TOTAL TRIGGERS TOTAL LOGGING TOTAL
------------ -------- --------- -------- ------------ -------- ----------------- --------
CALL STMTS 0 EXECUTED 0 STMT TRIGGER 0 LOG RECS WRITTEN 7
ABENDED 0 ABENDED 0 ROW TRIGGER 0 TOT BYTES WRITTEN 948
TIMED OUT 0 TIMED OUT 0 SQL ERROR 0
REJECTED 0 REJECTED 0
TOTAL SU CLASS 1 CLASS 2 MISCELLANEOUS TOTAL
------------ -------------- -------------- -------------------- --------
CP CPU 665 479 MAX STO LOB VAL (KB) 0
AGENT 665 479 MAX STO XML VAL (KB) 0
NONNESTED 665 479 ARRAY EXPANSIONS 0
STORED PRC 0 0 SPARSE IX DISABLED 0
UDF 0 0 SPARSE IX BUILT WF 0
TRIGGER 0 0
PAR.TASKS 0 0
ELIG SECP 0 N/A
ELIG ACCEL N/A 0
SE CPU 0 0
NONNESTED 0 0
STORED PROC 0 0
UDF 0 0
TRIGGER 0 0
PAR.TASKS 0 0
ELIG ACCEL N/A 0
---- RESOURCE LIMIT FACILITY --------------------------------------------------------------------------------------------------
TYPE: N/P TABLE ID: N/P SERV.UNITS: N/P CPU SECONDS: N/P MAX CPU SEC: N/P
BP0 BPOOL ACTIVITY TOTAL BP32K BPOOL ACTIVITY TOTAL BP8K BPOOL ACTIVITY TOTAL
--------------------- -------- --------------------- -------- --------------------- --------
BPOOL HIT RATIO (%) 100 BPOOL HIT RATIO (%) 89 BPOOL HIT RATIO (%) 100
GETPAGES 102 GETPAGES 9 GETPAGES 5
BUFFER UPDATES 2 BUFFER UPDATES 0 BUFFER UPDATES 0
SYNCHRONOUS WRITE 0 SYNCHRONOUS WRITE 0 SYNCHRONOUS WRITE 0
SYNCHRONOUS READ 0 SYNCHRONOUS READ 1 SYNCHRONOUS READ 0
SEQ. PREFETCH REQS 0 SEQ. PREFETCH REQS 0 SEQ. PREFETCH REQS 0
LIST PREFETCH REQS 0 LIST PREFETCH REQS 0 LIST PREFETCH REQS 0
DYN. PREFETCH REQS 0 DYN. PREFETCH REQS 0 DYN. PREFETCH REQS 0
PAGES READ ASYNCHR. 0 PAGES READ ASYNCHR. 0 PAGES READ ASYNCHR. 0
LOCATION: OMPDBEE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 3-16
GROUP: DBEE ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SEE1 TO: NOT SPECIFIED
SUBSYSTEM: SEE1 ACTUAL FROM: 08/24/16 08:16:02.78
DB2 VERSION: V11
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 09:16:33.11 PLANNAME: KO2PLAN WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 09:10:12.37 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : N/P PROD VER: N/P LUW LUN: IPUAPEE1 CICS INS: N/A
REQUESTER : OMPDBEE CORRNAME: 'BLANK' LUW INS: D13DE057D9BB
MAINPACK : KO2PLAN CORRNMBR: 'BLANK' LUW SEQ: 3 ENDUSER : DB2PM
PRIMAUTH : DB2PM CONNTYPE: RRS TRANSACT: 'BLANK'
ORIGAUTH : DB2PM CONNECT : RRSAF WSNAME : RRSAF
TOTAL BPOOL ACTIVITY TOTAL
--------------------- --------
BPOOL HIT RATIO (%) 99
GETPAGES 116
BUFFER UPDATES 2
SYNCHRONOUS WRITE 0
SYNCHRONOUS READ 1
SEQ. PREFETCH REQS 0
LIST PREFETCH REQS 0
DYN. PREFETCH REQS 0
PAGES READ ASYNCHR. 0
GROUP BP0 TOTAL GROUP BP32K TOTAL GROUP TOTAL TOTAL
--------------------- -------- --------------------- -------- --------------------- --------
GBP-DEPEND GETPAGES 20 GBP-DEPEND GETPAGES 8 GBP-DEPEND GETPAGES 28
READ(XI)-DATA RETUR 2 READ(XI)-DATA RETUR 0 READ(XI)-DATA RETUR 2
READ(XI)-NO DATA RT 0 READ(XI)-NO DATA RT 0 READ(XI)-NO DATA RT 0
READ(NF)-DATA RETUR 0 READ(NF)-DATA RETUR 0 READ(NF)-DATA RETUR 0
READ(NF)-NO DATA RT 0 READ(NF)-NO DATA RT 0 READ(NF)-NO DATA RT 0
PREFETCH PAGES READ 0 PREFETCH PAGES READ 0 PREFETCH PAGES READ 0
CLEAN PAGES WRITTEN 0 CLEAN PAGES WRITTEN 0 CLEAN PAGES WRITTEN 0
UNREGISTER PAGE 0 UNREGISTER PAGE 0 UNREGISTER PAGE 0
ASYNCH GBP REQUESTS 0 ASYNCH GBP REQUESTS 0 ASYNCH GBP REQUESTS 0
EXPLICIT X-INVALID 0 EXPLICIT X-INVALID 0 EXPLICIT X-INVALID 0
ASYNCH SEC-GBP REQ 0 ASYNCH SEC-GBP REQ 0 ASYNCH SEC-GBP REQ 0
PG P-LOCK LOCK REQ 7 PG P-LOCK LOCK REQ 4 PG P-LOCK LOCK REQ 11
SPACE MAP PAGES 7 SPACE MAP PAGES 4 SPACE MAP PAGES 11
DATA PAGES 0 DATA PAGES 0 DATA PAGES 0
INDEX LEAF PAGES 0 INDEX LEAF PAGES 0 INDEX LEAF PAGES 0
PG P-LOCK UNLOCK REQ 7 PG P-LOCK UNLOCK REQ 4 PG P-LOCK UNLOCK REQ 11
PG P-LOCK LOCK SUSP 0 PG P-LOCK LOCK SUSP 0 PG P-LOCK LOCK SUSP 0
SPACE MAP PAGES 0 SPACE MAP PAGES 0 SPACE MAP PAGES 0
DATA PAGES 0 DATA PAGES 0 DATA PAGES 0
INDEX LEAF PAGES 0 INDEX LEAF PAGES 0 INDEX LEAF PAGES 0
WRITE AND REGISTER 1 WRITE AND REGISTER 0 WRITE AND REGISTER 1
WRITE & REGISTER MULT 0 WRITE & REGISTER MULT 0 WRITE & REGISTER MULT 0
CHANGED PAGES WRITTEN 1 CHANGED PAGES WRITTEN 0 CHANGED PAGES WRITTEN 1
COMPL CHECKS SUSPEND 0 COMPL CHECKS SUSPEND 0 COMPL CHECKS SUSPEND 0
LOCATION: OMPDBEE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 3-17
GROUP: DBEE ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SEE1 TO: NOT SPECIFIED
SUBSYSTEM: SEE1 ACTUAL FROM: 08/24/16 08:16:02.78
DB2 VERSION: V11
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 09:16:33.11 PLANNAME: KO2PLAN WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 09:10:12.37 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : N/P PROD VER: N/P LUW LUN: IPUAPEE1 CICS INS: N/A
REQUESTER : OMPDBEE CORRNAME: 'BLANK' LUW INS: D13DE057D9BB
MAINPACK : KO2PLAN CORRNMBR: 'BLANK' LUW SEQ: 3 ENDUSER : DB2PM
PRIMAUTH : DB2PM CONNTYPE: RRS TRANSACT: 'BLANK'
ORIGAUTH : DB2PM CONNECT : RRSAF WSNAME : RRSAF
FPEVWRP2 VALUE FPEVWRP2 TIMES FPEVWRP2 TIME EVENTS TIME/EVENT
------------------ ------------------ ------------------ ------------ ------------------ ------------ ------ ------------
TYPE PACKAGE ELAPSED TIME - CL7 0.096422 LOCK/LATCH 0.000000 0 N/C
LOCATION OMPDBEE CP CPU TIME 0.006444 IRLM LOCK+LATCH 0.000000 0 N/C
COLLECTION ID KO2OM530 AGENT 0.006444 DB2 LATCH 0.000000 0 N/C
PROGRAM NAME FPEVWRP2 PAR.TASKS 0.000000 SYNCHRONOUS I/O 0.000000 0 N/C
CONSISTENCY TOKEN 1A20F0C107FBA51D SE CPU TIME 0.000000 OTHER READ I/O 0.000000 0 N/C
ACTIVITY TYPE NONNESTED SUSPENSION-CL8 0.006194 OTHER WRITE I/O 0.000000 0 N/C
ACTIVITY NAME 'BLANK' AGENT 0.006194 SERV.TASK SWITCH 0.001120 2 0.000560
SCHEMA NAME 'BLANK' PAR.TASKS 0.000000 ARCH.LOG(QUIESCE) 0.000000 0 N/C
SUCC AUTH CHECK N/P NOT ACCOUNTED 0.083785 ARCHIVE LOG READ 0.000000 0 N/C
NBR OF ALLOCATIONS 2 DRAIN LOCK 0.000000 0 N/C
SQL STMT - AVERAGE 16.00 CP CPU SU 417 CLAIM RELEASE 0.000000 0 N/C
SQL STMT - TOTAL 32 AGENT 417 PAGE LATCH 0.000000 0 N/C
NBR RLUP THREADS 2 PAR.TASKS 0 NOTIFY MESSAGES 0.005074 2 0.002537
SE CPU SU 0 GLOBAL CONTENTION 0.000000 0 N/C
TCP/IP LOB XML 0.000000 0 N/C
DB2 ENTRY/EXIT 86 ACCELERATOR 0.000000 0 N/C
PQ SYNCHRONIZATION 0.000000 0 N/C
FAST INSERT PIPE N/A N/A N/A
TOTAL CL8 SUSPENS. 0.006194 4 0.001548
FPEVWRP2 ELAPSED TIME EVENTS FPEVWRP2 ELAPSED TIME EVENTS
------------------------- ------------ -------- ------------------------- ------------ --------
GLOBAL CONTENTION L-LOCKS 0.000000 0 GLOBAL CONTENTION P-LOCKS 0.000000 0
PARENT (DB,TS,TAB,PART) 0.000000 0 PAGESET/PARTITION 0.000000 0
CHILD (PAGE,ROW) 0.000000 0 PAGE 0.000000 0
OTHER 0.000000 0 OTHER 0.000000 0
FPEVWRP2 TOTAL
------------------ --------
SELECT 0
INSERT 2
UPDATE 1
DELETE 0
DESCRIBE 0
PREPARE 10
OPEN 6
FETCH 6
CLOSE 6
LOCK TABLE 1
CALL 0
LOCATION: OMPDBEE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 3-18
GROUP: DBEE ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SEE1 TO: NOT SPECIFIED
SUBSYSTEM: SEE1 ACTUAL FROM: 08/24/16 08:16:02.78
DB2 VERSION: V11
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 09:16:33.11 PLANNAME: KO2PLAN WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 09:10:12.37 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : N/P PROD VER: N/P LUW LUN: IPUAPEE1 CICS INS: N/A
REQUESTER : OMPDBEE CORRNAME: 'BLANK' LUW INS: D13DE057D9BB
MAINPACK : KO2PLAN CORRNMBR: 'BLANK' LUW SEQ: 3 ENDUSER : DB2PM
PRIMAUTH : DB2PM CONNTYPE: RRS TRANSACT: 'BLANK'
ORIGAUTH : DB2PM CONNECT : RRSAF WSNAME : RRSAF
FPEVWRP2 TOTAL
------------------- --------
BPOOL HIT RATIO (%) 100
GETPAGES 92
BUFFER UPDATES 2
SYNCHRONOUS WRITE 0
SYNCHRONOUS READ 0
SEQ. PREFETCH REQS 0
LIST PREFETCH REQS 0
DYN. PREFETCH REQS 0
PAGES READ ASYNCHR. 0
FPEVWRP2 TOTAL
--------------------- --------
TIMEOUTS 0
DEADLOCKS 0
ESCAL.(SHARED) 0
ESCAL.(EXCLUS) 0
MAX PG/ROW LOCKS HELD 0
LOCK REQUEST 60
UNLOCK REQUEST 19
QUERY REQUEST 0
CHANGE REQUEST 5
OTHER REQUEST 0
TOTAL SUSPENSIONS 2
LOCK SUSPENS 0
IRLM LATCH SUSPENS 0
OTHER SUSPENS 2
TIMES CLASS 5 IFI (CL.5)
------------- ----------
ELAPSED TIME 0.000000
CP CPU TIME 0.000000
DCAPT.DESCR. 0.000000
LOG EXTRACT. 0.000000
LOCATION: OMPDBEE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 3-19
GROUP: DBEE ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SEE1 TO: NOT SPECIFIED
SUBSYSTEM: SEE1 ACTUAL FROM: 08/24/16 08:16:02.78
DB2 VERSION: V11
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 09:28:00.00 PLANNAME: 'BLANK' WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 09:10:12.47 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : N/P PROD VER: N/P LUW LUN: IPUAPEE1 CICS INS: N/A
REQUESTER : OMPDBEE CORRNAME: LUW INS: D13DDEECF7B0
MAINPACK : 'BLANK' CORRNMBR: LUW SEQ: 1 ENDUSER : DB2PM
PRIMAUTH : DB2PM CONNTYPE: RRS TRANSACT: 'BLANK'
ORIGAUTH : DB2PM CONNECT : RRSAF WSNAME : RRSAF
MVS ACCOUNTING DATA : 'BLANK'
ACCOUNTING TOKEN(CHAR): 'BLANK'
ACCOUNTING TOKEN(HEX) : 00000000000000000000000000000000000000000000
ELAPSED TIME DISTRIBUTION CLASS 2 TIME DISTRIBUTION
---------------------------------------------------------------- ----------------------------------------------------------------
APPL !==================================================> 100% CPU !===> 6%
DB2 ! SECPU !
SUSP ! NOTACC !=> 3%
SUSP !=============================================> 91%
LOCATION: OMPDBEE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 3-20
GROUP: DBEE ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SEE1 TO: NOT SPECIFIED
SUBSYSTEM: SEE1 ACTUAL FROM: 08/24/16 08:16:02.78
DB2 VERSION: V11
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 09:28:00.00 PLANNAME: 'BLANK' WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 09:10:12.47 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : N/P PROD VER: N/P LUW LUN: IPUAPEE1 CICS INS: N/A
REQUESTER : OMPDBEE CORRNAME: LUW INS: D13DDEECF7B0
MAINPACK : 'BLANK' CORRNMBR: LUW SEQ: 1 ENDUSER : DB2PM
PRIMAUTH : DB2PM CONNTYPE: RRS TRANSACT: 'BLANK'
ORIGAUTH : DB2PM CONNECT : RRSAF WSNAME : RRSAF
TIMES/EVENTS APPL(CL.1) DB2 (CL.2) CLASS 3 SUSPENSIONS ELAPSED TIME EVENTS TIME/EVENT HIGHLIGHTS
------------ ---------- ---------- -------------------- ------------ -------- ---------- --------------------------
ELAPSED TIME 47:31.0901 2.419360 LOCK/LATCH(DB2+IRLM) 0.000000 0 N/C THREAD TYPE : ALLIED
NONNESTED 47:31.0901 2.419352 IRLM LOCK+LATCH 0.000000 0 N/C TERM.CONDITION: NORMAL
STORED PROC 0.000000 0.000000 DB2 LATCH 0.000000 0 N/C INVOKE REASON : STALENESS
UDF 0.000000 0.000000 SYNCHRON. I/O 0.001744 6 0.000291 PARALLELISM : N/A
TRIGGER 0.000009 0.000009 DATABASE I/O 0.001744 6 0.000291 PCA RUP COUNT : 0
LOG WRITE I/O 0.000000 0 N/C RUP AUTONOM.PR: 0
CP CPU TIME 0.366568 0.147791 OTHER READ I/O 0.000000 0 N/C AUTONOMOUS PR : 0
AGENT 0.366568 0.147791 OTHER WRTE I/O 0.000000 0 N/C QUANTITY : 9
NONNESTED 0.366559 0.147782 SER.TASK SWTCH 0.024953 159 0.000157 COMMITS : 500
STORED PRC 0.000000 0.000000 UPDATE COMMIT 0.003726 122 0.000031 ROLLBACK : 1
UDF 0.000000 0.000000 OPEN/CLOSE 0.000000 0 N/C SVPT REQUESTS : 0
TRIGGER 0.000009 0.000009 SYSLGRNG REC 0.000000 0 N/C SVPT RELEASE : 0
PAR.TASKS 0.000000 0.000000 EXT/DEL/DEF 0.000000 0 N/C SVPT ROLLBACK : 0
OTHER SERVICE 0.021226 37 0.000574 INCREM.BINDS : 0
SE CPU TIME 0.000000 0.000000 ARC.LOG(QUIES) 0.000000 0 N/C UPDATE/COMMIT : 0.16
NONNESTED 0.000000 0.000000 LOG READ 0.000000 0 N/C SYNCH I/O AVG.: 0.000291
STORED PROC 0.000000 0.000000 DRAIN LOCK 0.000000 0 N/C PROGRAMS : 5
UDF 0.000000 0.000000 CLAIM RELEASE 0.000000 0 N/C MAX CASCADE : 1
TRIGGER 0.000000 0.000000 PAGE LATCH 0.000000 0 N/C MAX WFILE BLKS: N/A
NOTIFY MSGS 2.173722 16 0.135858
PAR.TASKS 0.000000 0.000000 GLOBAL CONTENTION 0.000000 0 N/C
COMMIT PH1 WRITE I/O 0.000000 0 N/C
SUSPEND TIME 0.000000 2.200419 ASYNCH CF REQUESTS 0.000000 0 N/C
AGENT N/A 2.200419 TCP/IP LOB XML 0.000000 0 N/C
PAR.TASKS N/A 0.000000 ACCELERATOR 0.000000 0 N/C
STORED PROC 0.000000 N/A AUTONOMOUS PROCEDURE 0.000000 0 N/C
UDF 0.000000 N/A PQ SYNCHRONIZATION 0.000000 0 N/C
LOB COMPRESSION N/A N/A N/A
NOT ACCOUNT. N/A 0.071151 FAST INSERT PIPE N/A N/A N/A
DB2 ENT/EXIT N/A 3618 TOTAL CLASS 3 2.200419 181 0.012157
EN/EX-STPROC N/A 0
EN/EX-UDF N/A 0
DCAPT.DESCR. N/A N/A
LOG EXTRACT. N/A N/A
LOCATION: OMPDBEE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 3-21
GROUP: DBEE ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SEE1 TO: NOT SPECIFIED
SUBSYSTEM: SEE1 ACTUAL FROM: 08/24/16 08:16:02.78
DB2 VERSION: V11
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 09:28:00.00 PLANNAME: 'BLANK' WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 09:10:12.47 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : N/P PROD VER: N/P LUW LUN: IPUAPEE1 CICS INS: N/A
REQUESTER : OMPDBEE CORRNAME: LUW INS: D13DDEECF7B0
MAINPACK : 'BLANK' CORRNMBR: LUW SEQ: 1 ENDUSER : DB2PM
PRIMAUTH : DB2PM CONNTYPE: RRS TRANSACT: 'BLANK'
ORIGAUTH : DB2PM CONNECT : RRSAF WSNAME : RRSAF
SQL DML TOTAL SQL DCL TOTAL SQL DDL CREATE DROP ALTER DYNAMIC SQL STMT TOTAL
-------- -------- ---------- -------- ---------- ------ ------ ------ -------------------- --------
SELECT 184 LOCK TABLE 0 TABLE 0 0 0 REOPTIMIZATION 0
INSERT 4 GRANT 0 CRT TTABLE 0 N/A N/A NOT FOUND IN CACHE 12
ROWS 4 REVOKE 0 DCL TTABLE 0 N/A N/A FOUND IN CACHE 6
UPDATE 68 SET SQLID 1 AUX TABLE 0 N/A N/A IMPLICIT PREPARES 0
ROWS 2 SET H.VAR. 0 INDEX 0 0 0 PREPARES AVOIDED 0
MERGE 0 SET DEGREE 0 TABLESPACE 0 0 0 CACHE_LIMIT_EXCEEDED 0
DELETE 7 SET RULES 0 DATABASE 0 0 0 PREP_STMT_PURGED 0
ROWS 6 SET PATH 0 STOGROUP 0 0 0 STABILIZED PREPARE N/A
SET PREC. 0 SYNONYM 0 0 N/A CSWL - STMTS PARSED 0
DESCRIBE 0 CONNECT 1 0 VIEW 0 0 0 CSWL - LITS REPLACED 0
DESC.TBL 0 CONNECT 2 0 ALIAS 0 0 N/A CSWL - MATCHES FOUND 0
PREPARE 18 SET CONNEC 0 PACKAGE N/A 0 N/A CSWL - DUPLS CREATED 0
OPEN 396 RELEASE 0 PROCEDURE 0 0 0
FETCH 3498 CALL 0 FUNCTION 0 0 0
ROWS 3111 ASSOC LOC. 0 TRIGGER 0 0 N/A
CLOSE 396 ALLOC CUR. 0 DIST TYPE 0 0 N/A
HOLD LOC. 0 SEQUENCE 0 0 0
DML-ALL 4571 FREE LOC. 0 TRUST. CTX 0 0 0
DCL-ALL 1 ROLE 0 0 N/A
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
LOCATION: OMPDBEE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 3-22
GROUP: DBEE ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SEE1 TO: NOT SPECIFIED
SUBSYSTEM: SEE1 ACTUAL FROM: 08/24/16 08:16:02.78
DB2 VERSION: V11
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 09:28:00.00 PLANNAME: 'BLANK' WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 09:10:12.47 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : N/P PROD VER: N/P LUW LUN: IPUAPEE1 CICS INS: N/A
REQUESTER : OMPDBEE CORRNAME: LUW INS: D13DDEECF7B0
MAINPACK : 'BLANK' CORRNMBR: LUW SEQ: 1 ENDUSER : DB2PM
PRIMAUTH : DB2PM CONNTYPE: RRS TRANSACT: 'BLANK'
ORIGAUTH : DB2PM CONNECT : RRSAF WSNAME : RRSAF
MEASURED/ELIG TIMES APPL (CL1) DB2 (CL2) RID LIST TOTAL DATA CAPTURE TOTAL ROWID TOTAL
------------------- ---------- ---------- ---------------------- -------- ------------ -------- ---------- --------
ELAPSED TIME 47:31.0901 2.419360 USED 3 IFI CALLS 0 DIR ACCESS 0
ELIGIBLE FOR ACCEL N/A 0.000000 REC.CAPTURED 0 INDEX USED 0
FAIL-NO STORAGE 0 LOG REC.READ 0 TS SCAN 0
CP CPU TIME 0.366568 0.147791 FAIL-LIMIT EXC. 0 ROWS RETURN 0
ELIGIBLE FOR SECP 0.000000 N/A RECORDS RET. 0
ELIGIBLE FOR ACCEL N/A 0.000000 INTERRUPTED-NO STORAGE 0 DATA DES.RET 0
INTERRUPTED-LIMIT EXC. 0 TABLES RET. 0
SE CPU TIME 0.000000 0.000000 DESCRIBES 0
ELIGIBLE FOR ACCEL N/A 0.000000 OVERFLOWED-NO STORAGE 0
OVERFLOWED-LIMIT EXC. 0
SKIPPED-INDEX KNOWN 0
GLOBAL CONTENTION L-LOCKS ELAPSED TIME EVENTS GLOBAL CONTENTION P-LOCKS ELAPSED TIME EVENTS
------------------------------------- ------------ -------- ------------------------------------- ------------ --------
L-LOCKS 0.000000 0 P-LOCKS 0.000000 0
PARENT (DB,TS,TAB,PART) 0.000000 0 PAGESET/PARTITION 0.000000 0
CHILD (PAGE,ROW) 0.000000 0 PAGE 0.000000 0
OTHER 0.000000 0 OTHER 0.000000 0
LOCKING TOTAL DATA SHARING TOTAL QUERY PARALLELISM TOTAL DRAIN/CLAIM TOTAL
------------------- -------- ------------ -------- ------------------------- -------- ------------ --------
TIMEOUTS 0 GLOB CONT(%) 0.41 MAXIMUM DEGREE-ESTIMATED 0 DRAIN REQST 0
DEADLOCKS 0 FALS CONT(%) 0.00 MAXIMUM DEGREE-PLANNED 0 DRAIN FAILED 0
ESCAL.(SHAR) 0 P/L-LOCKS(%) 73 MAXIMUM DEGREE-EXECUTED 0 CLAIM REQST 684
ESCAL.(EXCL) 0 P-LOCK REQ 488 MAXIMUM MEMBERS USED N/P CLAIM FAILED 0
MAX PG/ROW LCK HELD 2 P-UNLOCK REQ 469 PARALLEL GROUPS EXECUTED 0
LOCK REQUEST 1587 P-CHANGE REQ 1 RAN AS PLANNED 0
UNLOCK REQST 571 LOCK - XES 1521 RAN REDUCED-STORAGE 0
QUERY REQST 0 UNLOCK-XES 515 RAN REDUCED-NEGOTIATION 0
CHANGE REQST 149 CHANGE-XES 137 SEQ-CURSOR 0
OTHER REQST 0 SUSP - IRLM 4 SEQ-NO ESA SORT 0
TOTAL SUSPENSIONS 19 SUSP - XES 5 SEQ-NO BUFFER 0
LOCK SUSPENS 0 CONV - XES 0 SEQ-AUTONOMOUS PROC 0
IRLM LATCH SUSPENS 0 FALSE CONT 0 SEQ-NEGOTIATION 0
OTHER SUSPENS 19 INCOMP.LOCK 0 ONE DB2-COORDINATOR = NO 0
NOTIFY SENT 19 ONE DB2-ISOLATION LEVEL 0
ONE DB2-DCL TTABLE 0
MEMB SKIPPED(%) 0
DISABLED BY RLF NO
REFORM PARAL-CONFIG 0
REFORM PARAL-NO BUF 0
LOCATION: OMPDBEE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 3-23
GROUP: DBEE ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SEE1 TO: NOT SPECIFIED
SUBSYSTEM: SEE1 ACTUAL FROM: 08/24/16 08:16:02.78
DB2 VERSION: V11
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 09:28:00.00 PLANNAME: 'BLANK' WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 09:10:12.47 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : N/P PROD VER: N/P LUW LUN: IPUAPEE1 CICS INS: N/A
REQUESTER : OMPDBEE CORRNAME: LUW INS: D13DDEECF7B0
MAINPACK : 'BLANK' CORRNMBR: LUW SEQ: 1 ENDUSER : DB2PM
PRIMAUTH : DB2PM CONNTYPE: RRS TRANSACT: 'BLANK'
ORIGAUTH : DB2PM CONNECT : RRSAF WSNAME : RRSAF
STORED PROC. TOTAL UDF TOTAL TRIGGERS TOTAL LOGGING TOTAL
------------ -------- --------- -------- ------------ -------- ----------------- --------
CALL STMTS 0 EXECUTED 0 STMT TRIGGER 0 LOG RECS WRITTEN 39
ABENDED 0 ABENDED 0 ROW TRIGGER 0 TOT BYTES WRITTEN 5433
TIMED OUT 0 TIMED OUT 0 SQL ERROR 0
REJECTED 0 REJECTED 0
TOTAL SU CLASS 1 CLASS 2 MISCELLANEOUS TOTAL
------------ -------------- -------------- -------------------- --------
CP CPU 23745 9573 MAX STO LOB VAL (KB) 0
AGENT 23745 9573 MAX STO XML VAL (KB) 0
NONNESTED 23744 9572 ARRAY EXPANSIONS 0
STORED PRC 0 0 SPARSE IX DISABLED 0
UDF 0 0 SPARSE IX BUILT WF 0
TRIGGER 0 0
PAR.TASKS 0 0
ELIG SECP 0 N/A
ELIG ACCEL N/A 0
SE CPU 0 0
NONNESTED 0 0
STORED PROC 0 0
UDF 0 0
TRIGGER 0 0
PAR.TASKS 0 0
ELIG ACCEL N/A 0
---- RESOURCE LIMIT FACILITY --------------------------------------------------------------------------------------------------
TYPE: N/P TABLE ID: N/P SERV.UNITS: N/P CPU SECONDS: N/P MAX CPU SEC: N/P
BP0 BPOOL ACTIVITY TOTAL BP32K BPOOL ACTIVITY TOTAL BP8K BPOOL ACTIVITY TOTAL
--------------------- -------- --------------------- -------- --------------------- --------
BPOOL HIT RATIO (%) 88 BPOOL HIT RATIO (%) 41 BPOOL HIT RATIO (%) 85
GETPAGES 3885 GETPAGES 34 GETPAGES 13
BUFFER UPDATES 11 BUFFER UPDATES 0 BUFFER UPDATES 0
SYNCHRONOUS WRITE 0 SYNCHRONOUS WRITE 0 SYNCHRONOUS WRITE 0
SYNCHRONOUS READ 145 SYNCHRONOUS READ 20 SYNCHRONOUS READ 2
SEQ. PREFETCH REQS 11 SEQ. PREFETCH REQS 0 SEQ. PREFETCH REQS 0
LIST PREFETCH REQS 3 LIST PREFETCH REQS 0 LIST PREFETCH REQS 0
DYN. PREFETCH REQS 1041 DYN. PREFETCH REQS 0 DYN. PREFETCH REQS 0
PAGES READ ASYNCHR. 337 PAGES READ ASYNCHR. 0 PAGES READ ASYNCHR. 0
LOCATION: OMPDBEE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 3-24
GROUP: DBEE ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SEE1 TO: NOT SPECIFIED
SUBSYSTEM: SEE1 ACTUAL FROM: 08/24/16 08:16:02.78
DB2 VERSION: V11
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 09:28:00.00 PLANNAME: 'BLANK' WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 09:10:12.47 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : N/P PROD VER: N/P LUW LUN: IPUAPEE1 CICS INS: N/A
REQUESTER : OMPDBEE CORRNAME: LUW INS: D13DDEECF7B0
MAINPACK : 'BLANK' CORRNMBR: LUW SEQ: 1 ENDUSER : DB2PM
PRIMAUTH : DB2PM CONNTYPE: RRS TRANSACT: 'BLANK'
ORIGAUTH : DB2PM CONNECT : RRSAF WSNAME : RRSAF
TOTAL BPOOL ACTIVITY TOTAL
--------------------- --------
BPOOL HIT RATIO (%) 87
GETPAGES 3932
BUFFER UPDATES 11
SYNCHRONOUS WRITE 0
SYNCHRONOUS READ 167
SEQ. PREFETCH REQS 11
LIST PREFETCH REQS 3
DYN. PREFETCH REQS 1041
PAGES READ ASYNCHR. 337
GROUP BP0 TOTAL GROUP BP32K TOTAL GROUP TOTAL TOTAL
--------------------- -------- --------------------- -------- --------------------- --------
GBP-DEPEND GETPAGES 1214 GBP-DEPEND GETPAGES 5 GBP-DEPEND GETPAGES 1219
READ(XI)-DATA RETUR 1 READ(XI)-DATA RETUR 0 READ(XI)-DATA RETUR 1
READ(XI)-NO DATA RT 3 READ(XI)-NO DATA RT 0 READ(XI)-NO DATA RT 3
READ(NF)-DATA RETUR 1 READ(NF)-DATA RETUR 1 READ(NF)-DATA RETUR 2
READ(NF)-NO DATA RT 7 READ(NF)-NO DATA RT 1 READ(NF)-NO DATA RT 8
PREFETCH PAGES READ 0 PREFETCH PAGES READ 0 PREFETCH PAGES READ 0
CLEAN PAGES WRITTEN 0 CLEAN PAGES WRITTEN 0 CLEAN PAGES WRITTEN 0
UNREGISTER PAGE 119 UNREGISTER PAGE 13 UNREGISTER PAGE 132
ASYNCH GBP REQUESTS 0 ASYNCH GBP REQUESTS 1 ASYNCH GBP REQUESTS 1
EXPLICIT X-INVALID 0 EXPLICIT X-INVALID 0 EXPLICIT X-INVALID 0
ASYNCH SEC-GBP REQ 0 ASYNCH SEC-GBP REQ 0 ASYNCH SEC-GBP REQ 0
PG P-LOCK LOCK REQ 466 PG P-LOCK LOCK REQ 3 PG P-LOCK LOCK REQ 469
SPACE MAP PAGES 465 SPACE MAP PAGES 2 SPACE MAP PAGES 467
DATA PAGES 1 DATA PAGES 1 DATA PAGES 2
INDEX LEAF PAGES 0 INDEX LEAF PAGES 0 INDEX LEAF PAGES 0
PG P-LOCK UNLOCK REQ 466 PG P-LOCK UNLOCK REQ 3 PG P-LOCK UNLOCK REQ 469
PG P-LOCK LOCK SUSP 0 PG P-LOCK LOCK SUSP 0 PG P-LOCK LOCK SUSP 0
SPACE MAP PAGES 0 SPACE MAP PAGES 0 SPACE MAP PAGES 0
DATA PAGES 0 DATA PAGES 0 DATA PAGES 0
INDEX LEAF PAGES 0 INDEX LEAF PAGES 0 INDEX LEAF PAGES 0
WRITE AND REGISTER 5 WRITE AND REGISTER 0 WRITE AND REGISTER 5
WRITE & REGISTER MULT 0 WRITE & REGISTER MULT 0 WRITE & REGISTER MULT 0
CHANGED PAGES WRITTEN 5 CHANGED PAGES WRITTEN 0 CHANGED PAGES WRITTEN 5
COMPL CHECKS SUSPEND 0 COMPL CHECKS SUSPEND 0 COMPL CHECKS SUSPEND 0
-------------------------------------------------------------------------------
!PROGRAM NAME CLASS 7 ELAPSED TIME CONSUMERS !
!FPEVWRPA !> 1% !
!DGOZPC2 !=> 3% !
!DGOZDATE ! !
!DGOZPC1 !===============================================> 95% !
LOCATION: OMPDBEE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 3-25
GROUP: DBEE ACCOUNTING TRACE - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SEE1 TO: NOT SPECIFIED
SUBSYSTEM: SEE1 ACTUAL FROM: 08/24/16 08:16:02.78
DB2 VERSION: V11
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 08/24/16 09:28:00.00 PLANNAME: 'BLANK' WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 08/24/16 09:10:12.47 PROD TYP: N/P LUW NET: DEIBMIPS CICS LUN: N/A
END TIME : N/P PROD VER: N/P LUW LUN: IPUAPEE1 CICS INS: N/A
REQUESTER : OMPDBEE CORRNAME: LUW INS: D13DDEECF7B0
MAINPACK : 'BLANK' CORRNMBR: LUW SEQ: 1 ENDUSER : DB2PM
PRIMAUTH : DB2PM CONNTYPE: RRS TRANSACT: 'BLANK'
ORIGAUTH : DB2PM CONNECT : RRSAF WSNAME : RRSAF
(CONTINUED)
-------------------------------------------------------------------------------
!PROGRAM NAME CLASS 7 ELAPSED TIME CONSUMERS !
!DGOZPC4 !> 1% !
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
!PROGRAM NAME CLASS 7 CP CPU TIME CONSUMERS !
!FPEVWRPA !==> 4% !
!DGOZPC2 !=====================> 42% !
!DGOZDATE !=> 2% !
!DGOZPC1 !===================> 38% !
!DGOZPC4 !=======> 14% !
-------------------------------------------------------------------------------
FPEVWRPA VALUE FPEVWRPA TIMES FPEVWRPA TIME EVENTS TIME/EVENT
------------------ ------------------ ------------------ ------------ ------------------ ------------ ------ ------------
TYPE PACKAGE ELAPSED TIME - CL7 0.014902 LOCK/LATCH 0.000000 0 N/C
LOCATION OMPDBEE CP CPU TIME 0.004894 IRLM LOCK+LATCH 0.000000 0 N/C
COLLECTION ID KO2OM530 AGENT 0.004894 DB2 LATCH 0.000000 0 N/C
PROGRAM NAME FPEVWRPA PAR.TASKS 0.000000 SYNCHRONOUS I/O 0.001744 6 0.000291
CONSISTENCY TOKEN 1A20F08810059FB5 SE CPU TIME 0.000000 OTHER READ I/O 0.000000 0 N/C
ACTIVITY TYPE NONNESTED SUSPENSION-CL8 0.004718 OTHER WRITE I/O 0.000000 0 N/C
ACTIVITY NAME 'BLANK' AGENT 0.004718 SERV.TASK SWITCH 0.000820 1 0.000820
SCHEMA NAME 'BLANK' PAR.TASKS 0.000000 ARCH.LOG(QUIESCE) 0.000000 0 N/C
SUCC AUTH CHECK N/P NOT ACCOUNTED 0.005290 ARCHIVE LOG READ 0.000000 0 N/C
NBR OF ALLOCATIONS 1 DRAIN LOCK 0.000000 0 N/C
SQL STMT - AVERAGE 6.00 CP CPU SU 317 CLAIM RELEASE 0.000000 0 N/C
SQL STMT - TOTAL 6 AGENT 317 PAGE LATCH 0.000000 0 N/C
NBR RLUP THREADS 1 PAR.TASKS 0 NOTIFY MESSAGES 0.002153 2 0.001077
SE CPU SU 0 GLOBAL CONTENTION 0.000000 0 N/C
TCP/IP LOB XML 0.000000 0 N/C
DB2 ENTRY/EXIT 16 ACCELERATOR 0.000000 0 N/C
PQ SYNCHRONIZATION 0.000000 0 N/C
FAST INSERT PIPE N/A N/A N/A
TOTAL CL8 SUSPENS. 0.004718 9 0.000524
...
ACCOUNTING TRACE COMPLETE