DB2 statistics trace—long report (BSTATLT)
The following figure shows a sample of the DB2 statistics trace—long report (BSTATLT).
The individual sections and field descriptions of this report are listed under Statistics-report-fields.
1 BSTATLT : STATISTICS LONG TRACE 02/23/15 08:10:17 PAGE 552
GROUP : DB2 STATISTICS TRACE - LONG DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:54:00.11 END RECORD: ( 15.054 ) 02/23/15 07:55:00.41
ELAPSED TIME: 00:01:00.30 THREADS: 12 #DBATS: 0 COMMITS: 12 INCREMENTAL BIND: 2
SQL DML QUANTITY /MINUTE /THREAD /COMMIT SQL DCL QUANTITY /MINUTE /THREAD /COMMIT
------------------------- -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
SELECT 0 0.00 0.00 0.00 LOCK TABLE 0 0.00 0.00 0.00
INSERT 0 0.00 0.00 0.00 GRANT 0 0.00 0.00 0.00
UPDATE 1 0.99 0.08 0.08 REVOKE 0 0.00 0.00 0.00
DELETE 0 0.00 0.00 0.00 SET CURRENT SQLID 0 0.00 0.00 0.00
SET HOST VARIABLE 12 11.94 1.00 1.00
PREPARE 219 217.90 18.25 18.25 SET CURRENT DEGREE 109 108.45 9.08 9.08
DESCRIBE 219 217.90 18.25 18.25 SET CURRENT RULES 0 0.00 0.00 0.00
DESCRIBE TABLE 0 0.00 0.00 0.00 CONNECT TYPE 1 0 0.00 0.00 0.00
OPEN CURSOR 111 110.44 9.25 9.25 CONNECT TYPE 2 0 0.00 0.00 0.00
CLOSE CURSOR 110 109.45 9.17 9.17 RELEASE 0 0.00 0.00 0.00
FETCH 219 217.90 18.25 18.25 SET CONNECTION 0 0.00 0.00 0.00
ROWS FETCHED 110 109.45 9.17 9.17 SET CURRENT PATH 0 0.00 0.00 0.00
ROWS INSERTED 0 0.00 0.00 0.00 SET CURRENT PRECISION 0 0.00 0.00 0.00
ROWS UPDATED 1 0.99 0.08 0.08
ROWS DELETED 0 0.00 0.00 0.00
ASSOCIATE LOCATORS 0 0.00 0.00 0.00
ALLOCATE LOCATORS 0 0.00 0.00 0.00
TOTAL 879 874.57 73.25 73.25 HOLD LOCATOR 0 0.00 0.00 0.00
FREE LOCATOR 0 0.00 0.00 0.00
TOTAL 121 120.39 10.08 10.08
STORED PROCEDURES QUANTITY /MINUTE /THREAD /COMMIT TRIGGERS QUANTITY /MINUTE /THREAD /COMMIT
------------------------- -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
CALL STATEMENTS EXECUTED 0 0.00 0.00 0.00 STATEMENT TRIGGER ACTIV 0 0.00 0.00 0.00
PROCEDURE ABENDED 0 0.00 0.00 0.00 ROW TRIGGER ACTIVATED 0 0.00 0.00 0.00
CALL STATEMENT TIMED OUT 0 0.00 0.00 0.00 SQL ERROR OCCURRED 0 0.00 0.00 0.00
CALL STATEMENT REJECTED 0 0.00 0.00 0.00
USER DEFINED FUNCTIONS QUANTITY /MINUTE /THREAD /COMMIT
------------------------- -------- ------- ------- -------
EXECUTED 0 0.00 0.00 0.00
ABENDED 0 0.00 0.00 0.00
TIMED OUT 0 0.00 0.00 0.00
REJECTED 0 0.00 0.00 0.00
1 BSTATLT : STATISTICS LONG TRACE 02/23/15 08:10:17 PAGE 553
GROUP : DB2 STATISTICS TRACE - LONG DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:54:00.11 END RECORD: ( 15.054 ) 02/23/15 07:55:00.41
ELAPSED TIME: 00:01:00.30 THREADS: 12 #DBATS: 0 COMMITS: 12 INCREMENTAL BIND: 2
SQL DDL QUANTITY /MINUTE /THREAD /COMMIT ROW ID QUANTITY /MINUTE /THREAD /COMMIT
------------------------- -------- ------- ------- ------- -------------------- -------- -------- -------- -------
CREATE TABLE 0 0.00 0.00 0.00 DIRECT ACCESS 0 0.00 0.00 0.00
CREATE GLBL TEMP TABLE 0 0.00 0.00 0.00 INDEX USED 0 0.00 0.00 0.00
DECLARE GLBL TEMP TABLE 0 0.00 0.00 0.00 TABLE SPACE SCAN USED 0 0.00 0.00 0.00
CREATE AUXILLARY TABLE 0 0.00 0.00 0.00
CREATE INDEX 0 0.00 0.00 0.00 STAR JOIN STATISTICS
CREATE VIEW 0 0.00 0.00 0.00 --------------------
CREATE SYNONYM 0 0.00 0.00 0.00 ALLOCATIONS IN SJ POOL 0 0.00 0.00 0.00
CREATE TABLESPACE 0 0.00 0.00 0.00 POOL FULL FAILURES 0 0.00 0.00 0.00
CREATE DATABASE 0 0.00 0.00 0.00 CURRENT SIZE IN MB 0 0.00 0.00 0.00
CREATE STOGROUP 0 0.00 0.00 0.00 MAX SIZE IN MB 0 0.00 0.00 0.00
CREATE ALIAS 0 0.00 0.00 0.00
CREATE DISTINCT TYPE 0 0.00 0.00 0.00
CREATE FUNCTION 0 0.00 0.00 0.00
CREATE PROCEDURE 0 0.00 0.00 0.00
CREATE TRIGGER 0 0.00 0.00 0.00
CREATE SEQUENCE 0 0.00 0.00 0.00
ALTER TABLE 0 0.00 0.00 0.00
ALTER INDEX 0 0.00 0.00 0.00
ALTER TABLESPACE 0 0.00 0.00 0.00
ALTER DATABASE 0 0.00 0.00 0.00
ALTER STOGROUP 0 0.00 0.00 0.00
ALTER FUNCTION 0 0.00 0.00 0.00
ALTER PROCEDURE 0 0.00 0.00 0.00
ALTER VIEW 0 0.00 0.00 0.00
ALTER SEQUENCE 0 0.00 0.00 0.00
DROP TABLE 0 0.00 0.00 0.00
DROP INDEX 0 0.00 0.00 0.00
DROP VIEW 0 0.00 0.00 0.00
DROP SYNONYM 0 0.00 0.00 0.00
DROP TABLESPACE 0 0.00 0.00 0.00
DROP DATABASE 0 0.00 0.00 0.00
DROP STOGROUP 0 0.00 0.00 0.00
DROP ALIAS 0 0.00 0.00 0.00
DROP PACKAGE 0 0.00 0.00 0.00
DROP DISTINCT TYPE 0 0.00 0.00 0.00
DROP FUNCTION 0 0.00 0.00 0.00
DROP PROCEDURE 0 0.00 0.00 0.00
DROP TRIGGER 0 0.00 0.00 0.00
DROP SEQUENCE 0 0.00 0.00 0.00
RENAME TABLE 0 0.00 0.00 0.00
COMMENT ON 0 0.00 0.00 0.00
LABEL ON 0 0.00 0.00 0.00
CREATE ROLE 0 0.00 0.00 0.00
CREATE TRUSTED CONTEXT 0 0.00 0.00 0.00
DROP ROLE 0 0.00 0.00 0.00
1 BSTATLT : STATISTICS LONG TRACE 02/23/15 08:10:17 PAGE 554
GROUP : DB2 STATISTICS TRACE - LONG DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:54:00.11 END RECORD: ( 15.054 ) 02/23/15 07:55:00.41
ELAPSED TIME: 00:01:00.30 THREADS: 12 #DBATS: 0 COMMITS: 12 INCREMENTAL BIND: 2
DROP TRUSTED CONTEXT 0 0.00 0.00 0.00
ALTER TRUSTED CONTEXT 0 0.00 0.00 0.00
ALTER JAR 0 0.00 0.00 0.00
RENAME INDEX COUNT 0 0.00 0.00 0.00
TOTAL 0 0.00 0.00 0.00
1 BSTATLT : STATISTICS LONG TRACE 02/23/15 08:10:17 PAGE 555
GROUP : DB2 STATISTICS TRACE - LONG DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:54:00.11 END RECORD: ( 15.054 ) 02/23/15 07:55:00.41
ELAPSED TIME: 00:01:00.30 THREADS: 12 #DBATS: 0 COMMITS: 12 INCREMENTAL BIND: 2
EDM POOL QUANTITY /MINUTE /THREAD /COMMIT SUBSYSTEM SERVICES QUANTITY /MINUTE /THREAD /COMMIT
------------------------- -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
PAGES IN EDM POOL 0 N/A N/A N/A IDENTIFY 1 0.99 0.08 0.08
% PAGES IN USE N/P CREATE THREAD 12 11.94 1.00 1.00
FREE PG/FREE CHAIN 0 N/A N/A N/A SIGNON 0 0.00 0.00 0.00
PAGES USED FOR CT 0 N/A N/A N/A TERMINATE 11 10.94 0.92 0.92
PAGES USED FOR DBD 98 N/A N/A N/A ROLLBACK 0 0.00 0.00 0.00
PAGES USED FOR SKCT 4 N/A N/A N/A
PAGES USED FOR PT 0 N/A N/A N/A COMMIT PHASE 1 0 0.00 0.00 0.00
PAGES USED FOR SKPT 8 N/A N/A N/A COMMIT PHASE 2 0 0.00 0.00 0.00
READ ONLY COMMIT 1 0.99 0.08 0.08
UNIT REC INDOUBT 0 0.00 0.00 0.00
FAILS DUE POOL FULL 0 0.00 0.00 0.00 UNIT REC INDBT RSLVD 0 0.00 0.00 0.00
CT REQUESTS 12 11.94 1.00 1.00 SYNCHS(SINGLE PHASE) 11 10.94 0.92 0.92
CT NOT IN EDMPOOL 0 0.00 0.00 0.00 Q'D CREATE THREAD 0 0.00 0.00 0.00
CT HIT RATIO 1.00 SUBSYSTEM MEMORY EOT 0 0.00 0.00 0.00
PT REQUESTS 49 48.75 4.08 4.08 SUBSYSTEM MEMORY EOM 0 0.00 0.00 0.00
PT NOT IN POOL 0 0.00 0.00 0.00 SYSTEM EVENT CHKPT 0 0.00 0.00 0.00
PT HIT RATIO 1.00 HIGH WATER MARK IDBACK 0 0.00 0.00 0.00
DBD REQUESTS 39 38.80 3.25 3.25 HIGH WATER MARK IDFORE 0 0.00 0.00 0.00
DBD NOT IN POOL 1 0.99 0.08 0.08 HIGH WATER MARK CTHREAD 0 0.00 0.00 0.00
DBD HIT RATIO 0.97
PAGES FOR DYN SQL CACHE N/P 0.00 0.00 0.00 WRITE REGISTER REQUESTS QUANTITY /MINUTE /THREAD /COMMIT
PAGES IN DBD 5850 5820.51 487.50 487.50 -------------------------- -------- ------- ------- -------
PAGES IN DBD FREE CHAIN 5752 5723.00 479.33 479.33 WAR REQUESTS-MULTI PAGE N/P 0.00 0.00 0.00
%DBD POOL IN USE 2
PAGES USED FOR DBD 98 97.51 8.17 8.17
FAILS DUE TO DBD FULL 0 0.00 0.00 0.00 WAR REQUESTS-ONE PAGE N/P 0.00 0.00 0.00
PAGES IN EDM STMT POOL 2500 2487.40 208.33 208.33 READ FOR CASTOUT-MULTI PAGE N/P 0.00 0.00 0.00
PAGES USED IN STATEMENT PL 12 11.94 1.00 1.00 READ FOR CASTOUT-ONE PAGE N/P 0.00 0.00 0.00
%STMT POOL IN USE 0 PAGES WRITTEN VIA WARM N/P 0.00 0.00 0.00
FREE PAGES IN EDM STMT PL 2488 2475.46 207.33 207.33 # NOT FOUND RECORDS FOUND 0 0.00 0.00 0.00
FAILURES STMT POOL FULL 0 0.00 0.00 0.00 # NOT FOUND RECORDS ADDED 0 0.00 0.00 0.00
STMTS IN GLOBAL CACHE 2 1.99 0.17 0.17 # NOT FOUND RECORDS REMOVED 0 0.00 0.00 0.00
NUM OF XPROC REQUESTS 0 0.00 0.00 0.00 # FAIL STMT SKEL POOL FULL 0 0.00 0.00 0.00
STRG ALLOC TO XPROC 0 0.00 0.00 0.00 # PGS SKEL EDM POOL 1280 1273.55 106.67 106.67
STEALABLE SKEL PAGES 12 11.94 1.00 1.00 # FREE PGS IN SKEL EDM POOL 1268 1261.61 105.67 105.67
STEALABLE DBD PAGES 3 2.98 0.25 0.25 # PAGES USED CT ATB 0 0.00 0.00 0.00
STRG ALLOC TO PLAN BTB 0 0.00 0.00 0.00 # PAGES USED PT ATB 0 0.00 0.00 0.00
STRG ALLOC TO PKGS BTB 0 0.00 0.00 0.00 # FAIL STMT ATB POOL FULL 0 0.00 0.00 0.00
STRG ALLOC TO PLAN ATB 25344 25216.2 2112.00 2112.00 # PAGES STMT ATB EDM POOL 0 0.00 0.00 0.00
STRG ALLOC TO PKGS ATB 33024 32857.5 2752.00 2752.00 #FREE PGS STMT ATB EDM POOL 0 0.00 0.00 0.00
1 BSTATLT : STATISTICS LONG TRACE 02/23/15 08:10:17 PAGE 556
GROUP : DB2 STATISTICS TRACE - LONG DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:54:00.11 END RECORD: ( 15.054 ) 02/23/15 07:55:00.41
ELAPSED TIME: 00:01:00.30 THREADS: 12 #DBATS: 0 COMMITS: 12 INCREMENTAL BIND: 2
OPEN/CLOSE ACTIVITY QUANTITY /MINUTE /THREAD /COMMIT LOG ACTIVITY QUANTITY /MINUTE /THREAD /COMMIT
-------------------- --------- ------- -------- --------- -------------------------- -------- ------- ------- -------
OPEN DATASETS - HWM 104 N/A N/A N/A READ SATISF'D-OUTPUT BUFF 0 0.00 0.00 0.00
OPEN DATASETS 104 N/A N/A N/A READ SATISF'D-OUTP BUF(%) N/P
NOT IN USE/NOT CLOSE-HWM 102 N/A N/A N/A READ SATISF'D-ACTIVE LOG 0 0.00 0.00 0.00
DS NOT IN USE/NOT CLOSED 41 N/A N/A N/A READ SATISF'D-ACTV LOG(%) N/P
IN USE DATA SETS 0 N/A N/A N/A READ SATISF'D-ARCHV LOG 0 0.00 0.00 0.00
READ SATISF'D-ARCH LOG(%) N/P
DS CLOSED-THRESH REACHED 0 0.00 0.00 0.00 TAPE VOL CONTENTION WAIT 0 0.00 0.00 0.00
READ DELAYED-UNAVAIL RESOU 0 0.00 0.00 0.00
DS CONVERTED R/W TO R/O 0 0.00 0.00 0.00
WRITE - NOWAIT 0 0.00 0.00 0.00
WRITE OUTPUT LOG BUFFERS 0 0.00 0.00 0.00
BSDS ACCESS REQUESTS 0 0.00 0.00 0.00
UNAVAIL OUTPUT LOG BUFS 0 0.00 0.00 0.00
OUTPUT LOG BUFFER PAGED IN 0 0.00 0.00 0.00
CONT INTERV CREATED-ACTV 0 0.00 0.00 0.00
ARCHIVE LOG READ ALLOC 0 0.00 0.00 0.00
ARCHIVE LOG WRITE ALLOC 0 0.00 0.00 0.00
CONTR INTRV OFFLOAD-ARCH 0 0.00 0.00 0.00
READ DELAYED-UNAVAIL RES 0 0.00 0.00 0.00
READ DELAY-ARCH ALLOC LIM 0.00 0.00 0.00
LOOK-AHEAD MOUNT ATTEMPT 0 0.00 0.00 0.00
LOOK-AHEAD MOUNT SUCCESS 0 0.00 0.00 0.00
LOG RECORDS CREATED 0 0.00 0.00 0.00
LOG DATA CREATED MB 0 0.00
LOG WRITE I/O REQUESTS 0 0.00 0.00 0.00
LOG CI WRITTEN 0 0.00 0.00 0.00
LOG CI SERIAL WRITE 0 0.00 0.00 0.00
LOG WRITE ASYNC. REQUESTS 0 0.00 0.00 0.00
LOG RATE FOR 1 LOG (MB) N/A 0.00 N/A N/A
LOG WRITE SUSPENDED 0 0.00 0.00 0.00
1 BSTATLT : STATISTICS LONG TRACE 02/23/15 08:10:17 PAGE 557
GROUP : DB2 STATISTICS TRACE - LONG DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:54:00.11 END RECORD: ( 15.054 ) 02/23/15 07:55:00.41
ELAPSED TIME: 00:01:00.30 THREADS: 12 #DBATS: 0 COMMITS: 12 INCREMENTAL BIND: 2
PLAN/PACKAGE PROCESSING QUANTITY /MINUTE /THREAD /COMMIT DB2 COMMANDS QUANTITY /MINUTE
------------------------- -------- ------- ------- ------- -------------------------- -------- -------
PLAN ALLOC ATTEMPTS 12 11.94 1.00 1.00 DISPLAY DATABASE 0 0.00
PLAN ALLOC SUCCESSFUL 12 11.94 1.00 1.00 DISPLAY THREAD 0 0.00
PACKAGE ALLOC ATTEMPTS 13 12.93 1.08 1.08 DISPLAY UTILITY 0 0.00
PACKAGE ALLOC SUCCESSFUL 13 12.93 1.08 1.08 DISPLAY TRACE 0 0.00
DISPLAY RLIMIT 0 0.00
PLANS BOUND 0 0.00 0.00 0.00 DISPLAY LOCATION 0 0.00
BIND ADD SUBCMDS 0 0.00 0.00 0.00 DISPLAY ARCHIVE 0 0.00
BIND REPLACE SUBCMDS 0 0.00 0.00 0.00 DISPLAY BUFFERPOOL 0 0.00
TEST BINDS NO PLAN-ID 0 0.00 0.00 0.00 DISPLAY GROUPBUFFERPOOL 0 0.00
PACKAGES BOUND 0 0.00 0.00 0.00 DISPLAY GROUP 0 0.00
BIND ADD PKG SUBCMDS 0 0.00 0.00 0.00 DISPLAY PROCEDURE 0 0.00
BIND REPLACE PKG SUBCMDS 0 0.00 0.00 0.00 DISPLAY DDF 0 0.00
ALTER BUFFERPOOL 0 0.00
AUTOMATIC BIND ATTEMPTS 0 0.00 0.00 0.00 ALTER GROUPBUFFERPOOL 0 0.00
AUTOMATIC BINDS SUCCESS 0 0.00 0.00 0.00 START DATABASE 0 0.00
AUTO BIND INVALID RES ID 0 0.00 0.00 0.00 START TRACE 0 0.00
AUTO BIND PACKAGE ATTEMPT 0 0.00 0.00 0.00 START DB2 0 0.00
AUTO BIND PACKAGE SUCCESS 0 0.00 0.00 0.00 START RLIMIT 0 0.00
START DDF 0 0.00
REBIND SUBCOMMANDS 0 0.00 0.00 0.00 START PROCEDURE 0 0.00
ATTEMPT TO REBIND A PLAN 0 0.00 0.00 0.00 STOP DATABASE 0 0.00
PLANS REBOUND 0 0.00 0.00 0.00 STOP TRACE 0 0.00
REBIND PACKAGE SUBCMDS 0 0.00 0.00 0.00 STOP DB2 0 0.00
ATTEMPT TO REBIND PKG 0 0.00 0.00 0.00 STOP RLIMIT 0 0.00
PACKAGES REBOUND 0 0.00 0.00 0.00 STOP DDF 0 0.00
STOP PROCEDURE 0 0.00
FREE PLAN SUBCOMMANDS 0 0.00 0.00 0.00 MODIFY TRACE 0 0.00
ATTEMPTS TO FREE A PLAN 0 0.00 0.00 0.00 CANCEL DDF THREAD 0 0.00
PLANS FREED 0 0.00 0.00 0.00 TERM UTILITY 0 0.00
FREE PACKAGE SUBCOMMANDS 0 0.00 0.00 0.00 RECOVER BSDS 0 0.00
ATTEMPTS TO FREE PACKAGE 0 0.00 0.00 0.00 RECOVER INDOUBT 0 0.00
PACKAGES FREED 0 0.00 0.00 0.00 RESET INDOUBT 0 0.00
RESET GENERICLU 0 0.00
INCREMENTAL BINDS 2 1.99 0.17 0.17 ARCHIVE LOG 0 0.00
SET ARCHIVE 0 0.00
UNRECOGNIZED CMDS 0 0.00
START PROFILE COMMANDS 0 0.00
STOP PROFILE COMMANDS 0 0.00
ACCESS DATABASE COMMANDS 0 0.00
DISPLAY DDF COMMANDS 0 0.00
TOTAL 0 0.00
1 BSTATLT : STATISTICS LONG TRACE 02/23/15 08:10:17 PAGE 558
GROUP : DB2 STATISTICS TRACE - LONG DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:54:00.11 END RECORD: ( 15.054 ) 02/23/15 07:55:00.41
ELAPSED TIME: 00:01:00.30 THREADS: 12 #DBATS: 0 COMMITS: 12 INCREMENTAL BIND: 2
RID LIST PROCESSING QUANTITY /MINUTE /THREAD /COMMIT AUTHORIZATION MANAGEMENT QUANTITY /MINUTE /THREAD /COMMIT
------------------------ -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
MAX RID BLOCKS ALLOCATED 3 2.98 0.25 0.25 AUTHORIZATION ATTEMPTS 17 16.91 1.42 1.42
CURRENT RID BLOCKS ALLOC 2 1.99 0.17 0.17 AUTHORIZATION SUCCESSFUL 17 16.91 1.42 1.42
TERMINATED - NO STORAGE 0 0.00 0.00 0.00 AUTH SUCC-WITHOUT CATALOG 11 10.94 0.92 0.92
TERM'D-EXCEED RDS LIMIT 0 0.00 0.00 0.00 AUTH SUCC-EXEC TO PUBLIC 7 6.96 0.58 0.58
TERM'D-EXCEED DM LIMIT 0 0.00 0.00 0.00 AUTH SUCC-PKG W/O CATALOG 1 0.99 0.08 0.08
TERM'D-EXCEED PROC LIMIT 0 0.00 0.00 0.00 AUTH SUCC-PKG-PUB-W/O CAT 1 0.99 0.08 0.08
NUMBER MAX SIZE INCREASED 0 0.00 0.00 0.00 AUTH UNSUCC-PKG-CACHE 0 0.00 0.00 0.00
TIMES OVWFL NO RID STRG 0 0.00 0.00 0.00 PKG CACHE OVERWRT - AUTHID 0 0.00 0.00 0.00
TIMES OVWFL NO RID INTLMT 0 0.00 0.00 0.00 PKG CACHE OVERWRT - ENTRY 0 0.00 0.00 0.00
TIMES HYBRD JOIN INT STRG 0 0.00 0.00 0.00 RTN_AUTH SUCC-W/O CATLG 0 0.00 0.00 0.00
TIMES HYBRD JOIN INT INTL 0 0.00 0.00 0.00 RTN_AUTH SUCC-PUB W/OCAT 0 0.00 0.00 0.00
TIMES MIAP SKIPPED PRE_OT 0 0.00 0.00 0.00 RTN_AUTH UNSUCC_CACHE 0 0.00 0.00 0.00
1 BSTATLT : STATISTICS LONG TRACE 02/23/15 08:10:17 PAGE 559
GROUP : DB2 STATISTICS TRACE - LONG DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:54:00.11 END RECORD: ( 15.054 ) 02/23/15 07:55:00.41
ELAPSED TIME: 00:01:00.30 THREADS: 12 #DBATS: 0 COMMITS: 12 INCREMENTAL BIND: 2
WORK FILE DATABASE QUANTITY /MINUTE /THREAD /COMMIT
--------------------- -------- ------- ------- -------
CURR TOT STG USED (KB) 64 63.68 5.33 5.33
MAX STORAGE USED 64 N/A N/A N/A
MAX LIMIT PER USER 0 N/A N/A N/A
NUMBER LIMIT EXCEEDED 0 0.00 0.00 0.00
4K TS STOR USED (KB) 64 63.68 5.33 5.33
32K TS STOR USED (KB) 0 0.00 0.00 0.00
4K USED, 32K BETTER 0 0.00 0.00 0.00
32K USED, 4K BETTER 0 0.00 0.00 0.00
DM IN MEMORY ACT-FILES 0 0.00 0.00 0.00
TOTAL SPACE USED IN_MEM 0 0.00 0.00 0.00
HWM COUNT MAX IN-MEM WF 0 N/A N/A N/A
HWM COUNT MAX IN-MEM WFKB 0 N/A N/A N/A
HOW MANY SORT IN-MEM FILES 0 0.00 0.00 0.00
TOT SPACE SRT IN-MEM FILES 0 0.00 0.00 0.00
HWM MANY SRT IN-MEM FILES 1 N/A N/A N/A
HWM STRG SRT IN-MEM FILES 40 N/A N/A N/A
HWM RID OWVFL WRK FILES 0 N/A N/A N/A
NUM RID BLKS IN STRG-CURR 0 0.00 0.00 0.00
LOCKING ACTIVITY QUANTITY /MINUTE /THREAD /COMMIT DATA SHARING LOCKING QUANTITY /MINUTE /THREAD /COMMI
------------------------ -------- ------- ------- ------- -------------------------- -------- ------- ------- ------
SUSPENSIONS (ALL) 1 0.99 0.08 0.08 LOCK REQUESTS (P-LOCKS) N/P 0.00 0.00 0.00
SUSPENSIONS (LOCK ONLY) 0 0.00 0.00 0.00 UNLOCK REQUESTS (P-LOCKS) N/P 0.00 0.00 0.00
SUSPENSIONS (LATCH ONLY) 1 0.99 0.08 0.08 CHANGE REQUESTS (P-LOCKS) N/P 0.00 0.00 0.00
SUSPENSIONS (OTHER) 0 0.00 0.00 0.00
SYNCH.XES - LOCK REQUESTS N/P 0.00 0.00 0.00
TIMEOUTS 0 0.00 0.00 0.00 SYNCH.XES - CHANGE REQS N/P 0.00 0.00 0.00
DEADLOCKS 0 0.00 0.00 0.00 SYNCH.XES - UNLOCK REQS N/P 0.00 0.00 0.00
ASYNCH.XES - RESOURCES N/P 0.00 0.00 0.00
LOCK REQUESTS 340 338.29 28.33 28.33
UNLOCK REQUESTS 188 187.05 15.67 15.67 SUSPENDS - IRLM GLOB. CONT N/P 0.00 0.00 0.00
QUERY REQUESTS 0 0.00 0.00 0.00 SUSPENDS - XES GLOBAL CONT N/P 0.00 0.00 0.00
CHANGE REQUESTS 114 113.43 9.50 9.50 SUSP-FALSE CONT AND CONV N/P 0.00 0.00 0.00
OTHER REQUESTS 0 0.00 0.00 0.00 SUSPENDS - FALSE CONT. N/P 0.00 0.00 0.00
INCOMPATIBLE RETAINED LOCK N/P 0.00 0.00 0.00
LOCK ESCALATION (SHARED) 0 0.00 0.00 0.00 NOTIFY MESSAGES SENT N/P 0.00 0.00 0.00
LOCK ESCALATION (EXCL) 0 0.00 0.00 0.00 NOTIFY MESSAGES RECEIVED N/P 0.00 0.00 0.00
P-LOCK/NOTIFY EXITS ENG. N/P N/A N/A N/A
DRAIN REQUESTS 0 0.00 0.00 0.00 P-LOCK/NOT EX ENG. UNAVAIL N/P 0.00 0.00 0.00
DRAIN REQUESTS FAILED 0 0.00 0.00 0.00
CLAIM REQUESTS 757 753.18 63.08 63.08 PSET/PART P-LOCK NEG. N/P 0.00 0.00 0.00
CLAIM REQUESTS FAILED 0 0.00 0.00 0.00 PAGE P-LOCK NEGOTIATION N/P 0.00 0.00 0.00
OTHER P-LOCK NEGOTIATION N/P 0.00 0.00 0.00
P-LOCK CHANGE DURING NEG. N/P 0.00 0.00 0.00
REJECTIONS HEURSTIC ALG-XES N/P
GLOBAL CONTENTION RATE(%) N/P
FALSE CONTENTION RATE(%) N/P
L-LOCKS XES RATE(%) N/P
1 BSTATLT : STATISTICS LONG TRACE 02/23/15 08:10:17 PAGE 560
GROUP : DB2 STATISTICS TRACE - LONG DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:54:00.11 END RECORD: ( 15.054 ) 02/23/15 07:55:00.41
ELAPSED TIME: 00:01:00.30 THREADS: 12 #DBATS: 0 COMMITS: 12 INCREMENTAL BIND: 2
GLOBAL DDF ACTIVITY QUANTITY /MINUTE /THREAD /COMMIT PARALLELISM QUANTITY /MINUTE /THREAD /COMMIT
------------------------- -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
DBATS QUEUED-MAX ACTIVE 0 0.00 0.00 N/A MAX DEGREE OF PARALLELISM 0 N/A N/A N/A
CONV DEALLOC-MAX THREADS 0 0.00 0.00 N/A PARALLEL GROUPS EXECUTED 0 0.00 0.00 0.00
INACTIVE DBATS - CURRENT 0 N/A N/A N/A EXECUTED AS PLANNED 0 0.00 0.00 0.00
INACTIVE DBATS - HWM 0 N/A N/A N/A REDUCED DEGREE-NO BUFFER 0 0.00 0.00 0.00
COLD START CONNECTIONS 0 0.00 0.00 0.00 FALL TO SEQUENTIAL-CURSOR 0 0.00 0.00 0.00
WARM START CONNECTIONS 0 0.00 0.00 0.00 FALL TO SEQUENTIAL-NO ESA 0 0.00 0.00 0.00
RESYNCHRONIZATION ATTEMPT 0 0.00 0.00 0.00 FALL TO SEQUENT'L-NO BUFF 0 0.00 0.00 0.00
RESYNCHRONIZATION SUCCEED 0 0.00 0.00 0.00 FALL TO SEQUENT'L-NO ENC N/P 0.00 0.00 0.00
CURRENT ACTIVE DBATS 0 N/A N/A N/A ONE DB2 -COORDINATOR=NO 0 0.00 0.00 0.00
MAX ACTIVE DBATS - HWM 0 N/A N/A N/A ONE DB2 - ISOLATION LEVEL 0 0.00 0.00 0.00
MAX ALL DBATS - HWM 0 N/A N/A N/A ONE DB2 - DCL TTABLE 0 0.00 0.00 0.00
TYPE 1 CONN TERMINATE 0 0.00 0.00 0.00 REFORM PARAL-CONFIG CHND 0 0.00 0.00 0.00
CUR TYPE2 INACTIVE DBATS 0 0.00 0.00 0.00 REFORM PARAL-NO BUFFER 0 0.00 0.00 0.00
TYPE2 INACTIVE DBATS HWM 0 GROUPS INTENDED - SYSPLEX 0 0.00 0.00 0.00
CUR QUEUED TYPE2 INAC THD 0 0.00 0.00 0.00 MEMBER SKIPPED - BFRS 0 0.00 0.00 0.00
REC QUEUED TYPE2 INAC THD 0 0.00 0.00 0.00
QUEUED TYPE2 INAC THD HWM 0 0.00 0.00 0.00
CURRENT DBATS NOT IN USE 0 0.00 0.00 0.00
DBATS NOT IN USE HWM 0 0.00 0.00 0.00
DBATS CREATED 0 0.00 0.00 0.00
POOL DBATS REUSED 0 0.00 0.00 0.00
NBR REQ DBA ACCESS 0 0.00 0.00 0.00
NBR REQ POOL ACCESS 0 0.00 0.00 0.00
NBR OF Q'D CLIENT(TCP/CLS) 0 0.00 0.00 0.00
NBR OF DBAT ACT PKG-BND 0 0.00 0.00 0.00
MAX OF DBAT ACT PKG-BND 0 0.00 0.00 0.00
1 BSTATLT : STATISTICS LONG TRACE 02/23/15 08:10:17 PAGE 561
GROUP : DB2 STATISTICS TRACE - LONG DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:54:00.11 END RECORD: ( 15.054 ) 02/23/15 07:55:00.41
ELAPSED TIME: 00:01:00.30 THREADS: 12 #DBATS: 0 COMMITS: 12 INCREMENTAL BIND: 2
TCB TIME SRB TIME TOTAL TIME
CPU TIMES H:MM:SS.THTTH H:MM.SS.THTTH H:MM.SS.THTTH
------------------------ ------------- ------------- -------------
SYSTEM SRVCS ADDR SPC 00:00.01532 00:00.01124 00:00.02656
DATABASE SRVCS ADDR SPC 00:00.01429 00:00.80712 00:00.82141
IRLM 00:00.00000 00:00.01002 00:00.01002
DDF ADDRESS SPACE 00:00.00698 00:00.00299 00:00.00997
TOTAL 00:00.03660 00:00.83137 00:00.86796
PREEMPTABLE SRB TIMER VALUE, NOT INCLUDING CPU ON AN IBM ZIIP (DB2 V7 ABOVE) 00:00:22
PREEMPTABLE SRB TIMER VALUE CONSUMED ON AN IBM ZIIP (DB2 V8 ABOVE) 00:20:06
DB2 APPL.PRGR.INTERFACE QUANTITY /MINUTE /THREAD /COMMIT DATA CAPTURE QUANTITY /MINUTE /THREAD /COMMIT
------------------------ -------- ------- ------- ------- ------------------------- -------- ------- ------- -------
ABENDS 0 0.00 0.00 0.00 LOG RECORDS CAPTURED 0 0.00 0.00 0.00
UNRECOGNIZED 0 0.00 0.00 0.00 LOG READS PERFORMED 0 0.00 0.00 0.00
COMMAND REQUESTS 0 0.00 0.00 0.00 LOG RECORDS RETURNED 0 0.00 0.00 0.00
READA REQUESTS 54 53.73 4.50 4.50 DATA ROWS RETURNED 0 0.00 0.00 0.00
READS REQUESTS 6 5.97 0.50 0.50 DESCRIBES PERFORMED 0 0.00 0.00 0.00
WRITE REQUESTS 0 0.00 0.00 0.00 DATA DESCRIPTIONS RETRNED 0 0.00 0.00 0.00
TABLES RETURNED 0 0.00 0.00 0.00
TOTAL 60 59.70 5.00 5.00
DYNAMIC SQL STMT QUANTITY /MINUTE /THREAD /COMMIT IFC DEST WRITTEN NOT WRTN BUF OVER NOT ACCP WRT FAIL
------------------------ -------- ------- ------- ------- -------- -------- -------- -------- -------- --------
PREPARE REQUESTS 137334 136642 11444.5 11444.5 SMF 39 0 0 0 0
FULL PREPARES 1 0.99 0.08 0.08 GTF 0 0 0 0 0
HALF PREPARES 109 108.45 9.08 9.08 OP1 24 0 0 0 0
GLOBAL CACHE HIT RATIO% 99 OP2 24 0 0 0 0
IMPLICIT PREPARES 0 0.00 0.00 0.00 OP3 24 0 0 0 0
PREPARE AVOIDED 0 0.00 0.00 0.00 OP4 2 0 0 0 0
STMT INVALID (MAXKEEPD) 0 0.00 0.00 0.00 OP5 0 0 0 0 0
STMT INVALID(DDL) 0 0.00 0.00 0.00 OP6 0 109931 0 44395 0
OP7 0 109931 0 44395 0
LOCAL CACHE HIT RATIO(%) N/P OP8 0 0 0 0 0
RES 0 0 0 0 0
TOTAL 113 219862 0 88790 0
IFC RECORD COUNT WRITTEN NOT WRTN LATCH CNT /SECOND /SECOND /SECOND /SECOND MISCELLANEOUS
---------------- -------- -------- --------- ------- ------- ------- ------- ----------------------------------------
SYSTEM RELATED 11 2 LC01-LC04 0.00 0.00 0.00 0.00 LOG RBA ADDRESS: 00000199C8BABDB6
DATABASE RELATED 11 2 LC05-LC08 0.00 0.00 0.00 0.00 STATS INVOKE RSN: ACTIVATED BY TIMER
ACCOUNTING 44 22 LC09-LC12 0.00 0.00 0.00 0.00 BYPASSED COLUMNS: 0
START TRACE 0 0 LC13-LC16 0.00 3.68 0.00 0.00 MAX SQL CASCAD LVL: 0
STOP TRACE 0 0 LC17-LC20 0.00 0.00 0.00 0.00 MAX STOR LOB VALUES: 0
SYSTEM PARMS 1 2 LC21-LC24 0.00 0.00 0.03 0.12
SYS PARMS-BPOOL 5 2 LC25-LC28 0.00 0.00 0.00 0.00
AUDIT 0 0 LC29-LC32 0.00 0.02 0.00 0.00
TOTAL 72 30
1 BSTATLT : STATISTICS LONG TRACE 02/23/15 08:10:17 PAGE 562
GROUP : DB2 STATISTICS TRACE - LONG DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:54:00.11 END RECORD: ( 15.054 ) 02/23/15 07:55:00.41
ELAPSED TIME: 00:01:00.30 THREADS: 12 #DBATS: 0 COMMITS: 12 INCREMENTAL BIND: 2
LATCH COUNT /QUANTITY /SECOND /THREAD /COMMIT
----------- --------- ------- ------- -------
LC01-LC04 0 0.00 0.00 0.00
LC05-LC08 0 0.00 0.00 0.00
LC09-LC12 0 0.00 0.00 0.00
LC13-LC16 222 3.68 18.50 0.00
LC17-LC20 0 0.00 0.00 0.00
LC21-LC24 9 0.15 0.75 0.75
LC25-LC28 0 0.00 0.00 0.00
LC29-LC32 1 0.02 0.08 0.08
1 BSTATLT : STATISTICS LONG TRACE 02/23/15 08:10:17 PAGE 563
GROUP : DB2 STATISTICS TRACE - LONG DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:54:00.11 END RECORD: ( 15.054 ) 02/23/15 07:55:00.41
ELAPSED TIME: 00:01:00.30 THREADS: 12 #DBATS: 0 COMMITS: 12 INCREMENTAL BIND: 2
BUFFER POOL BP0 QUANTITY /MINUTE /THREAD /COMMIT BP0 READ OPERATIONS QUANTITY /MINUTE /THREAD /COMMIT
------------------------ -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
CURRENT ACTIVE BUFFERS 66 N/A N/A N/A GETPAGE REQUESTS 438827 436615 36568.9 36568.9
UNAVAIL BUF-VPOOL FULL 0 0.00 0.00 0.00 GETPAGE REQUEST-SEQUENTIAL 111 110.44 9.25 9.25
GETPAGE REQUEST-RANDOM N/A N/A N/A N/A
NUMBER OF DATASET OPENS 1 0.99 0.08 0.08
SYNCHRONOUS READS 2175 2164.04 181.25 181.25
BUFFERS ALLOCATED-VPOOL 2000 N/A N/A N/A SYNCHRON READS-SEQUENTIAL 109 108.45 9.08 9.08
BUFFERS ALLOCATED-HPOOL N/P N/A N/A N/A SYNCHRON READS-RANDOM N/A N/A N/A N/A
HPOOL BUFFERS BACKED N/P N/A N/A N/A
GETPAGE PER SYNCH READS 212.35
DFHSM MIGRATED DATASETS 0 0.00 0.00 0.00
DFHSM RECALL TIMEOUTS 0 0.00 0.00 0.00 SEQUENT'L PREFETCH REQUEST 218 216.90 18.17 18.17
SEQUENTIAL PREFETCH READS 109 108.45 9.08 9.08
HPOOL EXPAND/CONTRACT N/P 0.00 0.00 0.00 PAGES READ VIA SEQ PREF 981 976.05 81.75 81.75
VPOOL EXPAND/CONTRACT 0 0.00 0.00 0.00 S PRF PAGE READ/S PRF READ 9.00
VPOOL/HPOOL EXP FAILURE 0 0.00 0.00 0.00
LIST PREFETCH REQUESTS 8749 8704.90 729.08 729.08
CONCUR PREF I/O - HWM 0 0.00 0.00 0.00 LIST PREFETCH READS 8749 8704.90 729.08 729.08
PREF I/O STREAM REDUCED 0 0.00 0.00 0.00 PAGES READ VIA LIST PREF 216685 215593 18057.1 18057.1
PARALLEL QUERY REQUESTS 0 0.00 0.00 0.00 L PRF PAGE READ/L PRF READ 24.77
PARALL QUERY REQ REDUCED 0 0.00 0.00 0.00
PREF QUANT REDUCED 1/2 0 0.00 0.00 0.00 DYNAMIC PREFETCH REQUESTED 15344 15266.7 1278.67 1278.67
PREF QUANT REDUCED 1/4 0 0.00 0.00 0.00 DYNAMIC PREFETCH READS 13152 13085.7 1096.00 1096.00
PAGES READ VIA DYN PREFTCH 322343 320718 26861.9 26861.9
D PRF PAGE READ/D PRF READ 24.51
PREF DISABLED - NO BUFFER 0 0.00 0.00 0.00
PREF DISABLED-NO READ ENG 0 0.00 0.00 0.00
PAGE INS REQUIRED FOR READ 0 0.00 0.00 0.00
SYNC HPOOL READ N/P 0.00 0.00 0.00
ASYNC HPOOL READ N/P 0.00 0.00 0.00
HPOOL READ FAILED N/P 0.00 0.00 0.00
ASYN DA MOVR HPOOL READ-S N/P 0.00 0.00 0.00
ASYN DA MOVR HPOOL READ-F N/P 0.00 0.00 0.00
BPOOL HIT RATIO (%) 99.48
HPOOL HIT RATIO (%) 0.00
HPOOL R/W RATIO (%) N/P
1 BSTATLT : STATISTICS LONG TRACE 02/23/15 08:10:17 PAGE 564
GROUP : DB2 STATISTICS TRACE - LONG DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:54:00.11 END RECORD: ( 15.054 ) 02/23/15 07:55:00.41
ELAPSED TIME: 00:01:00.30 THREADS: 12 #DBATS: 0 COMMITS: 12 INCREMENTAL BIND: 2
BP0 WRITE OPERATIONS QUANTITY /MINUTE /THREAD /COMMIT BP0 SORT/MERGE QUANTITY /MINUTE /THREAD /COMMIT
------------------------ -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
BUFFER UPDATES 0 0.00 0.00 0.00 MAX WORKFILES CONCURR USED 0 0.00 0.00 0.00
PAGES WRITTEN 0 0.00 0.00 0.00 MERGE PASSES REQUESTED 0 0.00 0.00 0.00
BUFF UPDATE/PAGE WRITTEN N/P MERGE PASS DEGRADE-LOW BUF 0 0.00 0.00 0.00
WRKFILE REQ REJCTD LOW BUF 0 0.00 0.00 0.00
SYNCHRONOUS WRITES 0 0.00 0.00 0.00 WRKFILE REQ-ALL MERGE PASS 0 0.00 0.00 0.00
ASYNCHRONOUS WRITES 0 0.00 0.00 0.00 WORKFILE PRF NOT SCHEDULED 0 0.00 0.00 0.00
WORKFILE PAGES TO DESTRUCT 0 0.00 0.00 0.00
PAGES WRITTEN/WRITE I/O N/P WORKFILE PAGES NOT WRITTEN 0 0.00 0.00 0.00
WORKFILE NOT CREATED NOBUF 0 0.00 0.00 0.00
HORIZ DEF WRITE THRESH 0 0.00 0.00 0.00
VERTI DEF WRITE THRESH 0 0.00 0.00 0.00
DM CRITICAL THRESHOLD 0 0.00 0.00 0.00
WRITE ENGINE NOT AVAIL N/P 0.00 0.00 0.00
PAGE INS REQ FOR WRITE 0 0.00 0.00 0.00
SYNC HPOOL WRITE N/P 0.00 0.00 0.00
ASYNC HPOOL WRITE N/P 0.00 0.00 0.00
HPOOL WRITE FAILED N/P 0.00 0.00 0.00
ASYN DA MVR HPOOL WRIT-S N/P 0.00 0.00 0.00
ASYN DA MVR HPOOL WRIT-F N/P 0.00 0.00 0.00
NBR PAGES UNLOCK CASTOUT 0 0.00 0.00 0.00
NBR I/O ON CASTOUT 0 0.00 0.00 0.00
1 BSTATLT : STATISTICS LONG TRACE 02/23/15 08:10:17 PAGE 565
GROUP : DB2 STATISTICS TRACE - LONG DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:54:00.11 END RECORD: ( 15.054 ) 02/23/15 07:55:00.41
ELAPSED TIME: 00:01:00.30 THREADS: 12 #DBATS: 0 COMMITS: 12 INCREMENTAL BIND: 2
BUFFER POOL BP1 QUANTITY /MINUTE /THREAD /COMMIT BP1 READ OPERATIONS QUANTITY /MINUTE /THREAD /COMMIT
------------------------ -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
CURRENT ACTIVE BUFFERS 6 N/A N/A N/A GETPAGE REQUESTS 1784 1775.01 148.67 148.67
UNAVAIL BUF-VPOOL FULL 0 0.00 0.00 0.00 GETPAGE REQUEST-SEQUENTIAL 549 546.23 45.75 45.75
GETPAGE REQUEST-RANDOM N/A N/A N/A N/A
NUMBER OF DATASET OPENS 0 0.00 0.00 0.00
SYNCHRONOUS READS 0 0.00 0.00 0.00
BUFFERS ALLOCATED-VPOOL 6656 N/A N/A N/A SYNCHRON READS-SEQUENTIAL 0 0.00 0.00 0.00
BUFFERS ALLOCATED-HPOOL N/P N/A N/A N/A SYNCHRON READS-RANDOM N/A N/A N/A N/A
HPOOL BUFFERS BACKED N/P N/A N/A N/A
GETPAGE PER SYNCH READS N/P
DFHSM MIGRATED DATASETS 0 0.00 0.00 0.00
DFHSM RECALL TIMEOUTS 0 0.00 0.00 0.00 SEQUENT'L PREFETCH REQUEST 0 0.00 0.00 0.00
SEQUENTIAL PREFETCH READS 0 0.00 0.00 0.00
HPOOL EXPAND/CONTRACT N/P 0.00 0.00 0.00 PAGES READ VIA SEQ PREF 0 0.00 0.00 0.00
VPOOL EXPAND/CONTRACT 0 0.00 0.00 0.00 S PRF PAGE READ/S PRF READ N/P
VPOOL/HPOOL EXP FAILURE 0 0.00 0.00 0.00
LIST PREFETCH REQUESTS 0 0.00 0.00 0.00
CONCUR PREF I/O - HWM 0 0.00 0.00 0.00 LIST PREFETCH READS 0 0.00 0.00 0.00
PREF I/O STREAM REDUCED 0 0.00 0.00 0.00 PAGES READ VIA LIST PREF 0 0.00 0.00 0.00
PARALLEL QUERY REQUESTS 0 0.00 0.00 0.00 L PRF PAGE READ/L PRF READ N/P
PARALL QUERY REQ REDUCED 0 0.00 0.00 0.00
PREF QUANT REDUCED 1/2 0 0.00 0.00 0.00 DYNAMIC PREFETCH REQUESTED 0 0.00 0.00 0.00
PREF QUANT REDUCED 1/4 0 0.00 0.00 0.00 DYNAMIC PREFETCH READS 0 0.00 0.00 0.00
PAGES READ VIA DYN PREFTCH 0 0.00 0.00 0.00
D PRF PAGE READ/D PRF READ N/P
PREF DISABLED - NO BUFFER 0 0.00 0.00 0.00
PREF DISABLED-NO READ ENG 0 0.00 0.00 0.00
PAGE INS REQUIRED FOR READ 0 0.00 0.00 0.00
SYNC HPOOL READ N/P 0.00 0.00 0.00
ASYNC HPOOL READ N/P 0.00 0.00 0.00
HPOOL READ FAILED N/P 0.00 0.00 0.00
ASYN DA MOVR HPOOL READ-S N/P 0.00 0.00 0.00
ASYN DA MOVR HPOOL READ-F N/P 0.00 0.00 0.00
BPOOL HIT RATIO (%) 100.00
HPOOL HIT RATIO (%) 0.00
HPOOL R/W RATIO (%) N/P
1 BSTATLT : STATISTICS LONG TRACE 02/23/15 08:10:17 PAGE 566
GROUP : DB2 STATISTICS TRACE - LONG DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:54:00.11 END RECORD: ( 15.054 ) 02/23/15 07:55:00.41
ELAPSED TIME: 00:01:00.30 THREADS: 12 #DBATS: 0 COMMITS: 12 INCREMENTAL BIND: 2
BP1 WRITE OPERATIONS QUANTITY /MINUTE /THREAD /COMMIT BP1 SORT/MERGE QUANTITY /MINUTE /THREAD /COMMIT
------------------------ -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
BUFFER UPDATES 1539 1531.24 128.25 128.25 MAX WORKFILES CONCURR USED 0 0.00 0.00 0.00
PAGES WRITTEN 0 0.00 0.00 0.00 MERGE PASSES REQUESTED 0 0.00 0.00 0.00
BUFF UPDATE/PAGE WRITTEN N/P MERGE PASS DEGRADE-LOW BUF 0 0.00 0.00 0.00
WRKFILE REQ REJCTD LOW BUF 0 0.00 0.00 0.00
SYNCHRONOUS WRITES 0 0.00 0.00 0.00 WRKFILE REQ-ALL MERGE PASS 0 0.00 0.00 0.00
ASYNCHRONOUS WRITES 0 0.00 0.00 0.00 WORKFILE PRF NOT SCHEDULED 0 0.00 0.00 0.00
WORKFILE PAGES TO DESTRUCT 0 0.00 0.00 0.00
PAGES WRITTEN/WRITE I/O N/P WORKFILE PAGES NOT WRITTEN 0 0.00 0.00 0.00
WORKFILE NOT CREATED NOBUF 0 0.00 0.00 0.00
HORIZ DEF WRITE THRESH 0 0.00 0.00 0.00
VERTI DEF WRITE THRESH 0 0.00 0.00 0.00
DM CRITICAL THRESHOLD 0 0.00 0.00 0.00
WRITE ENGINE NOT AVAIL N/P 0.00 0.00 0.00
PAGE INS REQ FOR WRITE 0 0.00 0.00 0.00
SYNC HPOOL WRITE N/P 0.00 0.00 0.00
ASYNC HPOOL WRITE N/P 0.00 0.00 0.00
HPOOL WRITE FAILED N/P 0.00 0.00 0.00
ASYN DA MVR HPOOL WRIT-S N/P 0.00 0.00 0.00
ASYN DA MVR HPOOL WRIT-F N/P 0.00 0.00 0.00
NBR PAGES UNLOCK CASTOUT 0 0.00 0.00 0.00
NBR I/O ON CASTOUT 0 0.00 0.00 0.00
1 BSTATLT : STATISTICS LONG TRACE 02/23/15 08:10:17 PAGE 567
GROUP : DB2 STATISTICS TRACE - LONG DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:54:00.11 END RECORD: ( 15.054 ) 02/23/15 07:55:00.41
ELAPSED TIME: 00:01:00.30 THREADS: 12 #DBATS: 0 COMMITS: 12 INCREMENTAL BIND: 2
BUFFER POOL BP8K0 QUANTITY /MINUTE /THREAD /COMMIT BP8K0 READ OPERATIONS QUANTITY /MINUTE /THREAD /COMMIT
------------------------ -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
CURRENT ACTIVE BUFFERS 0 N/A N/A N/A GETPAGE REQUESTS 5 4.97 0.42 0.42
UNAVAIL BUF-VPOOL FULL 0 0.00 0.00 0.00 GETPAGE REQUEST-SEQUENTIAL 0 0.00 0.00 0.00
GETPAGE REQUEST-RANDOM N/A N/A N/A N/A
NUMBER OF DATASET OPENS 0 0.00 0.00 0.00
SYNCHRONOUS READS 0 0.00 0.00 0.00
BUFFERS ALLOCATED-VPOOL 128 N/A N/A N/A SYNCHRON READS-SEQUENTIAL 0 0.00 0.00 0.00
BUFFERS ALLOCATED-HPOOL N/P N/A N/A N/A SYNCHRON READS-RANDOM N/A N/A N/A N/A
HPOOL BUFFERS BACKED N/P N/A N/A N/A
GETPAGE PER SYNCH READS N/P
DFHSM MIGRATED DATASETS 0 0.00 0.00 0.00
DFHSM RECALL TIMEOUTS 0 0.00 0.00 0.00 SEQUENT'L PREFETCH REQUEST 0 0.00 0.00 0.00
SEQUENTIAL PREFETCH READS 0 0.00 0.00 0.00
HPOOL EXPAND/CONTRACT N/P 0.00 0.00 0.00 PAGES READ VIA SEQ PREF 0 0.00 0.00 0.00
VPOOL EXPAND/CONTRACT 0 0.00 0.00 0.00 S PRF PAGE READ/S PRF READ N/P
VPOOL/HPOOL EXP FAILURE 0 0.00 0.00 0.00
LIST PREFETCH REQUESTS 0 0.00 0.00 0.00
CONCUR PREF I/O - HWM 0 0.00 0.00 0.00 LIST PREFETCH READS 0 0.00 0.00 0.00
PREF I/O STREAM REDUCED 0 0.00 0.00 0.00 PAGES READ VIA LIST PREF 0 0.00 0.00 0.00
PARALLEL QUERY REQUESTS 0 0.00 0.00 0.00 L PRF PAGE READ/L PRF READ N/P
PARALL QUERY REQ REDUCED 0 0.00 0.00 0.00
PREF QUANT REDUCED 1/2 0 0.00 0.00 0.00 DYNAMIC PREFETCH REQUESTED 0 0.00 0.00 0.00
PREF QUANT REDUCED 1/4 0 0.00 0.00 0.00 DYNAMIC PREFETCH READS 0 0.00 0.00 0.00
PAGES READ VIA DYN PREFTCH 0 0.00 0.00 0.00
D PRF PAGE READ/D PRF READ N/P
PREF DISABLED - NO BUFFER 0 0.00 0.00 0.00
PREF DISABLED-NO READ ENG 0 0.00 0.00 0.00
PAGE INS REQUIRED FOR READ 0 0.00 0.00 0.00
SYNC HPOOL READ N/P 0.00 0.00 0.00
ASYNC HPOOL READ N/P 0.00 0.00 0.00
HPOOL READ FAILED N/P 0.00 0.00 0.00
ASYN DA MOVR HPOOL READ-S N/P 0.00 0.00 0.00
ASYN DA MOVR HPOOL READ-F N/P 0.00 0.00 0.00
BPOOL HIT RATIO (%) 100.00
HPOOL HIT RATIO (%) 0.00
HPOOL R/W RATIO (%) N/P
1 BSTATLT : STATISTICS LONG TRACE 02/23/15 08:10:17 PAGE 568
GROUP : DB2 STATISTICS TRACE - LONG DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:54:00.11 END RECORD: ( 15.054 ) 02/23/15 07:55:00.41
ELAPSED TIME: 00:01:00.30 THREADS: 12 #DBATS: 0 COMMITS: 12 INCREMENTAL BIND: 2
BP8K0 WRITE OPERATIONS QUANTITY /MINUTE /THREAD /COMMIT BP8K0 SORT/MERGE QUANTITY /MINUTE /THREAD /COMMIT
------------------------ -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
BUFFER UPDATES 0 0.00 0.00 0.00 MAX WORKFILES CONCURR USED 0 0.00 0.00 0.00
PAGES WRITTEN 0 0.00 0.00 0.00 MERGE PASSES REQUESTED 0 0.00 0.00 0.00
BUFF UPDATE/PAGE WRITTEN N/P MERGE PASS DEGRADE-LOW BUF 0 0.00 0.00 0.00
WRKFILE REQ REJCTD LOW BUF 0 0.00 0.00 0.00
SYNCHRONOUS WRITES 0 0.00 0.00 0.00 WRKFILE REQ-ALL MERGE PASS 0 0.00 0.00 0.00
ASYNCHRONOUS WRITES 0 0.00 0.00 0.00 WORKFILE PRF NOT SCHEDULED 0 0.00 0.00 0.00
WORKFILE PAGES TO DESTRUCT 0 0.00 0.00 0.00
PAGES WRITTEN/WRITE I/O N/P WORKFILE PAGES NOT WRITTEN 0 0.00 0.00 0.00
WORKFILE NOT CREATED NOBUF 0 0.00 0.00 0.00
HORIZ DEF WRITE THRESH 0 0.00 0.00 0.00
VERTI DEF WRITE THRESH 0 0.00 0.00 0.00
DM CRITICAL THRESHOLD 0 0.00 0.00 0.00
WRITE ENGINE NOT AVAIL N/P 0.00 0.00 0.00
PAGE INS REQ FOR WRITE 0 0.00 0.00 0.00
SYNC HPOOL WRITE N/P 0.00 0.00 0.00
ASYNC HPOOL WRITE N/P 0.00 0.00 0.00
HPOOL WRITE FAILED N/P 0.00 0.00 0.00
ASYN DA MVR HPOOL WRIT-S N/P 0.00 0.00 0.00
ASYN DA MVR HPOOL WRIT-F N/P 0.00 0.00 0.00
NBR PAGES UNLOCK CASTOUT 0 0.00 0.00 0.00
NBR I/O ON CASTOUT 0 0.00 0.00 0.00
1 BSTATLT : STATISTICS LONG TRACE 02/23/15 08:10:17 PAGE 569
GROUP : DB2 STATISTICS TRACE - LONG DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:54:00.11 END RECORD: ( 15.054 ) 02/23/15 07:55:00.41
ELAPSED TIME: 00:01:00.30 THREADS: 12 #DBATS: 0 COMMITS: 12 INCREMENTAL BIND: 2
BUFFER POOL BP16K0 QUANTITY /MINUTE /THREAD /COMMIT BP16K0 READ OPERATIONS QUANTITY /MINUTE /THREAD /COMMIT
------------------------ -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
CURRENT ACTIVE BUFFERS 0 N/A N/A N/A GETPAGE REQUESTS 2 1.99 0.17 0.17
UNAVAIL BUF-VPOOL FULL 0 0.00 0.00 0.00 GETPAGE REQUEST-SEQUENTIAL 0 0.00 0.00 0.00
GETPAGE REQUEST-RANDOM N/A N/A N/A N/A
NUMBER OF DATASET OPENS 0 0.00 0.00 0.00
SYNCHRONOUS READS 1 0.99 0.08 0.08
BUFFERS ALLOCATED-VPOOL 64 N/A N/A N/A SYNCHRON READS-SEQUENTIAL 0 0.00 0.00 0.00
BUFFERS ALLOCATED-HPOOL N/P N/A N/A N/A SYNCHRON READS-RANDOM N/A N/A N/A N/A
HPOOL BUFFERS BACKED N/P N/A N/A N/A
GETPAGE PER SYNCH READS 2.00
DFHSM MIGRATED DATASETS 0 0.00 0.00 0.00
DFHSM RECALL TIMEOUTS 0 0.00 0.00 0.00 SEQUENT'L PREFETCH REQUEST 0 0.00 0.00 0.00
SEQUENTIAL PREFETCH READS 0 0.00 0.00 0.00
HPOOL EXPAND/CONTRACT N/P 0.00 0.00 0.00 PAGES READ VIA SEQ PREF 0 0.00 0.00 0.00
VPOOL EXPAND/CONTRACT 0 0.00 0.00 0.00 S PRF PAGE READ/S PRF READ N/P
VPOOL/HPOOL EXP FAILURE 0 0.00 0.00 0.00
LIST PREFETCH REQUESTS 0 0.00 0.00 0.00
CONCUR PREF I/O - HWM 0 0.00 0.00 0.00 LIST PREFETCH READS 0 0.00 0.00 0.00
PREF I/O STREAM REDUCED 0 0.00 0.00 0.00 PAGES READ VIA LIST PREF 0 0.00 0.00 0.00
PARALLEL QUERY REQUESTS 0 0.00 0.00 0.00 L PRF PAGE READ/L PRF READ N/P
PARALL QUERY REQ REDUCED 0 0.00 0.00 0.00
PREF QUANT REDUCED 1/2 0 0.00 0.00 0.00 DYNAMIC PREFETCH REQUESTED 0 0.00 0.00 0.00
PREF QUANT REDUCED 1/4 0 0.00 0.00 0.00 DYNAMIC PREFETCH READS 0 0.00 0.00 0.00
PAGES READ VIA DYN PREFTCH 0 0.00 0.00 0.00
D PRF PAGE READ/D PRF READ N/P
PREF DISABLED - NO BUFFER 0 0.00 0.00 0.00
PREF DISABLED-NO READ ENG 0 0.00 0.00 0.00
PAGE INS REQUIRED FOR READ 1 0.99 0.08 0.08
SYNC HPOOL READ N/P 0.00 0.00 0.00
ASYNC HPOOL READ N/P 0.00 0.00 0.00
HPOOL READ FAILED N/P 0.00 0.00 0.00
ASYN DA MOVR HPOOL READ-S N/P 0.00 0.00 0.00
ASYN DA MOVR HPOOL READ-F N/P 0.00 0.00 0.00
BPOOL HIT RATIO (%) 50.00
HPOOL HIT RATIO (%) 0.00
HPOOL R/W RATIO (%) N/P
1 BSTATLT : STATISTICS LONG TRACE 02/23/15 08:10:17 PAGE 570
GROUP : DB2 STATISTICS TRACE - LONG DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:54:00.11 END RECORD: ( 15.054 ) 02/23/15 07:55:00.41
ELAPSED TIME: 00:01:00.30 THREADS: 12 #DBATS: 0 COMMITS: 12 INCREMENTAL BIND: 2
BP16K0 WRITE OPERATIONS QUANTITY /MINUTE /THREAD /COMMIT BP16K0 SORT/MERGE QUANTITY /MINUTE /THREAD /COMMIT
------------------------ -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
BUFFER UPDATES 0 0.00 0.00 0.00 MAX WORKFILES CONCURR USED 0 0.00 0.00 0.00
PAGES WRITTEN 0 0.00 0.00 0.00 MERGE PASSES REQUESTED 0 0.00 0.00 0.00
BUFF UPDATE/PAGE WRITTEN N/P MERGE PASS DEGRADE-LOW BUF 0 0.00 0.00 0.00
WRKFILE REQ REJCTD LOW BUF 0 0.00 0.00 0.00
SYNCHRONOUS WRITES 0 0.00 0.00 0.00 WRKFILE REQ-ALL MERGE PASS 0 0.00 0.00 0.00
ASYNCHRONOUS WRITES 0 0.00 0.00 0.00 WORKFILE PRF NOT SCHEDULED 0 0.00 0.00 0.00
WORKFILE PAGES TO DESTRUCT 0 0.00 0.00 0.00
PAGES WRITTEN/WRITE I/O N/P WORKFILE PAGES NOT WRITTEN 0 0.00 0.00 0.00
WORKFILE NOT CREATED NOBUF 0 0.00 0.00 0.00
HORIZ DEF WRITE THRESH 0 0.00 0.00 0.00
VERTI DEF WRITE THRESH 0 0.00 0.00 0.00
DM CRITICAL THRESHOLD 0 0.00 0.00 0.00
WRITE ENGINE NOT AVAIL N/P 0.00 0.00 0.00
PAGE INS REQ FOR WRITE 0 0.00 0.00 0.00
SYNC HPOOL WRITE N/P 0.00 0.00 0.00
ASYNC HPOOL WRITE N/P 0.00 0.00 0.00
HPOOL WRITE FAILED N/P 0.00 0.00 0.00
ASYN DA MVR HPOOL WRIT-S N/P 0.00 0.00 0.00
ASYN DA MVR HPOOL WRIT-F N/P 0.00 0.00 0.00
NBR PAGES UNLOCK CASTOUT 0 0.00 0.00 0.00
NBR I/O ON CASTOUT 0 0.00 0.00 0.00
1 BSTATLT : STATISTICS LONG TRACE 02/23/15 08:10:17 PAGE 571
GROUP : DB2 STATISTICS TRACE - LONG DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:54:00.11 END RECORD: ( 15.054 ) 02/23/15 07:55:00.41
ELAPSED TIME: 00:01:00.30 THREADS: 12 #DBATS: 0 COMMITS: 12 INCREMENTAL BIND: 2
12
BUFFER POOL BP TOT QUANTITY /MINUTE /THREAD /COMMIT BP TOT READ OPERATIONS QUANTITY /MINUTE /THREAD /COMMIT
------------------------ -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
CURRENT ACTIVE BUFFERS 18 N/A N/A N/A GETPAGE REQUESTS 440618 438397 36718.2 36718.2
UNAVAIL BUF-VPOOL FULL 0 0.00 0.00 0.00 GETPAGE REQUEST-SEQUENTIAL 660 656.67 55.00 55.00
GETPAGE REQUEST-RANDOM 439958 437740 36663.2 36663.2
NUMBER OF DATASET OPENS 1 0.99 0.08 0.08
SYNCHRONOUS READS 2176 2165.03 181.33 181.33
BUFFERS ALLOCATED-VPOOL 2212 N/A N/A N/A SYNCHRON READS-SEQUENTIAL 109 108.45 9.08 9.08
BUFFERS ALLOCATED-HPOOL N/P N/A N/A N/A SYNCHRON READS-RANDOM 2067 2056.58 172.25 172.25
HPOOL BUFFERS BACKED N/P N/A N/A N/A
GETPAGE PER SYNCH READS 212.85
DFHSM MIGRATED DATASETS 0 0.00 0.00 0.00
DFHSM RECALL TIMEOUTS 0 0.00 0.00 0.00 SEQUENT'L PREFETCH REQUEST 218 216.90 18.17 18.17
SEQUENTIAL PREFETCH READS 109 108.45 9.08 9.08
HPOOL EXPAND/CONTRACT N/P 0.00 0.00 0.00 PAGES READ VIA SEQ PREF 981 976.05 81.75 81.75
VPOOL EXPAND/CONTRACT 0 0.00 0.00 0.00 S PRF PAGE READ/S PRF READ 9.00
VPOOL/HPOOL EXP FAILURE 0 0.00 0.00 0.00
LIST PREFETCH REQUESTS 8749 8704.90 729.08 729.08
CONCUR PREF I/O - HWM 0 0.00 0.00 0.00 LIST PREFETCH READS 8749 8704.90 729.08 729.08
PREF I/O STREAM REDUCED 0 0.00 0.00 0.00 PAGES READ VIA LIST PREF 216685 215593 18057.1 18057.1
PARALLEL QUERY REQUESTS 0 0.00 0.00 0.00 L PRF PAGE READ/L PRF READ 24.77
PARALL QUERY REQ REDUCED 0 0.00 0.00 0.00
PREF QUANT REDUCED 1/2 0 0.00 0.00 0.00 DYNAMIC PREFETCH REQUESTED 15344 15266.7 1278.67 1278.67
PREF QUANT REDUCED 1/4 0 0.00 0.00 0.00 DYNAMIC PREFETCH READS 13152 13085.7 1096.00 1096.00
PAGES READ VIA DYN PREFTCH 322343 320718 26861.9 26861.9
D PRF PAGE READ/D PRF READ 24.51
PREF DISABLED - NO BUFFER 0 0.00 0.00 0.00
PREF DISABLED-NO READ ENG 0 0.00 0.00 0.00
PAGE INS REQUIRED FOR READ 1 0.99 0.08 0.08
SYNC HPOOL READ N/P 0.00 0.00 0.00
ASYNC HPOOL READ N/P 0.00 0.00 0.00
HPOOL READ FAILED N/P 0.00 0.00 0.00
ASYN DA MOVR HPOOL READ-S N/P 0.00 0.00 0.00
ASYN DA MOVR HPOOL READ-F N/P 0.00 0.00 0.00
BPOOL HIT RATIO (%) 99.48
HPOOL HIT RATIO (%) 0.00
HPOOL R/W RATIO (%) N/P
1 BSTATLT : STATISTICS LONG TRACE 02/23/15 08:10:17 PAGE 572
GROUP : DB2 STATISTICS TRACE - LONG DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:54:00.11 END RECORD: ( 15.054 ) 02/23/15 07:55:00.41
ELAPSED TIME: 00:01:00.30 THREADS: 12 #DBATS: 0 COMMITS: 12 INCREMENTAL BIND: 2
BP TOT WRITE OPERATIONS QUANTITY /MINUTE /THREAD /COMMIT BP TOT SORT/MERGE QUANTITY /MINUTE /THREAD /COMMIT
------------------------ -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
BUFFER UPDATES 1539 1531.24 128.25 128.25 MAX WORKFILES CONCURR USED 0 0.00 0.00 0.00
PAGES WRITTEN 0 0.00 0.00 0.00 MERGE PASSES REQUESTED 0 0.00 0.00 0.00
BUFF UPDATE/PAGE WRITTEN N/P MERGE PASS DEGRADE-LOW BUF 0 0.00 0.00 0.00
WRKFILE REQ REJCTD LOW BUF 0 0.00 0.00 0.00
SYNCHRONOUS WRITES 0 0.00 0.00 0.00 WRKFILE REQ-ALL MERGE PASS 0 0.00 0.00 0.00
ASYNCHRONOUS WRITES 0 0.00 0.00 0.00 WORKFILE PRF NOT SCHEDULED 0 0.00 0.00 0.00
WORKFILE PAGES TO DESTRUCT 0 0.00 0.00 0.00
PAGES WRITTEN/WRITE I/O N/P WORKFILE PAGES NOT WRITTEN 0 0.00 0.00 0.00
WORKFILE NOT CREATED NOBUF 0 0.00 0.00 0.00
HORIZ DEF WRITE THRESH 0 0.00 0.00 0.00
VERTI DEF WRITE THRESH 0 0.00 0.00 0.00
DM CRITICAL THRESHOLD 0 0.00 0.00 0.00
WRITE ENGINE NOT AVAIL N/P 0.00 0.00 0.00
PAGE INS REQ FOR WRITE 0 0.00 0.00 0.00
SYNC HPOOL WRITE N/P 0.00 0.00 0.00
ASYNC HPOOL WRITE N/P 0.00 0.00 0.00
HPOOL WRITE FAILED N/P 0.00 0.00 0.00
ASYN DA MVR HPOOL WRIT-S N/P 0.00 0.00 0.00
ASYN DA MVR HPOOL WRIT-F N/P 0.00 0.00 0.00
NBR PAGES UNLOCK CASTOUT 0 0.00 0.00 0.00
NBR I/O ON CASTOUT 0 0.00 0.00 0.00
1 BSTATLT : STATISTICS LONG TRACE 02/23/15 08:10:17 PAGE 573
GROUP : DB2 STATISTICS TRACE - LONG DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:54:00.11 END RECORD: ( 15.054 ) 02/23/15 07:55:00.41
ELAPSED TIME: 00:01:00.30 THREADS: 12 #DBATS: 0 COMMITS: 12 INCREMENTAL BIND: 2
GROUP BUFFER POOL GBP TOT QUANTITY /MINUTE /THREAD /COMMIT P GBP TOT QUANTITY /MINUTE /THREAD /COMMIT
------------------------- -------- ------- ------- ------- P -------------------------- -------- ------- ------- -------
P GBP DEPENDENT GETPAGES N/P 0.00 0.00 0.00
SYNC READS(XI)DATA RET N/P 0.00 0.00 0.00 P REGISTER PAGE LIST REQUEST N/P 0.00 0.00 0.00
SYNC READS(XI) NO DATA N/P 0.00 0.00 0.00 P CHANGED PGS READ AFTER RPL N/P 0.00 0.00 0.00
SYNC READS(NF)DATA RET N/P 0.00 0.00 0.00 P PAGES CASTOUT N/P 0.00 0.00 0.00
SYNC READS(NF) NO DATA N/P 0.00 0.00 0.00 P PAGES CASTOUT THRESH N/P 0.00 0.00 0.00
P CASTOUT CLASS THRESHOLD N/P 0.00 0.00 0.00
NUM UNREGTR PAGE REQTS N/P 0.00 0.00 0.00 P GROUP BP CASTOUT THRESHOLD N/P 0.00 0.00 0.00
CLEAN PAGES SYNC WRITE N/P 0.00 0.00 0.00 P WRITE FAILED- NO STORAGE N/P 0.00 0.00 0.00
CHANGED PGS SYNC WRITE N/P 0.00 0.00 0.00 P NUMBER UNLOCK CASTOUT N/P 0.00 0.00 0.00
CLEAN PAGES ASYNC WRITE N/P 0.00 0.00 0.00 P #IXLCACHE READ CASTOUT N/P 0.00 0.00 0.00
CHANGED PGS ASYNC WRITE N/P 0.00 0.00 0.00 P #IXLCACHE READ DIR INFO N/P 0.00 0.00 0.00
P NBR REGISTER PAGE REQTS N/P 0.00 0.00 0.00
TOT PAGE P-LOCK LOCK REQ 0 P NBR IXLCACHE DELETE NAME N/P 0.00 0.00 0.00
SPACE MAP PAGES N/P P NBR ASYNC IXLCACHE PRIM N/P 0.00 0.00 0.00
DATA PAGES N/P P NBR EXPL CROSS VALIDATE N/P 0.00 0.00 0.00
INDEX LEAF PAGES N/P P NBR GBP CHCKPT TRIGGERED N/P 0.00 0.00 0.00
PAGE P-LOCK UNLOCK REQ N/P P NBR FAILED WRT CHD PAGES N/P 0.00 0.00 0.00
TOT PAGE P-LOCK LOCK SUSP 0 P NBR DEL NM LST REQS 2ND GBP N/P 0.00 0.00 0.00
SPACE MAP PAGES N/P P NBR DEL NM REQS TO 2ND GBP N/P 0.00 0.00 0.00
DATA PAGES N/P P NBR READ CASTOUT TO 2ND GBP N/P 0.00 0.00 0.00
INDEX LEAF PAGES N/P P NBR ASYNC IXLCACHE 2ND GBP N/P 0.00 0.00 0.00
TOT PAGE P-LOCK LOCK NEG 0 P
SPACE MAP PAGES N/P P
DATA PAGES N/P P OTHER REQUESTS N/P 0.00 0.00 0.00
INDEX LEAF PAGES N/P P
P
ACCELERATOR SERVER NAME: IDAAVIPA PRODUCT ID: AQT04010 STATE: ONLINE
--------------------------------------------------------------------------------------------------------------------------
QUERIES SUCCESSFULLY EXECUTED 0.00 AVG QUEUE LENGTH (LAST 3 HOURS) N/A
QUERIES FAILED TO EXECUTE 0.00 AVG QUEUE LENGTH (LAST 24 HOURS) N/A
ACCELERATOR IN INVALID STATE N/A MAXIMUM QUEUE LENGTH 0.00
CURRENTLY EXECUTING QUERIES N/A CURRENT QUEUE LENGTH 0.00
MAXIMUM EXECUTING QUERIES N/A MAX QUEUE WAIT ELAPSED TIME 00:00:00.207246
AVG QUEUE WAIT ELAPSED TIME 00:00:00.000000
CONNECTS TO ACCELERATOR 1.00 WORKER NODES 4.00
REQUESTS SENT TO ACCELERATOR 1.00 WORKER NODES AVG CPU UTILIZATION (%) N/A
TIMED OUT 0.00 WORKER NODES CUR CPU UTILIZATION (%) 30.00
FAILED 0.00
BYTES SENT TO ACCELERATOR 2702.00 DISK STORAGE AVAILABLE (MB) 8024544.00
BYTES RECEIVED FROM ACCELERATOR 828.00 IN USE FOR DATABASE (MB) 110.00
MESSAGES SENT TO ACCELERATOR 11.00 CUR DISK UTIL ON WORKER NODES 0.00
MESSAGES RECEIVED FROM ACCEL 0.00 DATA SLICES 22.00
BLOCKS SENT TO ACCELERATOR 0.00 DATA SKEW (%) N/A
BLOCKS RECEIVED FROM ACCELERATOR 0.00
ROWS SENT TO ACCELERATOR 0.00 PROCESSORS 64.00
ROWS RECEIVED FROM ACCELERATOR 0.00
ELAPSED TIME IN ACCELERATOR 00:00:00.000000
TCP/IP SERVICES ELAPSED TIME 00:00:00.011760 CPU TIME SPENT IN ACCELERATOR 00:00:00.000000
TCP/IP SERVICES CPU TIME 00:00:00.001305 WAIT TIME IN ACCELERATOR 00:00:00.000000
1 BSTATLT : STATISTICS LONG TRACE 02/23/15 08:10:17 PAGE 574
GROUP : DB2 STATISTICS TRACE - LONG DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:54:00.11 END RECORD: ( 15.054 ) 02/23/15 07:55:00.41
ELAPSED TIME: 00:01:00.30 THREADS: 12 #DBATS: 0 COMMITS: 12 INCREMENTAL BIND: 2
TIME LAST ACCEL STATUS CHANGE 2015-02-17-18.40.24
TIME ACCELERATOR PROCESS STARTED 2015-02-17-18.40.16 COORDINATOR AVG CPU UTILIZATION (%) N/A
TIME LAST REPLICATION STATUS CHANGE N/P COORDINATOR CUR CPU UTILIZATION (%) 0.99
BY ALL DB2 SUBSYSTEMS BY THIS DB2 (DEFG)
SUCCESSFUL QUERIES SENT 0.00 CURRENT QUERIES EXECUTING 1.00
FAILED QUERIES SENT 0.00 MAX QUERIES EXECUTED 3.00
CURRENT QUERIES EXECUTING 1.00 TOTAL QUERY CPU COST 00:00:00.00
MAX QUERIES EXECUTED 3.00 TOTAL MAINT CPU COST 00:00:00.00
TOTAL QUERY CPU COST 00:00:00.000000
TOTAL MAINT CPU COST 00:00:00.000000 CAPTURE AGENT
DISK SPACE (MB) 707.00 LOG RECORDS READ N/P
REPLICATION APPLY CPU COST 00:00:00.000000 LOG RECORDS PROCESSED N/P
BYTES PROCESSED N/P
CAPTURE AGENT INSERTED ROWS N/P
LOG RECORDS READ N/P UPDATED ROWS N/P
LOG RECORDS PROCESSED N/P DELETED ROWS N/P
BYTES PROCESSED N/P CURRENT REPLICATION LATENCY N/P
INSERTED ROWS N/P CURRENT REPLICATION STATE UNKNOWN
UPDATED ROWS N/P
DELETED ROWS N/P
GROUP : DB2 STATISTICS TRACE - LONG DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:54:00.11 END RECORD: ( 15.054 ) 02/23/15 07:55:00.41
ELAPSED TIME: 00:01:00.30 THREADS: 12 #DBATS: 0 COMMITS: 12 INCREMENTAL BIND: 2
SQL DML QUANTITY /MINUTE /THREAD /COMMIT SQL DCL QUANTITY /MINUTE /THREAD /COMMIT
------------------------- -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
SELECT 0 0.00 0.00 0.00 LOCK TABLE 0 0.00 0.00 0.00
INSERT 0 0.00 0.00 0.00 GRANT 0 0.00 0.00 0.00
UPDATE 1 0.99 0.08 0.08 REVOKE 0 0.00 0.00 0.00
DELETE 0 0.00 0.00 0.00 SET CURRENT SQLID 0 0.00 0.00 0.00
SET HOST VARIABLE 12 11.94 1.00 1.00
PREPARE 219 217.90 18.25 18.25 SET CURRENT DEGREE 109 108.45 9.08 9.08
DESCRIBE 219 217.90 18.25 18.25 SET CURRENT RULES 0 0.00 0.00 0.00
DESCRIBE TABLE 0 0.00 0.00 0.00 CONNECT TYPE 1 0 0.00 0.00 0.00
OPEN CURSOR 111 110.44 9.25 9.25 CONNECT TYPE 2 0 0.00 0.00 0.00
CLOSE CURSOR 110 109.45 9.17 9.17 RELEASE 0 0.00 0.00 0.00
FETCH 219 217.90 18.25 18.25 SET CONNECTION 0 0.00 0.00 0.00
ROWS FETCHED 110 109.45 9.17 9.17 SET CURRENT PATH 0 0.00 0.00 0.00
ROWS INSERTED 0 0.00 0.00 0.00 SET CURRENT PRECISION 0 0.00 0.00 0.00
ROWS UPDATED 1 0.99 0.08 0.08
ROWS DELETED 0 0.00 0.00 0.00
ASSOCIATE LOCATORS 0 0.00 0.00 0.00
ALLOCATE LOCATORS 0 0.00 0.00 0.00
TOTAL 879 874.57 73.25 73.25 HOLD LOCATOR 0 0.00 0.00 0.00
FREE LOCATOR 0 0.00 0.00 0.00
TOTAL 121 120.39 10.08 10.08
STORED PROCEDURES QUANTITY /MINUTE /THREAD /COMMIT TRIGGERS QUANTITY /MINUTE /THREAD /COMMIT
------------------------- -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
CALL STATEMENTS EXECUTED 0 0.00 0.00 0.00 STATEMENT TRIGGER ACTIV 0 0.00 0.00 0.00
PROCEDURE ABENDED 0 0.00 0.00 0.00 ROW TRIGGER ACTIVATED 0 0.00 0.00 0.00
CALL STATEMENT TIMED OUT 0 0.00 0.00 0.00 SQL ERROR OCCURRED 0 0.00 0.00 0.00
CALL STATEMENT REJECTED 0 0.00 0.00 0.00
USER DEFINED FUNCTIONS QUANTITY /MINUTE /THREAD /COMMIT
------------------------- -------- ------- ------- -------
EXECUTED 0 0.00 0.00 0.00
ABENDED 0 0.00 0.00 0.00
TIMED OUT 0 0.00 0.00 0.00
REJECTED 0 0.00 0.00 0.00
1 BSTATLT : STATISTICS LONG TRACE 02/23/15 08:10:17 PAGE 553
GROUP : DB2 STATISTICS TRACE - LONG DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:54:00.11 END RECORD: ( 15.054 ) 02/23/15 07:55:00.41
ELAPSED TIME: 00:01:00.30 THREADS: 12 #DBATS: 0 COMMITS: 12 INCREMENTAL BIND: 2
SQL DDL QUANTITY /MINUTE /THREAD /COMMIT ROW ID QUANTITY /MINUTE /THREAD /COMMIT
------------------------- -------- ------- ------- ------- -------------------- -------- -------- -------- -------
CREATE TABLE 0 0.00 0.00 0.00 DIRECT ACCESS 0 0.00 0.00 0.00
CREATE GLBL TEMP TABLE 0 0.00 0.00 0.00 INDEX USED 0 0.00 0.00 0.00
DECLARE GLBL TEMP TABLE 0 0.00 0.00 0.00 TABLE SPACE SCAN USED 0 0.00 0.00 0.00
CREATE AUXILLARY TABLE 0 0.00 0.00 0.00
CREATE INDEX 0 0.00 0.00 0.00 STAR JOIN STATISTICS
CREATE VIEW 0 0.00 0.00 0.00 --------------------
CREATE SYNONYM 0 0.00 0.00 0.00 ALLOCATIONS IN SJ POOL 0 0.00 0.00 0.00
CREATE TABLESPACE 0 0.00 0.00 0.00 POOL FULL FAILURES 0 0.00 0.00 0.00
CREATE DATABASE 0 0.00 0.00 0.00 CURRENT SIZE IN MB 0 0.00 0.00 0.00
CREATE STOGROUP 0 0.00 0.00 0.00 MAX SIZE IN MB 0 0.00 0.00 0.00
CREATE ALIAS 0 0.00 0.00 0.00
CREATE DISTINCT TYPE 0 0.00 0.00 0.00
CREATE FUNCTION 0 0.00 0.00 0.00
CREATE PROCEDURE 0 0.00 0.00 0.00
CREATE TRIGGER 0 0.00 0.00 0.00
CREATE SEQUENCE 0 0.00 0.00 0.00
ALTER TABLE 0 0.00 0.00 0.00
ALTER INDEX 0 0.00 0.00 0.00
ALTER TABLESPACE 0 0.00 0.00 0.00
ALTER DATABASE 0 0.00 0.00 0.00
ALTER STOGROUP 0 0.00 0.00 0.00
ALTER FUNCTION 0 0.00 0.00 0.00
ALTER PROCEDURE 0 0.00 0.00 0.00
ALTER VIEW 0 0.00 0.00 0.00
ALTER SEQUENCE 0 0.00 0.00 0.00
DROP TABLE 0 0.00 0.00 0.00
DROP INDEX 0 0.00 0.00 0.00
DROP VIEW 0 0.00 0.00 0.00
DROP SYNONYM 0 0.00 0.00 0.00
DROP TABLESPACE 0 0.00 0.00 0.00
DROP DATABASE 0 0.00 0.00 0.00
DROP STOGROUP 0 0.00 0.00 0.00
DROP ALIAS 0 0.00 0.00 0.00
DROP PACKAGE 0 0.00 0.00 0.00
DROP DISTINCT TYPE 0 0.00 0.00 0.00
DROP FUNCTION 0 0.00 0.00 0.00
DROP PROCEDURE 0 0.00 0.00 0.00
DROP TRIGGER 0 0.00 0.00 0.00
DROP SEQUENCE 0 0.00 0.00 0.00
RENAME TABLE 0 0.00 0.00 0.00
COMMENT ON 0 0.00 0.00 0.00
LABEL ON 0 0.00 0.00 0.00
CREATE ROLE 0 0.00 0.00 0.00
CREATE TRUSTED CONTEXT 0 0.00 0.00 0.00
DROP ROLE 0 0.00 0.00 0.00
1 BSTATLT : STATISTICS LONG TRACE 02/23/15 08:10:17 PAGE 554
GROUP : DB2 STATISTICS TRACE - LONG DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:54:00.11 END RECORD: ( 15.054 ) 02/23/15 07:55:00.41
ELAPSED TIME: 00:01:00.30 THREADS: 12 #DBATS: 0 COMMITS: 12 INCREMENTAL BIND: 2
DROP TRUSTED CONTEXT 0 0.00 0.00 0.00
ALTER TRUSTED CONTEXT 0 0.00 0.00 0.00
ALTER JAR 0 0.00 0.00 0.00
RENAME INDEX COUNT 0 0.00 0.00 0.00
TOTAL 0 0.00 0.00 0.00
1 BSTATLT : STATISTICS LONG TRACE 02/23/15 08:10:17 PAGE 555
GROUP : DB2 STATISTICS TRACE - LONG DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:54:00.11 END RECORD: ( 15.054 ) 02/23/15 07:55:00.41
ELAPSED TIME: 00:01:00.30 THREADS: 12 #DBATS: 0 COMMITS: 12 INCREMENTAL BIND: 2
EDM POOL QUANTITY /MINUTE /THREAD /COMMIT SUBSYSTEM SERVICES QUANTITY /MINUTE /THREAD /COMMIT
------------------------- -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
PAGES IN EDM POOL 0 N/A N/A N/A IDENTIFY 1 0.99 0.08 0.08
% PAGES IN USE N/P CREATE THREAD 12 11.94 1.00 1.00
FREE PG/FREE CHAIN 0 N/A N/A N/A SIGNON 0 0.00 0.00 0.00
PAGES USED FOR CT 0 N/A N/A N/A TERMINATE 11 10.94 0.92 0.92
PAGES USED FOR DBD 98 N/A N/A N/A ROLLBACK 0 0.00 0.00 0.00
PAGES USED FOR SKCT 4 N/A N/A N/A
PAGES USED FOR PT 0 N/A N/A N/A COMMIT PHASE 1 0 0.00 0.00 0.00
PAGES USED FOR SKPT 8 N/A N/A N/A COMMIT PHASE 2 0 0.00 0.00 0.00
READ ONLY COMMIT 1 0.99 0.08 0.08
UNIT REC INDOUBT 0 0.00 0.00 0.00
FAILS DUE POOL FULL 0 0.00 0.00 0.00 UNIT REC INDBT RSLVD 0 0.00 0.00 0.00
CT REQUESTS 12 11.94 1.00 1.00 SYNCHS(SINGLE PHASE) 11 10.94 0.92 0.92
CT NOT IN EDMPOOL 0 0.00 0.00 0.00 Q'D CREATE THREAD 0 0.00 0.00 0.00
CT HIT RATIO 1.00 SUBSYSTEM MEMORY EOT 0 0.00 0.00 0.00
PT REQUESTS 49 48.75 4.08 4.08 SUBSYSTEM MEMORY EOM 0 0.00 0.00 0.00
PT NOT IN POOL 0 0.00 0.00 0.00 SYSTEM EVENT CHKPT 0 0.00 0.00 0.00
PT HIT RATIO 1.00 HIGH WATER MARK IDBACK 0 0.00 0.00 0.00
DBD REQUESTS 39 38.80 3.25 3.25 HIGH WATER MARK IDFORE 0 0.00 0.00 0.00
DBD NOT IN POOL 1 0.99 0.08 0.08 HIGH WATER MARK CTHREAD 0 0.00 0.00 0.00
DBD HIT RATIO 0.97
PAGES FOR DYN SQL CACHE N/P 0.00 0.00 0.00 WRITE REGISTER REQUESTS QUANTITY /MINUTE /THREAD /COMMIT
PAGES IN DBD 5850 5820.51 487.50 487.50 -------------------------- -------- ------- ------- -------
PAGES IN DBD FREE CHAIN 5752 5723.00 479.33 479.33 WAR REQUESTS-MULTI PAGE N/P 0.00 0.00 0.00
%DBD POOL IN USE 2
PAGES USED FOR DBD 98 97.51 8.17 8.17
FAILS DUE TO DBD FULL 0 0.00 0.00 0.00 WAR REQUESTS-ONE PAGE N/P 0.00 0.00 0.00
PAGES IN EDM STMT POOL 2500 2487.40 208.33 208.33 READ FOR CASTOUT-MULTI PAGE N/P 0.00 0.00 0.00
PAGES USED IN STATEMENT PL 12 11.94 1.00 1.00 READ FOR CASTOUT-ONE PAGE N/P 0.00 0.00 0.00
%STMT POOL IN USE 0 PAGES WRITTEN VIA WARM N/P 0.00 0.00 0.00
FREE PAGES IN EDM STMT PL 2488 2475.46 207.33 207.33 # NOT FOUND RECORDS FOUND 0 0.00 0.00 0.00
FAILURES STMT POOL FULL 0 0.00 0.00 0.00 # NOT FOUND RECORDS ADDED 0 0.00 0.00 0.00
STMTS IN GLOBAL CACHE 2 1.99 0.17 0.17 # NOT FOUND RECORDS REMOVED 0 0.00 0.00 0.00
NUM OF XPROC REQUESTS 0 0.00 0.00 0.00 # FAIL STMT SKEL POOL FULL 0 0.00 0.00 0.00
STRG ALLOC TO XPROC 0 0.00 0.00 0.00 # PGS SKEL EDM POOL 1280 1273.55 106.67 106.67
STEALABLE SKEL PAGES 12 11.94 1.00 1.00 # FREE PGS IN SKEL EDM POOL 1268 1261.61 105.67 105.67
STEALABLE DBD PAGES 3 2.98 0.25 0.25 # PAGES USED CT ATB 0 0.00 0.00 0.00
STRG ALLOC TO PLAN BTB 0 0.00 0.00 0.00 # PAGES USED PT ATB 0 0.00 0.00 0.00
STRG ALLOC TO PKGS BTB 0 0.00 0.00 0.00 # FAIL STMT ATB POOL FULL 0 0.00 0.00 0.00
STRG ALLOC TO PLAN ATB 25344 25216.2 2112.00 2112.00 # PAGES STMT ATB EDM POOL 0 0.00 0.00 0.00
STRG ALLOC TO PKGS ATB 33024 32857.5 2752.00 2752.00 #FREE PGS STMT ATB EDM POOL 0 0.00 0.00 0.00
1 BSTATLT : STATISTICS LONG TRACE 02/23/15 08:10:17 PAGE 556
GROUP : DB2 STATISTICS TRACE - LONG DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:54:00.11 END RECORD: ( 15.054 ) 02/23/15 07:55:00.41
ELAPSED TIME: 00:01:00.30 THREADS: 12 #DBATS: 0 COMMITS: 12 INCREMENTAL BIND: 2
OPEN/CLOSE ACTIVITY QUANTITY /MINUTE /THREAD /COMMIT LOG ACTIVITY QUANTITY /MINUTE /THREAD /COMMIT
-------------------- --------- ------- -------- --------- -------------------------- -------- ------- ------- -------
OPEN DATASETS - HWM 104 N/A N/A N/A READ SATISF'D-OUTPUT BUFF 0 0.00 0.00 0.00
OPEN DATASETS 104 N/A N/A N/A READ SATISF'D-OUTP BUF(%) N/P
NOT IN USE/NOT CLOSE-HWM 102 N/A N/A N/A READ SATISF'D-ACTIVE LOG 0 0.00 0.00 0.00
DS NOT IN USE/NOT CLOSED 41 N/A N/A N/A READ SATISF'D-ACTV LOG(%) N/P
IN USE DATA SETS 0 N/A N/A N/A READ SATISF'D-ARCHV LOG 0 0.00 0.00 0.00
READ SATISF'D-ARCH LOG(%) N/P
DS CLOSED-THRESH REACHED 0 0.00 0.00 0.00 TAPE VOL CONTENTION WAIT 0 0.00 0.00 0.00
READ DELAYED-UNAVAIL RESOU 0 0.00 0.00 0.00
DS CONVERTED R/W TO R/O 0 0.00 0.00 0.00
WRITE - NOWAIT 0 0.00 0.00 0.00
WRITE OUTPUT LOG BUFFERS 0 0.00 0.00 0.00
BSDS ACCESS REQUESTS 0 0.00 0.00 0.00
UNAVAIL OUTPUT LOG BUFS 0 0.00 0.00 0.00
OUTPUT LOG BUFFER PAGED IN 0 0.00 0.00 0.00
CONT INTERV CREATED-ACTV 0 0.00 0.00 0.00
ARCHIVE LOG READ ALLOC 0 0.00 0.00 0.00
ARCHIVE LOG WRITE ALLOC 0 0.00 0.00 0.00
CONTR INTRV OFFLOAD-ARCH 0 0.00 0.00 0.00
READ DELAYED-UNAVAIL RES 0 0.00 0.00 0.00
READ DELAY-ARCH ALLOC LIM 0.00 0.00 0.00
LOOK-AHEAD MOUNT ATTEMPT 0 0.00 0.00 0.00
LOOK-AHEAD MOUNT SUCCESS 0 0.00 0.00 0.00
LOG RECORDS CREATED 0 0.00 0.00 0.00
LOG DATA CREATED MB 0 0.00
LOG WRITE I/O REQUESTS 0 0.00 0.00 0.00
LOG CI WRITTEN 0 0.00 0.00 0.00
LOG CI SERIAL WRITE 0 0.00 0.00 0.00
LOG WRITE ASYNC. REQUESTS 0 0.00 0.00 0.00
LOG RATE FOR 1 LOG (MB) N/A 0.00 N/A N/A
LOG WRITE SUSPENDED 0 0.00 0.00 0.00
1 BSTATLT : STATISTICS LONG TRACE 02/23/15 08:10:17 PAGE 557
GROUP : DB2 STATISTICS TRACE - LONG DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:54:00.11 END RECORD: ( 15.054 ) 02/23/15 07:55:00.41
ELAPSED TIME: 00:01:00.30 THREADS: 12 #DBATS: 0 COMMITS: 12 INCREMENTAL BIND: 2
PLAN/PACKAGE PROCESSING QUANTITY /MINUTE /THREAD /COMMIT DB2 COMMANDS QUANTITY /MINUTE
------------------------- -------- ------- ------- ------- -------------------------- -------- -------
PLAN ALLOC ATTEMPTS 12 11.94 1.00 1.00 DISPLAY DATABASE 0 0.00
PLAN ALLOC SUCCESSFUL 12 11.94 1.00 1.00 DISPLAY THREAD 0 0.00
PACKAGE ALLOC ATTEMPTS 13 12.93 1.08 1.08 DISPLAY UTILITY 0 0.00
PACKAGE ALLOC SUCCESSFUL 13 12.93 1.08 1.08 DISPLAY TRACE 0 0.00
DISPLAY RLIMIT 0 0.00
PLANS BOUND 0 0.00 0.00 0.00 DISPLAY LOCATION 0 0.00
BIND ADD SUBCMDS 0 0.00 0.00 0.00 DISPLAY ARCHIVE 0 0.00
BIND REPLACE SUBCMDS 0 0.00 0.00 0.00 DISPLAY BUFFERPOOL 0 0.00
TEST BINDS NO PLAN-ID 0 0.00 0.00 0.00 DISPLAY GROUPBUFFERPOOL 0 0.00
PACKAGES BOUND 0 0.00 0.00 0.00 DISPLAY GROUP 0 0.00
BIND ADD PKG SUBCMDS 0 0.00 0.00 0.00 DISPLAY PROCEDURE 0 0.00
BIND REPLACE PKG SUBCMDS 0 0.00 0.00 0.00 DISPLAY DDF 0 0.00
ALTER BUFFERPOOL 0 0.00
AUTOMATIC BIND ATTEMPTS 0 0.00 0.00 0.00 ALTER GROUPBUFFERPOOL 0 0.00
AUTOMATIC BINDS SUCCESS 0 0.00 0.00 0.00 START DATABASE 0 0.00
AUTO BIND INVALID RES ID 0 0.00 0.00 0.00 START TRACE 0 0.00
AUTO BIND PACKAGE ATTEMPT 0 0.00 0.00 0.00 START DB2 0 0.00
AUTO BIND PACKAGE SUCCESS 0 0.00 0.00 0.00 START RLIMIT 0 0.00
START DDF 0 0.00
REBIND SUBCOMMANDS 0 0.00 0.00 0.00 START PROCEDURE 0 0.00
ATTEMPT TO REBIND A PLAN 0 0.00 0.00 0.00 STOP DATABASE 0 0.00
PLANS REBOUND 0 0.00 0.00 0.00 STOP TRACE 0 0.00
REBIND PACKAGE SUBCMDS 0 0.00 0.00 0.00 STOP DB2 0 0.00
ATTEMPT TO REBIND PKG 0 0.00 0.00 0.00 STOP RLIMIT 0 0.00
PACKAGES REBOUND 0 0.00 0.00 0.00 STOP DDF 0 0.00
STOP PROCEDURE 0 0.00
FREE PLAN SUBCOMMANDS 0 0.00 0.00 0.00 MODIFY TRACE 0 0.00
ATTEMPTS TO FREE A PLAN 0 0.00 0.00 0.00 CANCEL DDF THREAD 0 0.00
PLANS FREED 0 0.00 0.00 0.00 TERM UTILITY 0 0.00
FREE PACKAGE SUBCOMMANDS 0 0.00 0.00 0.00 RECOVER BSDS 0 0.00
ATTEMPTS TO FREE PACKAGE 0 0.00 0.00 0.00 RECOVER INDOUBT 0 0.00
PACKAGES FREED 0 0.00 0.00 0.00 RESET INDOUBT 0 0.00
RESET GENERICLU 0 0.00
INCREMENTAL BINDS 2 1.99 0.17 0.17 ARCHIVE LOG 0 0.00
SET ARCHIVE 0 0.00
UNRECOGNIZED CMDS 0 0.00
START PROFILE COMMANDS 0 0.00
STOP PROFILE COMMANDS 0 0.00
ACCESS DATABASE COMMANDS 0 0.00
DISPLAY DDF COMMANDS 0 0.00
TOTAL 0 0.00
1 BSTATLT : STATISTICS LONG TRACE 02/23/15 08:10:17 PAGE 558
GROUP : DB2 STATISTICS TRACE - LONG DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:54:00.11 END RECORD: ( 15.054 ) 02/23/15 07:55:00.41
ELAPSED TIME: 00:01:00.30 THREADS: 12 #DBATS: 0 COMMITS: 12 INCREMENTAL BIND: 2
RID LIST PROCESSING QUANTITY /MINUTE /THREAD /COMMIT AUTHORIZATION MANAGEMENT QUANTITY /MINUTE /THREAD /COMMIT
------------------------ -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
MAX RID BLOCKS ALLOCATED 3 2.98 0.25 0.25 AUTHORIZATION ATTEMPTS 17 16.91 1.42 1.42
CURRENT RID BLOCKS ALLOC 2 1.99 0.17 0.17 AUTHORIZATION SUCCESSFUL 17 16.91 1.42 1.42
TERMINATED - NO STORAGE 0 0.00 0.00 0.00 AUTH SUCC-WITHOUT CATALOG 11 10.94 0.92 0.92
TERM'D-EXCEED RDS LIMIT 0 0.00 0.00 0.00 AUTH SUCC-EXEC TO PUBLIC 7 6.96 0.58 0.58
TERM'D-EXCEED DM LIMIT 0 0.00 0.00 0.00 AUTH SUCC-PKG W/O CATALOG 1 0.99 0.08 0.08
TERM'D-EXCEED PROC LIMIT 0 0.00 0.00 0.00 AUTH SUCC-PKG-PUB-W/O CAT 1 0.99 0.08 0.08
NUMBER MAX SIZE INCREASED 0 0.00 0.00 0.00 AUTH UNSUCC-PKG-CACHE 0 0.00 0.00 0.00
TIMES OVWFL NO RID STRG 0 0.00 0.00 0.00 PKG CACHE OVERWRT - AUTHID 0 0.00 0.00 0.00
TIMES OVWFL NO RID INTLMT 0 0.00 0.00 0.00 PKG CACHE OVERWRT - ENTRY 0 0.00 0.00 0.00
TIMES HYBRD JOIN INT STRG 0 0.00 0.00 0.00 RTN_AUTH SUCC-W/O CATLG 0 0.00 0.00 0.00
TIMES HYBRD JOIN INT INTL 0 0.00 0.00 0.00 RTN_AUTH SUCC-PUB W/OCAT 0 0.00 0.00 0.00
TIMES MIAP SKIPPED PRE_OT 0 0.00 0.00 0.00 RTN_AUTH UNSUCC_CACHE 0 0.00 0.00 0.00
1 BSTATLT : STATISTICS LONG TRACE 02/23/15 08:10:17 PAGE 559
GROUP : DB2 STATISTICS TRACE - LONG DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:54:00.11 END RECORD: ( 15.054 ) 02/23/15 07:55:00.41
ELAPSED TIME: 00:01:00.30 THREADS: 12 #DBATS: 0 COMMITS: 12 INCREMENTAL BIND: 2
WORK FILE DATABASE QUANTITY /MINUTE /THREAD /COMMIT
--------------------- -------- ------- ------- -------
CURR TOT STG USED (KB) 64 63.68 5.33 5.33
MAX STORAGE USED 64 N/A N/A N/A
MAX LIMIT PER USER 0 N/A N/A N/A
NUMBER LIMIT EXCEEDED 0 0.00 0.00 0.00
4K TS STOR USED (KB) 64 63.68 5.33 5.33
32K TS STOR USED (KB) 0 0.00 0.00 0.00
4K USED, 32K BETTER 0 0.00 0.00 0.00
32K USED, 4K BETTER 0 0.00 0.00 0.00
DM IN MEMORY ACT-FILES 0 0.00 0.00 0.00
TOTAL SPACE USED IN_MEM 0 0.00 0.00 0.00
HWM COUNT MAX IN-MEM WF 0 N/A N/A N/A
HWM COUNT MAX IN-MEM WFKB 0 N/A N/A N/A
HOW MANY SORT IN-MEM FILES 0 0.00 0.00 0.00
TOT SPACE SRT IN-MEM FILES 0 0.00 0.00 0.00
HWM MANY SRT IN-MEM FILES 1 N/A N/A N/A
HWM STRG SRT IN-MEM FILES 40 N/A N/A N/A
HWM RID OWVFL WRK FILES 0 N/A N/A N/A
NUM RID BLKS IN STRG-CURR 0 0.00 0.00 0.00
LOCKING ACTIVITY QUANTITY /MINUTE /THREAD /COMMIT DATA SHARING LOCKING QUANTITY /MINUTE /THREAD /COMMI
------------------------ -------- ------- ------- ------- -------------------------- -------- ------- ------- ------
SUSPENSIONS (ALL) 1 0.99 0.08 0.08 LOCK REQUESTS (P-LOCKS) N/P 0.00 0.00 0.00
SUSPENSIONS (LOCK ONLY) 0 0.00 0.00 0.00 UNLOCK REQUESTS (P-LOCKS) N/P 0.00 0.00 0.00
SUSPENSIONS (LATCH ONLY) 1 0.99 0.08 0.08 CHANGE REQUESTS (P-LOCKS) N/P 0.00 0.00 0.00
SUSPENSIONS (OTHER) 0 0.00 0.00 0.00
SYNCH.XES - LOCK REQUESTS N/P 0.00 0.00 0.00
TIMEOUTS 0 0.00 0.00 0.00 SYNCH.XES - CHANGE REQS N/P 0.00 0.00 0.00
DEADLOCKS 0 0.00 0.00 0.00 SYNCH.XES - UNLOCK REQS N/P 0.00 0.00 0.00
ASYNCH.XES - RESOURCES N/P 0.00 0.00 0.00
LOCK REQUESTS 340 338.29 28.33 28.33
UNLOCK REQUESTS 188 187.05 15.67 15.67 SUSPENDS - IRLM GLOB. CONT N/P 0.00 0.00 0.00
QUERY REQUESTS 0 0.00 0.00 0.00 SUSPENDS - XES GLOBAL CONT N/P 0.00 0.00 0.00
CHANGE REQUESTS 114 113.43 9.50 9.50 SUSP-FALSE CONT AND CONV N/P 0.00 0.00 0.00
OTHER REQUESTS 0 0.00 0.00 0.00 SUSPENDS - FALSE CONT. N/P 0.00 0.00 0.00
INCOMPATIBLE RETAINED LOCK N/P 0.00 0.00 0.00
LOCK ESCALATION (SHARED) 0 0.00 0.00 0.00 NOTIFY MESSAGES SENT N/P 0.00 0.00 0.00
LOCK ESCALATION (EXCL) 0 0.00 0.00 0.00 NOTIFY MESSAGES RECEIVED N/P 0.00 0.00 0.00
P-LOCK/NOTIFY EXITS ENG. N/P N/A N/A N/A
DRAIN REQUESTS 0 0.00 0.00 0.00 P-LOCK/NOT EX ENG. UNAVAIL N/P 0.00 0.00 0.00
DRAIN REQUESTS FAILED 0 0.00 0.00 0.00
CLAIM REQUESTS 757 753.18 63.08 63.08 PSET/PART P-LOCK NEG. N/P 0.00 0.00 0.00
CLAIM REQUESTS FAILED 0 0.00 0.00 0.00 PAGE P-LOCK NEGOTIATION N/P 0.00 0.00 0.00
OTHER P-LOCK NEGOTIATION N/P 0.00 0.00 0.00
P-LOCK CHANGE DURING NEG. N/P 0.00 0.00 0.00
REJECTIONS HEURSTIC ALG-XES N/P
GLOBAL CONTENTION RATE(%) N/P
FALSE CONTENTION RATE(%) N/P
L-LOCKS XES RATE(%) N/P
1 BSTATLT : STATISTICS LONG TRACE 02/23/15 08:10:17 PAGE 560
GROUP : DB2 STATISTICS TRACE - LONG DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:54:00.11 END RECORD: ( 15.054 ) 02/23/15 07:55:00.41
ELAPSED TIME: 00:01:00.30 THREADS: 12 #DBATS: 0 COMMITS: 12 INCREMENTAL BIND: 2
GLOBAL DDF ACTIVITY QUANTITY /MINUTE /THREAD /COMMIT PARALLELISM QUANTITY /MINUTE /THREAD /COMMIT
------------------------- -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
DBATS QUEUED-MAX ACTIVE 0 0.00 0.00 N/A MAX DEGREE OF PARALLELISM 0 N/A N/A N/A
CONV DEALLOC-MAX THREADS 0 0.00 0.00 N/A PARALLEL GROUPS EXECUTED 0 0.00 0.00 0.00
INACTIVE DBATS - CURRENT 0 N/A N/A N/A EXECUTED AS PLANNED 0 0.00 0.00 0.00
INACTIVE DBATS - HWM 0 N/A N/A N/A REDUCED DEGREE-NO BUFFER 0 0.00 0.00 0.00
COLD START CONNECTIONS 0 0.00 0.00 0.00 FALL TO SEQUENTIAL-CURSOR 0 0.00 0.00 0.00
WARM START CONNECTIONS 0 0.00 0.00 0.00 FALL TO SEQUENTIAL-NO ESA 0 0.00 0.00 0.00
RESYNCHRONIZATION ATTEMPT 0 0.00 0.00 0.00 FALL TO SEQUENT'L-NO BUFF 0 0.00 0.00 0.00
RESYNCHRONIZATION SUCCEED 0 0.00 0.00 0.00 FALL TO SEQUENT'L-NO ENC N/P 0.00 0.00 0.00
CURRENT ACTIVE DBATS 0 N/A N/A N/A ONE DB2 -COORDINATOR=NO 0 0.00 0.00 0.00
MAX ACTIVE DBATS - HWM 0 N/A N/A N/A ONE DB2 - ISOLATION LEVEL 0 0.00 0.00 0.00
MAX ALL DBATS - HWM 0 N/A N/A N/A ONE DB2 - DCL TTABLE 0 0.00 0.00 0.00
TYPE 1 CONN TERMINATE 0 0.00 0.00 0.00 REFORM PARAL-CONFIG CHND 0 0.00 0.00 0.00
CUR TYPE2 INACTIVE DBATS 0 0.00 0.00 0.00 REFORM PARAL-NO BUFFER 0 0.00 0.00 0.00
TYPE2 INACTIVE DBATS HWM 0 GROUPS INTENDED - SYSPLEX 0 0.00 0.00 0.00
CUR QUEUED TYPE2 INAC THD 0 0.00 0.00 0.00 MEMBER SKIPPED - BFRS 0 0.00 0.00 0.00
REC QUEUED TYPE2 INAC THD 0 0.00 0.00 0.00
QUEUED TYPE2 INAC THD HWM 0 0.00 0.00 0.00
CURRENT DBATS NOT IN USE 0 0.00 0.00 0.00
DBATS NOT IN USE HWM 0 0.00 0.00 0.00
DBATS CREATED 0 0.00 0.00 0.00
POOL DBATS REUSED 0 0.00 0.00 0.00
NBR REQ DBA ACCESS 0 0.00 0.00 0.00
NBR REQ POOL ACCESS 0 0.00 0.00 0.00
NBR OF Q'D CLIENT(TCP/CLS) 0 0.00 0.00 0.00
NBR OF DBAT ACT PKG-BND 0 0.00 0.00 0.00
MAX OF DBAT ACT PKG-BND 0 0.00 0.00 0.00
1 BSTATLT : STATISTICS LONG TRACE 02/23/15 08:10:17 PAGE 561
GROUP : DB2 STATISTICS TRACE - LONG DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:54:00.11 END RECORD: ( 15.054 ) 02/23/15 07:55:00.41
ELAPSED TIME: 00:01:00.30 THREADS: 12 #DBATS: 0 COMMITS: 12 INCREMENTAL BIND: 2
TCB TIME SRB TIME TOTAL TIME
CPU TIMES H:MM:SS.THTTH H:MM.SS.THTTH H:MM.SS.THTTH
------------------------ ------------- ------------- -------------
SYSTEM SRVCS ADDR SPC 00:00.01532 00:00.01124 00:00.02656
DATABASE SRVCS ADDR SPC 00:00.01429 00:00.80712 00:00.82141
IRLM 00:00.00000 00:00.01002 00:00.01002
DDF ADDRESS SPACE 00:00.00698 00:00.00299 00:00.00997
TOTAL 00:00.03660 00:00.83137 00:00.86796
PREEMPTABLE SRB TIMER VALUE, NOT INCLUDING CPU ON AN IBM ZIIP (DB2 V7 ABOVE) 00:00:22
PREEMPTABLE SRB TIMER VALUE CONSUMED ON AN IBM ZIIP (DB2 V8 ABOVE) 00:20:06
DB2 APPL.PRGR.INTERFACE QUANTITY /MINUTE /THREAD /COMMIT DATA CAPTURE QUANTITY /MINUTE /THREAD /COMMIT
------------------------ -------- ------- ------- ------- ------------------------- -------- ------- ------- -------
ABENDS 0 0.00 0.00 0.00 LOG RECORDS CAPTURED 0 0.00 0.00 0.00
UNRECOGNIZED 0 0.00 0.00 0.00 LOG READS PERFORMED 0 0.00 0.00 0.00
COMMAND REQUESTS 0 0.00 0.00 0.00 LOG RECORDS RETURNED 0 0.00 0.00 0.00
READA REQUESTS 54 53.73 4.50 4.50 DATA ROWS RETURNED 0 0.00 0.00 0.00
READS REQUESTS 6 5.97 0.50 0.50 DESCRIBES PERFORMED 0 0.00 0.00 0.00
WRITE REQUESTS 0 0.00 0.00 0.00 DATA DESCRIPTIONS RETRNED 0 0.00 0.00 0.00
TABLES RETURNED 0 0.00 0.00 0.00
TOTAL 60 59.70 5.00 5.00
DYNAMIC SQL STMT QUANTITY /MINUTE /THREAD /COMMIT IFC DEST WRITTEN NOT WRTN BUF OVER NOT ACCP WRT FAIL
------------------------ -------- ------- ------- ------- -------- -------- -------- -------- -------- --------
PREPARE REQUESTS 137334 136642 11444.5 11444.5 SMF 39 0 0 0 0
FULL PREPARES 1 0.99 0.08 0.08 GTF 0 0 0 0 0
HALF PREPARES 109 108.45 9.08 9.08 OP1 24 0 0 0 0
GLOBAL CACHE HIT RATIO% 99 OP2 24 0 0 0 0
IMPLICIT PREPARES 0 0.00 0.00 0.00 OP3 24 0 0 0 0
PREPARE AVOIDED 0 0.00 0.00 0.00 OP4 2 0 0 0 0
STMT INVALID (MAXKEEPD) 0 0.00 0.00 0.00 OP5 0 0 0 0 0
STMT INVALID(DDL) 0 0.00 0.00 0.00 OP6 0 109931 0 44395 0
OP7 0 109931 0 44395 0
LOCAL CACHE HIT RATIO(%) N/P OP8 0 0 0 0 0
RES 0 0 0 0 0
TOTAL 113 219862 0 88790 0
IFC RECORD COUNT WRITTEN NOT WRTN LATCH CNT /SECOND /SECOND /SECOND /SECOND MISCELLANEOUS
---------------- -------- -------- --------- ------- ------- ------- ------- ----------------------------------------
SYSTEM RELATED 11 2 LC01-LC04 0.00 0.00 0.00 0.00 LOG RBA ADDRESS: 00000199C8BABDB6
DATABASE RELATED 11 2 LC05-LC08 0.00 0.00 0.00 0.00 STATS INVOKE RSN: ACTIVATED BY TIMER
ACCOUNTING 44 22 LC09-LC12 0.00 0.00 0.00 0.00 BYPASSED COLUMNS: 0
START TRACE 0 0 LC13-LC16 0.00 3.68 0.00 0.00 MAX SQL CASCAD LVL: 0
STOP TRACE 0 0 LC17-LC20 0.00 0.00 0.00 0.00 MAX STOR LOB VALUES: 0
SYSTEM PARMS 1 2 LC21-LC24 0.00 0.00 0.03 0.12
SYS PARMS-BPOOL 5 2 LC25-LC28 0.00 0.00 0.00 0.00
AUDIT 0 0 LC29-LC32 0.00 0.02 0.00 0.00
TOTAL 72 30
1 BSTATLT : STATISTICS LONG TRACE 02/23/15 08:10:17 PAGE 562
GROUP : DB2 STATISTICS TRACE - LONG DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:54:00.11 END RECORD: ( 15.054 ) 02/23/15 07:55:00.41
ELAPSED TIME: 00:01:00.30 THREADS: 12 #DBATS: 0 COMMITS: 12 INCREMENTAL BIND: 2
LATCH COUNT /QUANTITY /SECOND /THREAD /COMMIT
----------- --------- ------- ------- -------
LC01-LC04 0 0.00 0.00 0.00
LC05-LC08 0 0.00 0.00 0.00
LC09-LC12 0 0.00 0.00 0.00
LC13-LC16 222 3.68 18.50 0.00
LC17-LC20 0 0.00 0.00 0.00
LC21-LC24 9 0.15 0.75 0.75
LC25-LC28 0 0.00 0.00 0.00
LC29-LC32 1 0.02 0.08 0.08
1 BSTATLT : STATISTICS LONG TRACE 02/23/15 08:10:17 PAGE 563
GROUP : DB2 STATISTICS TRACE - LONG DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:54:00.11 END RECORD: ( 15.054 ) 02/23/15 07:55:00.41
ELAPSED TIME: 00:01:00.30 THREADS: 12 #DBATS: 0 COMMITS: 12 INCREMENTAL BIND: 2
BUFFER POOL BP0 QUANTITY /MINUTE /THREAD /COMMIT BP0 READ OPERATIONS QUANTITY /MINUTE /THREAD /COMMIT
------------------------ -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
CURRENT ACTIVE BUFFERS 66 N/A N/A N/A GETPAGE REQUESTS 438827 436615 36568.9 36568.9
UNAVAIL BUF-VPOOL FULL 0 0.00 0.00 0.00 GETPAGE REQUEST-SEQUENTIAL 111 110.44 9.25 9.25
GETPAGE REQUEST-RANDOM N/A N/A N/A N/A
NUMBER OF DATASET OPENS 1 0.99 0.08 0.08
SYNCHRONOUS READS 2175 2164.04 181.25 181.25
BUFFERS ALLOCATED-VPOOL 2000 N/A N/A N/A SYNCHRON READS-SEQUENTIAL 109 108.45 9.08 9.08
BUFFERS ALLOCATED-HPOOL N/P N/A N/A N/A SYNCHRON READS-RANDOM N/A N/A N/A N/A
HPOOL BUFFERS BACKED N/P N/A N/A N/A
GETPAGE PER SYNCH READS 212.35
DFHSM MIGRATED DATASETS 0 0.00 0.00 0.00
DFHSM RECALL TIMEOUTS 0 0.00 0.00 0.00 SEQUENT'L PREFETCH REQUEST 218 216.90 18.17 18.17
SEQUENTIAL PREFETCH READS 109 108.45 9.08 9.08
HPOOL EXPAND/CONTRACT N/P 0.00 0.00 0.00 PAGES READ VIA SEQ PREF 981 976.05 81.75 81.75
VPOOL EXPAND/CONTRACT 0 0.00 0.00 0.00 S PRF PAGE READ/S PRF READ 9.00
VPOOL/HPOOL EXP FAILURE 0 0.00 0.00 0.00
LIST PREFETCH REQUESTS 8749 8704.90 729.08 729.08
CONCUR PREF I/O - HWM 0 0.00 0.00 0.00 LIST PREFETCH READS 8749 8704.90 729.08 729.08
PREF I/O STREAM REDUCED 0 0.00 0.00 0.00 PAGES READ VIA LIST PREF 216685 215593 18057.1 18057.1
PARALLEL QUERY REQUESTS 0 0.00 0.00 0.00 L PRF PAGE READ/L PRF READ 24.77
PARALL QUERY REQ REDUCED 0 0.00 0.00 0.00
PREF QUANT REDUCED 1/2 0 0.00 0.00 0.00 DYNAMIC PREFETCH REQUESTED 15344 15266.7 1278.67 1278.67
PREF QUANT REDUCED 1/4 0 0.00 0.00 0.00 DYNAMIC PREFETCH READS 13152 13085.7 1096.00 1096.00
PAGES READ VIA DYN PREFTCH 322343 320718 26861.9 26861.9
D PRF PAGE READ/D PRF READ 24.51
PREF DISABLED - NO BUFFER 0 0.00 0.00 0.00
PREF DISABLED-NO READ ENG 0 0.00 0.00 0.00
PAGE INS REQUIRED FOR READ 0 0.00 0.00 0.00
SYNC HPOOL READ N/P 0.00 0.00 0.00
ASYNC HPOOL READ N/P 0.00 0.00 0.00
HPOOL READ FAILED N/P 0.00 0.00 0.00
ASYN DA MOVR HPOOL READ-S N/P 0.00 0.00 0.00
ASYN DA MOVR HPOOL READ-F N/P 0.00 0.00 0.00
BPOOL HIT RATIO (%) 99.48
HPOOL HIT RATIO (%) 0.00
HPOOL R/W RATIO (%) N/P
1 BSTATLT : STATISTICS LONG TRACE 02/23/15 08:10:17 PAGE 564
GROUP : DB2 STATISTICS TRACE - LONG DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:54:00.11 END RECORD: ( 15.054 ) 02/23/15 07:55:00.41
ELAPSED TIME: 00:01:00.30 THREADS: 12 #DBATS: 0 COMMITS: 12 INCREMENTAL BIND: 2
BP0 WRITE OPERATIONS QUANTITY /MINUTE /THREAD /COMMIT BP0 SORT/MERGE QUANTITY /MINUTE /THREAD /COMMIT
------------------------ -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
BUFFER UPDATES 0 0.00 0.00 0.00 MAX WORKFILES CONCURR USED 0 0.00 0.00 0.00
PAGES WRITTEN 0 0.00 0.00 0.00 MERGE PASSES REQUESTED 0 0.00 0.00 0.00
BUFF UPDATE/PAGE WRITTEN N/P MERGE PASS DEGRADE-LOW BUF 0 0.00 0.00 0.00
WRKFILE REQ REJCTD LOW BUF 0 0.00 0.00 0.00
SYNCHRONOUS WRITES 0 0.00 0.00 0.00 WRKFILE REQ-ALL MERGE PASS 0 0.00 0.00 0.00
ASYNCHRONOUS WRITES 0 0.00 0.00 0.00 WORKFILE PRF NOT SCHEDULED 0 0.00 0.00 0.00
WORKFILE PAGES TO DESTRUCT 0 0.00 0.00 0.00
PAGES WRITTEN/WRITE I/O N/P WORKFILE PAGES NOT WRITTEN 0 0.00 0.00 0.00
WORKFILE NOT CREATED NOBUF 0 0.00 0.00 0.00
HORIZ DEF WRITE THRESH 0 0.00 0.00 0.00
VERTI DEF WRITE THRESH 0 0.00 0.00 0.00
DM CRITICAL THRESHOLD 0 0.00 0.00 0.00
WRITE ENGINE NOT AVAIL N/P 0.00 0.00 0.00
PAGE INS REQ FOR WRITE 0 0.00 0.00 0.00
SYNC HPOOL WRITE N/P 0.00 0.00 0.00
ASYNC HPOOL WRITE N/P 0.00 0.00 0.00
HPOOL WRITE FAILED N/P 0.00 0.00 0.00
ASYN DA MVR HPOOL WRIT-S N/P 0.00 0.00 0.00
ASYN DA MVR HPOOL WRIT-F N/P 0.00 0.00 0.00
NBR PAGES UNLOCK CASTOUT 0 0.00 0.00 0.00
NBR I/O ON CASTOUT 0 0.00 0.00 0.00
1 BSTATLT : STATISTICS LONG TRACE 02/23/15 08:10:17 PAGE 565
GROUP : DB2 STATISTICS TRACE - LONG DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:54:00.11 END RECORD: ( 15.054 ) 02/23/15 07:55:00.41
ELAPSED TIME: 00:01:00.30 THREADS: 12 #DBATS: 0 COMMITS: 12 INCREMENTAL BIND: 2
BUFFER POOL BP1 QUANTITY /MINUTE /THREAD /COMMIT BP1 READ OPERATIONS QUANTITY /MINUTE /THREAD /COMMIT
------------------------ -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
CURRENT ACTIVE BUFFERS 6 N/A N/A N/A GETPAGE REQUESTS 1784 1775.01 148.67 148.67
UNAVAIL BUF-VPOOL FULL 0 0.00 0.00 0.00 GETPAGE REQUEST-SEQUENTIAL 549 546.23 45.75 45.75
GETPAGE REQUEST-RANDOM N/A N/A N/A N/A
NUMBER OF DATASET OPENS 0 0.00 0.00 0.00
SYNCHRONOUS READS 0 0.00 0.00 0.00
BUFFERS ALLOCATED-VPOOL 6656 N/A N/A N/A SYNCHRON READS-SEQUENTIAL 0 0.00 0.00 0.00
BUFFERS ALLOCATED-HPOOL N/P N/A N/A N/A SYNCHRON READS-RANDOM N/A N/A N/A N/A
HPOOL BUFFERS BACKED N/P N/A N/A N/A
GETPAGE PER SYNCH READS N/P
DFHSM MIGRATED DATASETS 0 0.00 0.00 0.00
DFHSM RECALL TIMEOUTS 0 0.00 0.00 0.00 SEQUENT'L PREFETCH REQUEST 0 0.00 0.00 0.00
SEQUENTIAL PREFETCH READS 0 0.00 0.00 0.00
HPOOL EXPAND/CONTRACT N/P 0.00 0.00 0.00 PAGES READ VIA SEQ PREF 0 0.00 0.00 0.00
VPOOL EXPAND/CONTRACT 0 0.00 0.00 0.00 S PRF PAGE READ/S PRF READ N/P
VPOOL/HPOOL EXP FAILURE 0 0.00 0.00 0.00
LIST PREFETCH REQUESTS 0 0.00 0.00 0.00
CONCUR PREF I/O - HWM 0 0.00 0.00 0.00 LIST PREFETCH READS 0 0.00 0.00 0.00
PREF I/O STREAM REDUCED 0 0.00 0.00 0.00 PAGES READ VIA LIST PREF 0 0.00 0.00 0.00
PARALLEL QUERY REQUESTS 0 0.00 0.00 0.00 L PRF PAGE READ/L PRF READ N/P
PARALL QUERY REQ REDUCED 0 0.00 0.00 0.00
PREF QUANT REDUCED 1/2 0 0.00 0.00 0.00 DYNAMIC PREFETCH REQUESTED 0 0.00 0.00 0.00
PREF QUANT REDUCED 1/4 0 0.00 0.00 0.00 DYNAMIC PREFETCH READS 0 0.00 0.00 0.00
PAGES READ VIA DYN PREFTCH 0 0.00 0.00 0.00
D PRF PAGE READ/D PRF READ N/P
PREF DISABLED - NO BUFFER 0 0.00 0.00 0.00
PREF DISABLED-NO READ ENG 0 0.00 0.00 0.00
PAGE INS REQUIRED FOR READ 0 0.00 0.00 0.00
SYNC HPOOL READ N/P 0.00 0.00 0.00
ASYNC HPOOL READ N/P 0.00 0.00 0.00
HPOOL READ FAILED N/P 0.00 0.00 0.00
ASYN DA MOVR HPOOL READ-S N/P 0.00 0.00 0.00
ASYN DA MOVR HPOOL READ-F N/P 0.00 0.00 0.00
BPOOL HIT RATIO (%) 100.00
HPOOL HIT RATIO (%) 0.00
HPOOL R/W RATIO (%) N/P
1 BSTATLT : STATISTICS LONG TRACE 02/23/15 08:10:17 PAGE 566
GROUP : DB2 STATISTICS TRACE - LONG DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:54:00.11 END RECORD: ( 15.054 ) 02/23/15 07:55:00.41
ELAPSED TIME: 00:01:00.30 THREADS: 12 #DBATS: 0 COMMITS: 12 INCREMENTAL BIND: 2
BP1 WRITE OPERATIONS QUANTITY /MINUTE /THREAD /COMMIT BP1 SORT/MERGE QUANTITY /MINUTE /THREAD /COMMIT
------------------------ -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
BUFFER UPDATES 1539 1531.24 128.25 128.25 MAX WORKFILES CONCURR USED 0 0.00 0.00 0.00
PAGES WRITTEN 0 0.00 0.00 0.00 MERGE PASSES REQUESTED 0 0.00 0.00 0.00
BUFF UPDATE/PAGE WRITTEN N/P MERGE PASS DEGRADE-LOW BUF 0 0.00 0.00 0.00
WRKFILE REQ REJCTD LOW BUF 0 0.00 0.00 0.00
SYNCHRONOUS WRITES 0 0.00 0.00 0.00 WRKFILE REQ-ALL MERGE PASS 0 0.00 0.00 0.00
ASYNCHRONOUS WRITES 0 0.00 0.00 0.00 WORKFILE PRF NOT SCHEDULED 0 0.00 0.00 0.00
WORKFILE PAGES TO DESTRUCT 0 0.00 0.00 0.00
PAGES WRITTEN/WRITE I/O N/P WORKFILE PAGES NOT WRITTEN 0 0.00 0.00 0.00
WORKFILE NOT CREATED NOBUF 0 0.00 0.00 0.00
HORIZ DEF WRITE THRESH 0 0.00 0.00 0.00
VERTI DEF WRITE THRESH 0 0.00 0.00 0.00
DM CRITICAL THRESHOLD 0 0.00 0.00 0.00
WRITE ENGINE NOT AVAIL N/P 0.00 0.00 0.00
PAGE INS REQ FOR WRITE 0 0.00 0.00 0.00
SYNC HPOOL WRITE N/P 0.00 0.00 0.00
ASYNC HPOOL WRITE N/P 0.00 0.00 0.00
HPOOL WRITE FAILED N/P 0.00 0.00 0.00
ASYN DA MVR HPOOL WRIT-S N/P 0.00 0.00 0.00
ASYN DA MVR HPOOL WRIT-F N/P 0.00 0.00 0.00
NBR PAGES UNLOCK CASTOUT 0 0.00 0.00 0.00
NBR I/O ON CASTOUT 0 0.00 0.00 0.00
1 BSTATLT : STATISTICS LONG TRACE 02/23/15 08:10:17 PAGE 567
GROUP : DB2 STATISTICS TRACE - LONG DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:54:00.11 END RECORD: ( 15.054 ) 02/23/15 07:55:00.41
ELAPSED TIME: 00:01:00.30 THREADS: 12 #DBATS: 0 COMMITS: 12 INCREMENTAL BIND: 2
BUFFER POOL BP8K0 QUANTITY /MINUTE /THREAD /COMMIT BP8K0 READ OPERATIONS QUANTITY /MINUTE /THREAD /COMMIT
------------------------ -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
CURRENT ACTIVE BUFFERS 0 N/A N/A N/A GETPAGE REQUESTS 5 4.97 0.42 0.42
UNAVAIL BUF-VPOOL FULL 0 0.00 0.00 0.00 GETPAGE REQUEST-SEQUENTIAL 0 0.00 0.00 0.00
GETPAGE REQUEST-RANDOM N/A N/A N/A N/A
NUMBER OF DATASET OPENS 0 0.00 0.00 0.00
SYNCHRONOUS READS 0 0.00 0.00 0.00
BUFFERS ALLOCATED-VPOOL 128 N/A N/A N/A SYNCHRON READS-SEQUENTIAL 0 0.00 0.00 0.00
BUFFERS ALLOCATED-HPOOL N/P N/A N/A N/A SYNCHRON READS-RANDOM N/A N/A N/A N/A
HPOOL BUFFERS BACKED N/P N/A N/A N/A
GETPAGE PER SYNCH READS N/P
DFHSM MIGRATED DATASETS 0 0.00 0.00 0.00
DFHSM RECALL TIMEOUTS 0 0.00 0.00 0.00 SEQUENT'L PREFETCH REQUEST 0 0.00 0.00 0.00
SEQUENTIAL PREFETCH READS 0 0.00 0.00 0.00
HPOOL EXPAND/CONTRACT N/P 0.00 0.00 0.00 PAGES READ VIA SEQ PREF 0 0.00 0.00 0.00
VPOOL EXPAND/CONTRACT 0 0.00 0.00 0.00 S PRF PAGE READ/S PRF READ N/P
VPOOL/HPOOL EXP FAILURE 0 0.00 0.00 0.00
LIST PREFETCH REQUESTS 0 0.00 0.00 0.00
CONCUR PREF I/O - HWM 0 0.00 0.00 0.00 LIST PREFETCH READS 0 0.00 0.00 0.00
PREF I/O STREAM REDUCED 0 0.00 0.00 0.00 PAGES READ VIA LIST PREF 0 0.00 0.00 0.00
PARALLEL QUERY REQUESTS 0 0.00 0.00 0.00 L PRF PAGE READ/L PRF READ N/P
PARALL QUERY REQ REDUCED 0 0.00 0.00 0.00
PREF QUANT REDUCED 1/2 0 0.00 0.00 0.00 DYNAMIC PREFETCH REQUESTED 0 0.00 0.00 0.00
PREF QUANT REDUCED 1/4 0 0.00 0.00 0.00 DYNAMIC PREFETCH READS 0 0.00 0.00 0.00
PAGES READ VIA DYN PREFTCH 0 0.00 0.00 0.00
D PRF PAGE READ/D PRF READ N/P
PREF DISABLED - NO BUFFER 0 0.00 0.00 0.00
PREF DISABLED-NO READ ENG 0 0.00 0.00 0.00
PAGE INS REQUIRED FOR READ 0 0.00 0.00 0.00
SYNC HPOOL READ N/P 0.00 0.00 0.00
ASYNC HPOOL READ N/P 0.00 0.00 0.00
HPOOL READ FAILED N/P 0.00 0.00 0.00
ASYN DA MOVR HPOOL READ-S N/P 0.00 0.00 0.00
ASYN DA MOVR HPOOL READ-F N/P 0.00 0.00 0.00
BPOOL HIT RATIO (%) 100.00
HPOOL HIT RATIO (%) 0.00
HPOOL R/W RATIO (%) N/P
1 BSTATLT : STATISTICS LONG TRACE 02/23/15 08:10:17 PAGE 568
GROUP : DB2 STATISTICS TRACE - LONG DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:54:00.11 END RECORD: ( 15.054 ) 02/23/15 07:55:00.41
ELAPSED TIME: 00:01:00.30 THREADS: 12 #DBATS: 0 COMMITS: 12 INCREMENTAL BIND: 2
BP8K0 WRITE OPERATIONS QUANTITY /MINUTE /THREAD /COMMIT BP8K0 SORT/MERGE QUANTITY /MINUTE /THREAD /COMMIT
------------------------ -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
BUFFER UPDATES 0 0.00 0.00 0.00 MAX WORKFILES CONCURR USED 0 0.00 0.00 0.00
PAGES WRITTEN 0 0.00 0.00 0.00 MERGE PASSES REQUESTED 0 0.00 0.00 0.00
BUFF UPDATE/PAGE WRITTEN N/P MERGE PASS DEGRADE-LOW BUF 0 0.00 0.00 0.00
WRKFILE REQ REJCTD LOW BUF 0 0.00 0.00 0.00
SYNCHRONOUS WRITES 0 0.00 0.00 0.00 WRKFILE REQ-ALL MERGE PASS 0 0.00 0.00 0.00
ASYNCHRONOUS WRITES 0 0.00 0.00 0.00 WORKFILE PRF NOT SCHEDULED 0 0.00 0.00 0.00
WORKFILE PAGES TO DESTRUCT 0 0.00 0.00 0.00
PAGES WRITTEN/WRITE I/O N/P WORKFILE PAGES NOT WRITTEN 0 0.00 0.00 0.00
WORKFILE NOT CREATED NOBUF 0 0.00 0.00 0.00
HORIZ DEF WRITE THRESH 0 0.00 0.00 0.00
VERTI DEF WRITE THRESH 0 0.00 0.00 0.00
DM CRITICAL THRESHOLD 0 0.00 0.00 0.00
WRITE ENGINE NOT AVAIL N/P 0.00 0.00 0.00
PAGE INS REQ FOR WRITE 0 0.00 0.00 0.00
SYNC HPOOL WRITE N/P 0.00 0.00 0.00
ASYNC HPOOL WRITE N/P 0.00 0.00 0.00
HPOOL WRITE FAILED N/P 0.00 0.00 0.00
ASYN DA MVR HPOOL WRIT-S N/P 0.00 0.00 0.00
ASYN DA MVR HPOOL WRIT-F N/P 0.00 0.00 0.00
NBR PAGES UNLOCK CASTOUT 0 0.00 0.00 0.00
NBR I/O ON CASTOUT 0 0.00 0.00 0.00
1 BSTATLT : STATISTICS LONG TRACE 02/23/15 08:10:17 PAGE 569
GROUP : DB2 STATISTICS TRACE - LONG DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:54:00.11 END RECORD: ( 15.054 ) 02/23/15 07:55:00.41
ELAPSED TIME: 00:01:00.30 THREADS: 12 #DBATS: 0 COMMITS: 12 INCREMENTAL BIND: 2
BUFFER POOL BP16K0 QUANTITY /MINUTE /THREAD /COMMIT BP16K0 READ OPERATIONS QUANTITY /MINUTE /THREAD /COMMIT
------------------------ -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
CURRENT ACTIVE BUFFERS 0 N/A N/A N/A GETPAGE REQUESTS 2 1.99 0.17 0.17
UNAVAIL BUF-VPOOL FULL 0 0.00 0.00 0.00 GETPAGE REQUEST-SEQUENTIAL 0 0.00 0.00 0.00
GETPAGE REQUEST-RANDOM N/A N/A N/A N/A
NUMBER OF DATASET OPENS 0 0.00 0.00 0.00
SYNCHRONOUS READS 1 0.99 0.08 0.08
BUFFERS ALLOCATED-VPOOL 64 N/A N/A N/A SYNCHRON READS-SEQUENTIAL 0 0.00 0.00 0.00
BUFFERS ALLOCATED-HPOOL N/P N/A N/A N/A SYNCHRON READS-RANDOM N/A N/A N/A N/A
HPOOL BUFFERS BACKED N/P N/A N/A N/A
GETPAGE PER SYNCH READS 2.00
DFHSM MIGRATED DATASETS 0 0.00 0.00 0.00
DFHSM RECALL TIMEOUTS 0 0.00 0.00 0.00 SEQUENT'L PREFETCH REQUEST 0 0.00 0.00 0.00
SEQUENTIAL PREFETCH READS 0 0.00 0.00 0.00
HPOOL EXPAND/CONTRACT N/P 0.00 0.00 0.00 PAGES READ VIA SEQ PREF 0 0.00 0.00 0.00
VPOOL EXPAND/CONTRACT 0 0.00 0.00 0.00 S PRF PAGE READ/S PRF READ N/P
VPOOL/HPOOL EXP FAILURE 0 0.00 0.00 0.00
LIST PREFETCH REQUESTS 0 0.00 0.00 0.00
CONCUR PREF I/O - HWM 0 0.00 0.00 0.00 LIST PREFETCH READS 0 0.00 0.00 0.00
PREF I/O STREAM REDUCED 0 0.00 0.00 0.00 PAGES READ VIA LIST PREF 0 0.00 0.00 0.00
PARALLEL QUERY REQUESTS 0 0.00 0.00 0.00 L PRF PAGE READ/L PRF READ N/P
PARALL QUERY REQ REDUCED 0 0.00 0.00 0.00
PREF QUANT REDUCED 1/2 0 0.00 0.00 0.00 DYNAMIC PREFETCH REQUESTED 0 0.00 0.00 0.00
PREF QUANT REDUCED 1/4 0 0.00 0.00 0.00 DYNAMIC PREFETCH READS 0 0.00 0.00 0.00
PAGES READ VIA DYN PREFTCH 0 0.00 0.00 0.00
D PRF PAGE READ/D PRF READ N/P
PREF DISABLED - NO BUFFER 0 0.00 0.00 0.00
PREF DISABLED-NO READ ENG 0 0.00 0.00 0.00
PAGE INS REQUIRED FOR READ 1 0.99 0.08 0.08
SYNC HPOOL READ N/P 0.00 0.00 0.00
ASYNC HPOOL READ N/P 0.00 0.00 0.00
HPOOL READ FAILED N/P 0.00 0.00 0.00
ASYN DA MOVR HPOOL READ-S N/P 0.00 0.00 0.00
ASYN DA MOVR HPOOL READ-F N/P 0.00 0.00 0.00
BPOOL HIT RATIO (%) 50.00
HPOOL HIT RATIO (%) 0.00
HPOOL R/W RATIO (%) N/P
1 BSTATLT : STATISTICS LONG TRACE 02/23/15 08:10:17 PAGE 570
GROUP : DB2 STATISTICS TRACE - LONG DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:54:00.11 END RECORD: ( 15.054 ) 02/23/15 07:55:00.41
ELAPSED TIME: 00:01:00.30 THREADS: 12 #DBATS: 0 COMMITS: 12 INCREMENTAL BIND: 2
BP16K0 WRITE OPERATIONS QUANTITY /MINUTE /THREAD /COMMIT BP16K0 SORT/MERGE QUANTITY /MINUTE /THREAD /COMMIT
------------------------ -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
BUFFER UPDATES 0 0.00 0.00 0.00 MAX WORKFILES CONCURR USED 0 0.00 0.00 0.00
PAGES WRITTEN 0 0.00 0.00 0.00 MERGE PASSES REQUESTED 0 0.00 0.00 0.00
BUFF UPDATE/PAGE WRITTEN N/P MERGE PASS DEGRADE-LOW BUF 0 0.00 0.00 0.00
WRKFILE REQ REJCTD LOW BUF 0 0.00 0.00 0.00
SYNCHRONOUS WRITES 0 0.00 0.00 0.00 WRKFILE REQ-ALL MERGE PASS 0 0.00 0.00 0.00
ASYNCHRONOUS WRITES 0 0.00 0.00 0.00 WORKFILE PRF NOT SCHEDULED 0 0.00 0.00 0.00
WORKFILE PAGES TO DESTRUCT 0 0.00 0.00 0.00
PAGES WRITTEN/WRITE I/O N/P WORKFILE PAGES NOT WRITTEN 0 0.00 0.00 0.00
WORKFILE NOT CREATED NOBUF 0 0.00 0.00 0.00
HORIZ DEF WRITE THRESH 0 0.00 0.00 0.00
VERTI DEF WRITE THRESH 0 0.00 0.00 0.00
DM CRITICAL THRESHOLD 0 0.00 0.00 0.00
WRITE ENGINE NOT AVAIL N/P 0.00 0.00 0.00
PAGE INS REQ FOR WRITE 0 0.00 0.00 0.00
SYNC HPOOL WRITE N/P 0.00 0.00 0.00
ASYNC HPOOL WRITE N/P 0.00 0.00 0.00
HPOOL WRITE FAILED N/P 0.00 0.00 0.00
ASYN DA MVR HPOOL WRIT-S N/P 0.00 0.00 0.00
ASYN DA MVR HPOOL WRIT-F N/P 0.00 0.00 0.00
NBR PAGES UNLOCK CASTOUT 0 0.00 0.00 0.00
NBR I/O ON CASTOUT 0 0.00 0.00 0.00
1 BSTATLT : STATISTICS LONG TRACE 02/23/15 08:10:17 PAGE 571
GROUP : DB2 STATISTICS TRACE - LONG DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:54:00.11 END RECORD: ( 15.054 ) 02/23/15 07:55:00.41
ELAPSED TIME: 00:01:00.30 THREADS: 12 #DBATS: 0 COMMITS: 12 INCREMENTAL BIND: 2
12
BUFFER POOL BP TOT QUANTITY /MINUTE /THREAD /COMMIT BP TOT READ OPERATIONS QUANTITY /MINUTE /THREAD /COMMIT
------------------------ -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
CURRENT ACTIVE BUFFERS 18 N/A N/A N/A GETPAGE REQUESTS 440618 438397 36718.2 36718.2
UNAVAIL BUF-VPOOL FULL 0 0.00 0.00 0.00 GETPAGE REQUEST-SEQUENTIAL 660 656.67 55.00 55.00
GETPAGE REQUEST-RANDOM 439958 437740 36663.2 36663.2
NUMBER OF DATASET OPENS 1 0.99 0.08 0.08
SYNCHRONOUS READS 2176 2165.03 181.33 181.33
BUFFERS ALLOCATED-VPOOL 2212 N/A N/A N/A SYNCHRON READS-SEQUENTIAL 109 108.45 9.08 9.08
BUFFERS ALLOCATED-HPOOL N/P N/A N/A N/A SYNCHRON READS-RANDOM 2067 2056.58 172.25 172.25
HPOOL BUFFERS BACKED N/P N/A N/A N/A
GETPAGE PER SYNCH READS 212.85
DFHSM MIGRATED DATASETS 0 0.00 0.00 0.00
DFHSM RECALL TIMEOUTS 0 0.00 0.00 0.00 SEQUENT'L PREFETCH REQUEST 218 216.90 18.17 18.17
SEQUENTIAL PREFETCH READS 109 108.45 9.08 9.08
HPOOL EXPAND/CONTRACT N/P 0.00 0.00 0.00 PAGES READ VIA SEQ PREF 981 976.05 81.75 81.75
VPOOL EXPAND/CONTRACT 0 0.00 0.00 0.00 S PRF PAGE READ/S PRF READ 9.00
VPOOL/HPOOL EXP FAILURE 0 0.00 0.00 0.00
LIST PREFETCH REQUESTS 8749 8704.90 729.08 729.08
CONCUR PREF I/O - HWM 0 0.00 0.00 0.00 LIST PREFETCH READS 8749 8704.90 729.08 729.08
PREF I/O STREAM REDUCED 0 0.00 0.00 0.00 PAGES READ VIA LIST PREF 216685 215593 18057.1 18057.1
PARALLEL QUERY REQUESTS 0 0.00 0.00 0.00 L PRF PAGE READ/L PRF READ 24.77
PARALL QUERY REQ REDUCED 0 0.00 0.00 0.00
PREF QUANT REDUCED 1/2 0 0.00 0.00 0.00 DYNAMIC PREFETCH REQUESTED 15344 15266.7 1278.67 1278.67
PREF QUANT REDUCED 1/4 0 0.00 0.00 0.00 DYNAMIC PREFETCH READS 13152 13085.7 1096.00 1096.00
PAGES READ VIA DYN PREFTCH 322343 320718 26861.9 26861.9
D PRF PAGE READ/D PRF READ 24.51
PREF DISABLED - NO BUFFER 0 0.00 0.00 0.00
PREF DISABLED-NO READ ENG 0 0.00 0.00 0.00
PAGE INS REQUIRED FOR READ 1 0.99 0.08 0.08
SYNC HPOOL READ N/P 0.00 0.00 0.00
ASYNC HPOOL READ N/P 0.00 0.00 0.00
HPOOL READ FAILED N/P 0.00 0.00 0.00
ASYN DA MOVR HPOOL READ-S N/P 0.00 0.00 0.00
ASYN DA MOVR HPOOL READ-F N/P 0.00 0.00 0.00
BPOOL HIT RATIO (%) 99.48
HPOOL HIT RATIO (%) 0.00
HPOOL R/W RATIO (%) N/P
1 BSTATLT : STATISTICS LONG TRACE 02/23/15 08:10:17 PAGE 572
GROUP : DB2 STATISTICS TRACE - LONG DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:54:00.11 END RECORD: ( 15.054 ) 02/23/15 07:55:00.41
ELAPSED TIME: 00:01:00.30 THREADS: 12 #DBATS: 0 COMMITS: 12 INCREMENTAL BIND: 2
BP TOT WRITE OPERATIONS QUANTITY /MINUTE /THREAD /COMMIT BP TOT SORT/MERGE QUANTITY /MINUTE /THREAD /COMMIT
------------------------ -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
BUFFER UPDATES 1539 1531.24 128.25 128.25 MAX WORKFILES CONCURR USED 0 0.00 0.00 0.00
PAGES WRITTEN 0 0.00 0.00 0.00 MERGE PASSES REQUESTED 0 0.00 0.00 0.00
BUFF UPDATE/PAGE WRITTEN N/P MERGE PASS DEGRADE-LOW BUF 0 0.00 0.00 0.00
WRKFILE REQ REJCTD LOW BUF 0 0.00 0.00 0.00
SYNCHRONOUS WRITES 0 0.00 0.00 0.00 WRKFILE REQ-ALL MERGE PASS 0 0.00 0.00 0.00
ASYNCHRONOUS WRITES 0 0.00 0.00 0.00 WORKFILE PRF NOT SCHEDULED 0 0.00 0.00 0.00
WORKFILE PAGES TO DESTRUCT 0 0.00 0.00 0.00
PAGES WRITTEN/WRITE I/O N/P WORKFILE PAGES NOT WRITTEN 0 0.00 0.00 0.00
WORKFILE NOT CREATED NOBUF 0 0.00 0.00 0.00
HORIZ DEF WRITE THRESH 0 0.00 0.00 0.00
VERTI DEF WRITE THRESH 0 0.00 0.00 0.00
DM CRITICAL THRESHOLD 0 0.00 0.00 0.00
WRITE ENGINE NOT AVAIL N/P 0.00 0.00 0.00
PAGE INS REQ FOR WRITE 0 0.00 0.00 0.00
SYNC HPOOL WRITE N/P 0.00 0.00 0.00
ASYNC HPOOL WRITE N/P 0.00 0.00 0.00
HPOOL WRITE FAILED N/P 0.00 0.00 0.00
ASYN DA MVR HPOOL WRIT-S N/P 0.00 0.00 0.00
ASYN DA MVR HPOOL WRIT-F N/P 0.00 0.00 0.00
NBR PAGES UNLOCK CASTOUT 0 0.00 0.00 0.00
NBR I/O ON CASTOUT 0 0.00 0.00 0.00
1 BSTATLT : STATISTICS LONG TRACE 02/23/15 08:10:17 PAGE 573
GROUP : DB2 STATISTICS TRACE - LONG DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:54:00.11 END RECORD: ( 15.054 ) 02/23/15 07:55:00.41
ELAPSED TIME: 00:01:00.30 THREADS: 12 #DBATS: 0 COMMITS: 12 INCREMENTAL BIND: 2
GROUP BUFFER POOL GBP TOT QUANTITY /MINUTE /THREAD /COMMIT P GBP TOT QUANTITY /MINUTE /THREAD /COMMIT
------------------------- -------- ------- ------- ------- P -------------------------- -------- ------- ------- -------
P GBP DEPENDENT GETPAGES N/P 0.00 0.00 0.00
SYNC READS(XI)DATA RET N/P 0.00 0.00 0.00 P REGISTER PAGE LIST REQUEST N/P 0.00 0.00 0.00
SYNC READS(XI) NO DATA N/P 0.00 0.00 0.00 P CHANGED PGS READ AFTER RPL N/P 0.00 0.00 0.00
SYNC READS(NF)DATA RET N/P 0.00 0.00 0.00 P PAGES CASTOUT N/P 0.00 0.00 0.00
SYNC READS(NF) NO DATA N/P 0.00 0.00 0.00 P PAGES CASTOUT THRESH N/P 0.00 0.00 0.00
P CASTOUT CLASS THRESHOLD N/P 0.00 0.00 0.00
NUM UNREGTR PAGE REQTS N/P 0.00 0.00 0.00 P GROUP BP CASTOUT THRESHOLD N/P 0.00 0.00 0.00
CLEAN PAGES SYNC WRITE N/P 0.00 0.00 0.00 P WRITE FAILED- NO STORAGE N/P 0.00 0.00 0.00
CHANGED PGS SYNC WRITE N/P 0.00 0.00 0.00 P NUMBER UNLOCK CASTOUT N/P 0.00 0.00 0.00
CLEAN PAGES ASYNC WRITE N/P 0.00 0.00 0.00 P #IXLCACHE READ CASTOUT N/P 0.00 0.00 0.00
CHANGED PGS ASYNC WRITE N/P 0.00 0.00 0.00 P #IXLCACHE READ DIR INFO N/P 0.00 0.00 0.00
P NBR REGISTER PAGE REQTS N/P 0.00 0.00 0.00
TOT PAGE P-LOCK LOCK REQ 0 P NBR IXLCACHE DELETE NAME N/P 0.00 0.00 0.00
SPACE MAP PAGES N/P P NBR ASYNC IXLCACHE PRIM N/P 0.00 0.00 0.00
DATA PAGES N/P P NBR EXPL CROSS VALIDATE N/P 0.00 0.00 0.00
INDEX LEAF PAGES N/P P NBR GBP CHCKPT TRIGGERED N/P 0.00 0.00 0.00
PAGE P-LOCK UNLOCK REQ N/P P NBR FAILED WRT CHD PAGES N/P 0.00 0.00 0.00
TOT PAGE P-LOCK LOCK SUSP 0 P NBR DEL NM LST REQS 2ND GBP N/P 0.00 0.00 0.00
SPACE MAP PAGES N/P P NBR DEL NM REQS TO 2ND GBP N/P 0.00 0.00 0.00
DATA PAGES N/P P NBR READ CASTOUT TO 2ND GBP N/P 0.00 0.00 0.00
INDEX LEAF PAGES N/P P NBR ASYNC IXLCACHE 2ND GBP N/P 0.00 0.00 0.00
TOT PAGE P-LOCK LOCK NEG 0 P
SPACE MAP PAGES N/P P
DATA PAGES N/P P OTHER REQUESTS N/P 0.00 0.00 0.00
INDEX LEAF PAGES N/P P
P
ACCELERATOR SERVER NAME: IDAAVIPA PRODUCT ID: AQT04010 STATE: ONLINE
--------------------------------------------------------------------------------------------------------------------------
QUERIES SUCCESSFULLY EXECUTED 0.00 AVG QUEUE LENGTH (LAST 3 HOURS) N/A
QUERIES FAILED TO EXECUTE 0.00 AVG QUEUE LENGTH (LAST 24 HOURS) N/A
ACCELERATOR IN INVALID STATE N/A MAXIMUM QUEUE LENGTH 0.00
CURRENTLY EXECUTING QUERIES N/A CURRENT QUEUE LENGTH 0.00
MAXIMUM EXECUTING QUERIES N/A MAX QUEUE WAIT ELAPSED TIME 00:00:00.207246
AVG QUEUE WAIT ELAPSED TIME 00:00:00.000000
CONNECTS TO ACCELERATOR 1.00 WORKER NODES 4.00
REQUESTS SENT TO ACCELERATOR 1.00 WORKER NODES AVG CPU UTILIZATION (%) N/A
TIMED OUT 0.00 WORKER NODES CUR CPU UTILIZATION (%) 30.00
FAILED 0.00
BYTES SENT TO ACCELERATOR 2702.00 DISK STORAGE AVAILABLE (MB) 8024544.00
BYTES RECEIVED FROM ACCELERATOR 828.00 IN USE FOR DATABASE (MB) 110.00
MESSAGES SENT TO ACCELERATOR 11.00 CUR DISK UTIL ON WORKER NODES 0.00
MESSAGES RECEIVED FROM ACCEL 0.00 DATA SLICES 22.00
BLOCKS SENT TO ACCELERATOR 0.00 DATA SKEW (%) N/A
BLOCKS RECEIVED FROM ACCELERATOR 0.00
ROWS SENT TO ACCELERATOR 0.00 PROCESSORS 64.00
ROWS RECEIVED FROM ACCELERATOR 0.00
ELAPSED TIME IN ACCELERATOR 00:00:00.000000
TCP/IP SERVICES ELAPSED TIME 00:00:00.011760 CPU TIME SPENT IN ACCELERATOR 00:00:00.000000
TCP/IP SERVICES CPU TIME 00:00:00.001305 WAIT TIME IN ACCELERATOR 00:00:00.000000
1 BSTATLT : STATISTICS LONG TRACE 02/23/15 08:10:17 PAGE 574
GROUP : DB2 STATISTICS TRACE - LONG DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:54:00.11 END RECORD: ( 15.054 ) 02/23/15 07:55:00.41
ELAPSED TIME: 00:01:00.30 THREADS: 12 #DBATS: 0 COMMITS: 12 INCREMENTAL BIND: 2
TIME LAST ACCEL STATUS CHANGE 2015-02-17-18.40.24
TIME ACCELERATOR PROCESS STARTED 2015-02-17-18.40.16 COORDINATOR AVG CPU UTILIZATION (%) N/A
TIME LAST REPLICATION STATUS CHANGE N/P COORDINATOR CUR CPU UTILIZATION (%) 0.99
BY ALL DB2 SUBSYSTEMS BY THIS DB2 (DEFG)
SUCCESSFUL QUERIES SENT 0.00 CURRENT QUERIES EXECUTING 1.00
FAILED QUERIES SENT 0.00 MAX QUERIES EXECUTED 3.00
CURRENT QUERIES EXECUTING 1.00 TOTAL QUERY CPU COST 00:00:00.00
MAX QUERIES EXECUTED 3.00 TOTAL MAINT CPU COST 00:00:00.00
TOTAL QUERY CPU COST 00:00:00.000000
TOTAL MAINT CPU COST 00:00:00.000000 CAPTURE AGENT
DISK SPACE (MB) 707.00 LOG RECORDS READ N/P
REPLICATION APPLY CPU COST 00:00:00.000000 LOG RECORDS PROCESSED N/P
BYTES PROCESSED N/P
CAPTURE AGENT INSERTED ROWS N/P
LOG RECORDS READ N/P UPDATED ROWS N/P
LOG RECORDS PROCESSED N/P DELETED ROWS N/P
BYTES PROCESSED N/P CURRENT REPLICATION LATENCY N/P
INSERTED ROWS N/P CURRENT REPLICATION STATE UNKNOWN
UPDATED ROWS N/P
DELETED ROWS N/P
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*