DB2 statistics detail report (BSTATDR)
The following figure shows a sample of the DB2 statistics detail report (BSTATDR).
The individual sections, and field descriptions of this report are listed under Statistics-report-fields.
1 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 37
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
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 24 1.00 0.09 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 261 10.88 0.98 0.91
PREPARE 5193 216.39 19.60 18.03 SET CURRENT DEGREE 2596 108.17 9.80 9.01
DESCRIBE 5193 216.39 19.60 18.03 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 2621 109.22 9.89 9.10 CONNECT TYPE 2 0 0.00 0.00 0.00
CLOSE CURSOR 2620 109.17 9.89 9.10 RELEASE 0 0.00 0.00 0.00
FETCH 5218 217.43 19.69 18.12 SET CONNECTION 0 0.00 0.00 0.00
SET CURRENT PATH 0 0.00 0.00 0.00
TOTAL 20869 869.60 78.75 72.46 SET CURRENT PRECISION 0 0.00 0.00 0.00
ASSOCIATE LOCATORS 0 0.00 0.00 0.00
ROWS DELETED N/P 0.00 0.00 0.00 ALLOCATE LOCATORS 0 0.00 0.00 0.00
ROWS FETCHED N/P 0.00 0.00 0.00 HOLD LOCATOR 0 0.00 0.00 0.00
ROWS INSERTED N/P 0.00 0.00 0.00 FREE LOCATOR 0 0.00 0.00 0.00
ROWS UPDATED N/P 0.00 0.00 0.00 HOLD LOCATOR 0 0.00 0.00 0.00
TOTAL 2857 119.05 10.78 9.92
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 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 38
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
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 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 SEQUENCE 0 0.00 0.00 0.00
ALTER VIEW 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
DROP TRUSTED CONTEXT 0 0.00 0.00 0.00
ALTER TRUSTED CONTEXT 0 0.00 0.00 0.00
1 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 39
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
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 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 40
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
EDM POOL QUANTITY /MINUTE /THREAD /COMMIT SUBSYSTEM SERVICES QUANTITY /MINUTE /THREAD /COMMIT
------------------------- -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
PAGES IN RDS POOL (BELOW) 0 N/A N/A N/A IDENTIFY 5 0.21 0.02 0.02
HELD BY CT 0 N/A N/A N/A CREATE THREAD 265 11.04 1.00 0.92
HELD BY PT 0 N/A N/A N/A SIGNON 0 0.00 0.00 0.00
FREE PAGES 0 N/A N/A N/A TERMINATE 268 11.17 1.01 0.93
FAILS DUE TO POOL FULL 0 0.00 0.00 0.00 ROLLBACK 1 0.04 0.00 0.00
PAGES IN RDS POOL (ABOVE) 0 N/A N/A N/A COMMIT PHASE 1 0 0.00 0.00 0.00
HELD BY CT 0 N/A N/A N/A COMMIT PHASE 2 0 0.00 0.00 0.00
HELD BY PT 0 N/A N/A N/A READ ONLY COMMIT 24 1.00 0.09 0.08
FREE PAGES 0 N/A N/A N/A
FAILS DUE TO POOL FULL 0 0.00 0.00 0.00
PAGES IN DBD POOL (ABOVE) 5850
HELD BY DBD 97
FREE PAGES 5753
FAILS DUE TO DBD PL FULL 0 0.00 0.00 0.00
PAGES IN STMT PL (ABOVE) 2500
HELD BY STATEMENTS 12
FREE PAGES 2488
FAILS DUE TO STMT PL FULL 0 0.00 0.00 0.00
PAGES IN SKEL PL (ABOVE) 1280
HELD BY SKCT 4
HELD BY SKPT 8
FREE PAGES 1268
FAILS DUE TO SKEL PL FULL 0 0.00 0.00 0.00
UNIT REC INDOUBT 0 0.00 0.00 0.00
CT REQUESTS 265 11.04 1.00 0.92 UNIT REC INDBT RSLVD 0 0.00 0.00 0.00
CT NOT IN EDMPOOL 0 0.00 0.00 0.00 SYNCHS(SINGLE PHASE) 263 10.96 0.99 0.91
FAILS DUE POOL FULL 0 0.00 0.00 0.00 Q'D CREATE THREAD 0 0.00 0.00 0.00
PAGES USED IN STMT POOL 12 0.00 0.04 0.04 SUBSYSTEM MEMORY EOT 1 0.04 0.00 0.00
FAILS DUE STMT POOL FULL 0 0.00 0.00 0.00 SUBSYSTEM MEMORY EOM 0 0.00 0.00 0.00
PAGES IN EDM STMT POOL 2500 0.00 9.43 8.68 SYSTEM EVENT CHKPT 0 0.00 0.00 0.00
FREE PAGES IN EDM STMT PL 2488 0.00 9.39 8.64 HIGH WATER MARK IDBACK 10 0.42 0.04 0.03
PAGES FOR DYN SQL CACHE N/P 0.00 0.00 0.00 HIGH WATER MARK IDFORE 0 0.00 0.00 0.00
CT REQS/NOT IN EDM N/P HIGH WATER MARK CTHREAD 10 0.42 0.04 0.03
PAGES IN DBD FREE CHAIN 5753 239.71 21.71 19.97
FAILS DUE TO DBD FULL 0 0 0 0 WRITE REGISTER REQUESTS QUANTITY /MINUTE /THREAD /COMMIT
%STMT POOL IN USE 0.46 -------------------------- -------- ------- ------- -------
REQ FOR PT SECTS 1114 46.42 4.20 3.87 # FAIL STMT SKEL POOL FULL 0 0 0 0
LOAD PT SECT/DASD 0 0.00 0.00 0.00 # PGS IN SKEL EDM POOL 1280 53 5 4
PT REQS/NOT IN EDM N/P #FREE PGS IN SKEL EDM POOL 1268 53 5 4
REQUESTS FOR DBD 846 35.25 3.19 2.94 # PGS USED CT ATB 0 0 0 0
LOAD DBD FROM DASD 1 0.04 0.00 0.00 # PGS USED PT ATB 0 0 0 0
DBD REQS/NOT IN EDM 846.00 # FAIL STMT ATB POOL FULL 0 0 0 0
STMTS IN GLOBAL CACHE 2 0.08 0.01 0.01 # PGS IN STMT ATB EDM POOL 0 0 0 0
PAGES IN DBD 5850 243.77 22.08 20.31 # FREE PGS ABOVE EDM POOL 0 0 0 0
%DBD POOL IN USE 0.02 # CACHED NOT FOUND RECORDS 0 0 0 0
1 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 41
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
PAGES USED IN DBD POOL 98 4 0 0 # NOT FOUND RECORDS ADDED 0 0 0 0
# NOT FOUND RECORDS REMOVED 0 0 0 0
PREP_STMT_CACHE_INSERTS 1 0.04 0.00 0.00
PREP_STMT_CACHE_REQUESTS 2598 108.26 9.80 9.02
PREP_STMT_CACHE_PAGES N/P 0.00 0.00 0.00
NUM OF XPROC REQUESTS 0 0.00 0.00 0.00
STRG ALLOC TO XPROC 0 0.00 0.00 0.00
STEALABLE SKEL PAGES 1 0.04 0.00 0.00
STEALABLE DBD PAGES 3 0.13 0.01 0.01
STRG ALLOC TO PLAN BTB 0 0.00 0.00 0.00
STRG ALLOC TO PKGS BTB 0 0.00 0.00 0.00
STRG ALLOC TO PLAN ATB 4224 176.01 15.94 14.67
STRG ALLOC TO PKGS ATB 0 0.00 0.00 0.00
1 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 42
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
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 103 4.29 0.39 0.36 READ SATISF'D-ACTIVE LOG 0 0.00 0.00 0.00
DS NOT IN USE/NOT CLOSED 50 2.08 0.19 0.17 READ SATISF'D-ACTV LOG(%) N/P
IN USE DATA SETS 54 2.24 0.20 0.19 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
DS CONVERTED R/W TO R/O 0 0.00 0.00 0.00 WRITE - NOWAIT 237 9.88 0.89 0.82
WRITE OUTPUT LOG BUFFERS 18 0.75 0.07 0.06
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 1.59 1.59 1.46
CONT INTERV CREATED-ACTV 29 1.21 0.11 0.10
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 N/P 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 WRITE I/O REQ 56 2.33 0.21 0.19
LOG CI WRITTEN 0 0.00 0.00 0.00
LOG RATE FOR 1 LOG (MB) N/A 0.00 N/A N/A
LOG WRITE SUSPENDED 18 0.75 0.07 0.06
1 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 43
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
PLAN/PACKAGE PROCESSING QUANTITY /MINUTE /THREAD /COMMIT DB2 COMMANDS QUANTITY /MINUTE
------------------------- -------- ------- ------- ------- -------------------------- -------- -------
PLAN ALLOC ATTEMPTS 265 11.04 1.00 0.92 DISPLAY DATABASE 0 0.00
PLAN ALLOC SUCCESSFUL 265 11.04 1.00 0.92 DISPLAY THREAD 0 0.00
PACKAGE ALLOC ATTEMPTS 285 11.88 1.08 0.99 DISPLAY UTILITY 0 0.00
PACKAGE ALLOC SUCCESSFUL 285 11.88 1.08 0.99 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
REBIND PKG SUBCMDS 0 0.00 0.00 0.00 ALTER BUFFERPOOL 0 0.00
ATTEMPT TO REBIND PACKAGE 0 0.00 0.00 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 2 0.08
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 1 0.04
PACKAGES REBOUND 0 0.00 0.00 0.00 STOP DB2 0 0.00
FREE PLAN SUBCOMMANDS 0 0.00 0.00 0.00 MODIFY TRACE 3 0.13
ATTEMPTS TO FREE A PLAN 0 0.00 0.00 0.00 CANCEL DDF THREAD 1 0.04
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 48 2.00 0.18 0.17 ARCHIVE LOG 0 0.00
SET ARCHIVE 0 0.00
UNRECOGNIZED CMDS 0 0.00
NUMBER START PROFILE CMDS 0 0.00
NUMBER STOP PROFILE CMDS 0 0.00
NUMBER ACCESS DB CMDS 0 0.00
TOTAL 7 0.29
1 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 44
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
RID LIST PROCESSING QUANTITY /MINUTE /THREAD /COMMIT AUTHORIZATION MANAGEMENT QUANTITY /MINUTE /THREAD /COMMIT
------------------------ -------- ------- ------- ------- -------------------------- -------- ------- ------- ------
MAX RID BLOCKS ALLOCATED 3 0.13 0.01 0.01 AUTHORIZATION ATTEMPTS 371 15.46 1.40 1.29
CURRENT RID BLOCKS ALLOC 2 0.08 0.01 0.01 AUTHORIZATION SUCCESSFUL 371 15.46 1.40 1.29
TERMINATED - NO STORAGE 0 0.00 0.00 0.00 AUTH SUCC-WITHOUT CATALOG 264 11.00 1.00 0.92
TERM'D-EXCEED RDS LIMIT 0 0.00 0.00 0.00 AUTH SUCC-EXEC TO PUBLIC 214 8.92 0.81 0.74
TERM'D-EXCEED DM LIMIT 0 0.00 0.00 0.00 AUTH SUCC-PKG W/O CATALOG 24 1.00 0.09 0.08
TERM'D-EXCEED PROC LIMIT 0 0.00 0.00 0.00 AUTH SUCC-PKG-PUB-W/O CAT 24 1.00 0.09 0.08
TIMES OVWFL NO RID STRG 0 0.00 0.00 0.00 AUTH UNSUCC-PKG-CACHE 0 0.00 0.00 0.00
TIMES OVWFL NO RID INTLMT 0 0.00 0.00 0.00 PKG CACHE OVERWRT - AUTHID 0 0.00 0.00 0.00
TIMES HYBRD JOIN INT STRG 0 0.00 0.00 0.00 PKG CACHE OVERWRT - ENTRY 0 0.00 0.00 0.00
TIMES HYBRD JOIN INT INTL 0 0.00 0.00 0.00 RTN_AUTH SUCC-W/O CATLG 0 0.00 0.00 0.00
TIMES MIAP SKIPPED PRE_OT 0 0.00 0.00 0.00 RTN_AUTH SUCC-PUB W/OCAT 0 0.00 0.00 0.00
RTN_AUTH UNSUCC_CACHE 0 0.00 0.00 0.00
RTN CACHE OVERWRT AUTH 0 0.00 0.00 0.00
RTN CACHE OVERWRT ENTRY 0 0.00 0.00 0.00
RTN CACHE ENTRY NOT ADDED 0 0.00 0.00 0.00
1 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 45
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
WORK FILE DATABASE QUANTITY /MINUTE /THREAD /COMMIT
------------------------ -------- ------- ------- -------
CURR TOT STG USED (KB) 0 0.00 0.00 0.00
MAX STORAGE USED (KB) 64 N/A N/A N/A
MAX LIMIT PER USER (KB) 0 N/A N/A N/A
NUMBER LIMIT EXCEEDED 0 0.00 0.00 0.00
4K TS STOR USED (KB) 0 0.00 0.00 0.00
32K TS STOR USED (KB) 0 0.00 0.00 0.00
4K USED, 32 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 /COMMIT
------------------------ -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
SUSPENSIONS (ALL) 2 0.08 0.01 0.01 LOCK REQUESTS (P-LOCKS) N/P N/P 0.00 0.00
SUSPENSIONS (LOCK ONLY) 0 0.00 0.00 0.00 UNLOCK REQUESTS (P-LOCKS) N/P N/P 0.00 0.00
SUSPENSIONS (LATCH ONLY) 2 0.08 0.01 0.01 CHANGE REQUESTS (P-LOCKS) N/P N/P 0.00 0.00
SUSPENSIONS (OTHER) 0 0.00 0.00 0.00
SYNCH.XES - LOCK REQUESTS N/P N/P 0.00 0.00
TIMEOUTS 0 0.00 0.00 0.00 SYNCH.XES - CHANGE REQS N/P N/P 0.00 0.00
DEADLOCKS 0 0.00 0.00 0.00 SYNCH.XES - UNLOCK REQS N/P N/P 0.00 0.00
ASYNCH.XES - RESOURCES N/P N/P 0.00 0.00
LOCK REQUESTS 5591 232.97 21.10 19.41
UNLOCK REQUESTS 4117 171.55 15.54 14.30 SUSPENDS - IRLM GLOB. CONT N/P N/P 0.00 0.00
QUERY REQUESTS 0 0.00 0.00 0.00 SUSPENDS - XES GLOBAL CONT N/P N/P 0.00 0.00
CHANGE REQUESTS 2873 119.72 10.84 9.98 SUSPENDS - FALSE CONT. N/P N/P 0.00 0.00
OTHER REQUESTS 0 0.00 0.00 0.00 INCOMPATIBLE RETAINED LOCK N/P N/P 0.00 0.00
LOCK ESCALATION (SHARED) 0 0.00 0.00 0.00 NOTIFY MESSAGES SENT N/P N/P 0.00 0.00
LOCK ESCALATION (EXCL) 0 0.00 0.00 0.00 NOTIFY MESSAGES RECEIVED N/P N/P 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 N/P 0.00 0.00
DRAIN REQUESTS FAILED 0 0.00 0.00 0.00
CLAIM REQUESTS 17176 715.71 64.82 59.64 PSET/PART P-LOCK NEG. N/P N/P 0.00 0.00
CLAIM REQUESTS FAILED 0 0.00 0.00 0.00 PAGE P-LOCK NEGOTIATION N/P N/P 0.00 0.00
OTHER P-LOCK NEGOTIATION N/P N/P 0.00 0.00
P-LOCK CHANGE DURING NEG. N/P N/P 0.00 0.00
REJECTIONS HEURSTIC ALG-XES N/P
GLOBAL CONTENTION RATE(%) N/P
FALSE CONTENTION RATE(%) N/P
XES RATE(%) 0
1 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 46
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
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 N/P 0.00 0.00
CURRENT ACTIVE DBATS 0 0.00 0.00 0.00 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 0.00 0.00 0.00 GROUPS INTFNDED - 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 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 47
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
TCB TIME SRB TIME TOTAL TIME ZIIP TIME
CPU TIMES H:MM:SS.THTTH H:MM.SS.THTTH H:MM.SS.THTTH H:MM.SS.THTTH
------------------------ ------------- ------------- ------------- -------------
SYSTEM SRVCS ADDR SPC 00:00.58180 00:00.27823 00:00.86004 00:00.00000
DATABASE SRVCS ADDR SPC 00:00.12384 00:32.56738 00:32.69123 00:13.56969
IRLM 00:00.00007 00:00.24173 00:00.24180 00:00.00000
DDF ADDRESS SPACE 00:00.18279 00:00.03185 00:00.21464 00:00.00000
TOTAL 00:00.88851 00:33.11919 00:34.00770
PREEMPTABLE SRB TIMER VALUE, NOT INCLUDING CPU ON AN IBM ZIIP (DB2 V7 ABOVE) 15:39:24
PREEMPTABLE SRB TIMER VALUE CONSUMED ON AN IBM ZIIP (DB2 V8 ABOVE) 15:33:47
DB2 APPL.PRGR.INTERFACE QUANTITIY /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 LOGREADS PERFORMED 0 0.00 0.00 0.00
COMMAND REQUESTS 5 0.21 0.02 0.02 LOG RECORDS RETURNED 0 0.00 0.00 0.00
READA REQUESTS 1399 58.30 5.28 4.86 DATA ROWS RETURNED 0 0.00 0.00 0.00
READS REQUESTS 125 5.21 0.47 0.43 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 1529 63.71 5.77 5.31
IFC DEST WRITTEN NOT WRTN BUF OVER NOT ACCP WRT FAIL
-------- -------- -------- -------- -------- --------
SMF 838 0 N/P 0 0
GTF 0 0 0 0 0
OP1 421 0 0 0 0
OP2 580 0 0 0 0
OP3 580 0 0 0 0
OP4 55 0 0 0 0
OP5 52 0 0 0 0
OP6 0 2603750 0 37113 0
OP7 0 2603750 0 36854 0
OP8 0 0 0 0 0
RES 0 0 0 0 0
TOTAL 2526 5207500 0 73967 0
IFC RECORD COUNT WRITTEN NOT WRTN LATCH CNT /SECOND /SECOND /SECOND /SECOND MISCELLANEOUS
---------------- -------- -------- --------- ------- ------- ------- ------- ----------------------------------------
SYSTEM RELATED 194 53 LC01-LC04 0.00 0.00 0.00 0.00 LOG RBA ADDRESS: 00000199C8BC3A84
DATABASE RELATED 194 53 LC05-LC08 0.00 0.00 0.00 0.00 STATS INVOKE RSN: ACTIVATED BY TIMER
ACCOUNTING 984 528 LC09-LC12 0.00 0.00 0.00 0.00 BYPASSED COLUMNS: 0
START TRACE 5 0 LC13-LC16 0.00 7.50 0.00 0.00 MAX SQL CASCAD LVL: N/P
STOP TRACE 4 0 LC17-LC20 0.00 0.00 0.00 0.00 MAX STOR LOB VALUES: N/P
SYSTEM PARMS 24 48 LC21-LC24 0.00 0.00 0.15 0.09
SYS PARMS-BPOOL 44 48 LC25-LC28 0.00 0.00 0.00 0.00
AUDIT 0 0 LC29-LC32 0.00 0.00 0.00 0.00
TOTAL 1449 730
1 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 48
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
OPTIMIZATION QUANTITY /MINUTE /THREAD /COMMIT MISCELLANEOUS
------------------------ -------- ------- ------- ------- ----------------------------------------------
PREPARE REQUESTS 2598 108.26 9.80 9.02 LOG RBA ADDRESS: 00000199C8BC3A84
FULL PREPARES 1 0.04 0.00 0.00 STATS INVOKE RSN: ACTIVATED BY TIMER
HALF PREPARES 2596 108.17 9.80 9.01 BYPASSED COLUMNS: 0
IMPLICIT_PREPARES 0 0.00 0.00 0.00
PREPARE AVOIDED 0 0.00 0.00 0.00
STMT INVALID (MAXKEEPD) 0 0.00 0.00 0.00
STMT INVALID (DDL) 0 0.00 0.00 0.00
NUMBER OF REOPTIMIZATION N/P 0.00 0.00 0.00
DB2 PARSED DY-ST CON STMT N/P 0.00 0.00 0.00
DB2 REPL DY-ST CON STMT N/P 0.00 0.00 0.00
DB2 MATCH DY-ST CON STMT N/P 0.00 0.00 0.00
DB2 DUPLIC DY-ST CON STMT N/P 0.00 0.00 0.00
GLOBAL CACHE HIT RATIO% 99.96
LOCAL CACHE HIT RATIO(%) N/P
TOTAL DBM1 STORAGE BELOW 2GB 618940
STORAGE CUSHION 119328K
REAL STORAGE IN USE 83679
AUXILIARY STORAGE IN USE 0
1 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 49
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
BP0 GENERAL QUANTITY /MINUTE /THREAD /COMMIT BP0 READ OPERATIONS QUANTITY /MINUTE /THREAD /COMMIT
------------------------ -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
AVERAGE ACTIVE BUFFERS 62 N/A N/A N/A GETPAGE REQUESTS 10403550 433508 39258.7 36123.4
UNAVAIL BUF-VPOOL FULL 0 0.00 0.00 0.00 GETPAGE REQUEST-SEQUENTIAL 2598 108.26 9.80 9.02
GETPAGE REQUEST-RANDOM 10400952 433400 39248.9 36114.4
NUMBER OF DATASET OPENS 1 0.04 0.00 0.00
SYNCHRONOUS READS 47399 1975.08 178.86 164.58
BUFFERS ALLOCATED-VPOOL 2000 83.34 7.55 6.94 SYNCHRON READS-SEQUENTIAL 2596 108.17 9.80 9.01
BUFFERS ALLOCATED-HPOOL N/P N/P N/P N/P SYNCHRON READS-RANDOM N/A N/A N/A N/A
HPOOL BUFFERS BACKED N/P N/P N/P N/P
GETPAGE PER SYNCH READS 232.15
DFHSM MIGRATED DATASETS 0 0.00 0.00 0.00
DFHSM RECALL TIMEOUTS 0 0.00 0.00 0.00 SEQUENT'L PREFETCH REQUEST 5192 216.35 19.59 18.03
SEQUENTIAL PREFETCH READS 2596 108.17 9.80 9.01
HPOOL EXPAND/CONTRACT N/P N/P 0.00 0.00 PAGES READ VIA SEQ PREF 23364 973.56 88.17 81.13
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 207649 8652.58 783.58 721.00
CONCUR PREF I/O - HWM 0 0.00 0.00 0.00 LIST PREFETCH READS 206699 8612.99 780.00 717.70
PREF I/O STREAM REDUCED 0 0.00 0.00 0.00 PAGES READ VIA LIST PREF 5130767 213795 19361.4 17815.2
PARALLEL QUERY REQUESTS 0 0.00 0.00 0.00 L PRF PAGE READ/L PRF READ 24.82
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 363327 15139.6 1371.05 1261.55
PREF QUANT REDUCED 1/4 0 0.00 0.00 0.00 DYNAMIC PREFETCH READS 311423 12976.8 1175.18 1081.33
PAGES READ VIA DYN PREFTCH 7637894 318265 28822.2 26520.5
D PRF PAGE READ/D PRF READ 24.53
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 N/P 0.00 0.00
ASYNC HPOOL READ N/P N/P 0.00 0.00
HPOOL READ FAILED N/P N/P 0.00 0.00
ASYN DA MOVR HPOOL READ-S N/P N/P 0.00 0.00
ASYN DA MOVR HPOOL READ-F N/P N/P 0.00 0.00
BPOOL HIT RATIO (%) 99.52
HPOOL HIT RATIO (%) 0.00
HPOOL R/W RATIO (%) N/P
1 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 50
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
BP0 WRITE OPERATIONS QUANTITY /MINUTE /THREAD /COMMIT BP0 SORT/MERGE QUANTITY /MINUTE /THREAD /COMMIT
------------------------ -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
BUFFER UPDATES 203 8.46 0.77 0.70 MAX WORKFILES CONCURR USED 0 0.00 0.00 0.00
PAGES WRITTEN 67 2.79 0.25 0.23 MERGE PASSES REQUESTED 0 0.00 0.00 0.00
BUFF UPDATE/PAGE WRITTEN 3.03 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 9 0.38 0.03 0.03 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 7.44 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 # TIMES PGS UNLCK CASTOUT 0 0.00 0.00 0.00
DM CRITICAL THRESHOLD 0 0.00 0.00 0.00 # TIMES I/O ON CASTSOUT 0 0.00 0.00 0.00
WRITE ENGINE NOT AVAIL N/P N/P 0.00 0.00
PAGE INS REQ FOR WRITE 0 0.00 0.00 0.00
SYNC HPOOL WRITE N/P N/P 0.00 0.00
ASYNC HPOOL WRITE N/P N/P 0.00 0.00
HPOOL WRITE FAILED N/P N/P 0.00 0.00
ASYN DA MVR HPOOL WRIT-S N/P N/P 0.00 0.00
ASYN DA MVR HPOOL WRIT-F N/P N/P 0.00 0.00
1 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 51
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
BP1 GENERAL QUANTITY /MINUTE /THREAD /COMMIT BP1 READ OPERATIONS QUANTITY /MINUTE /THREAD /COMMIT
------------------------ -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
AVERAGE ACTIVE BUFFERS 6 N/A N/A N/A GETPAGE REQUESTS 42499 1770.90 160.37 147.57
UNAVAIL BUF-VPOOL FULL 0 0.00 0.00 0.00 GETPAGE REQUEST-SEQUENTIAL 12975 540.66 48.96 45.05
GETPAGE REQUEST-RANDOM 29524 1230.24 111.41 102.51
NUMBER OF DATASET OPENS 0 0.00 0.00 0.00
SYNCHRONOUS READS 0 0.00 0.00 0.00
BUFFERS ALLOCATED-VPOOL 6656 277.35 25.12 23.11 SYNCHRON READS-SEQUENTIAL 0 0.00 0.00 0.00
BUFFERS ALLOCATED-HPOOL N/P N/P N/P N/P SYNCHRON READS-RANDOM N/A N/A N/A N/A
HPOOL BUFFERS BACKED N/P N/P N/P N/P
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 N/P 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 1402 58.42 5.29 4.87
SYNC HPOOL READ N/P N/P 0.00 0.00
ASYNC HPOOL READ N/P N/P 0.00 0.00
HPOOL READ FAILED N/P N/P 0.00 0.00
ASYN DA MOVR HPOOL READ-S N/P N/P 0.00 0.00
ASYN DA MOVR HPOOL READ-F N/P N/P 0.00 0.00
BPOOL HIT RATIO (%) 100.00
HPOOL HIT RATIO (%) 0.00
HPOOL R/W RATIO (%) N/P
1 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 52
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
BP1 WRITE OPERATIONS QUANTITY /MINUTE /THREAD /COMMIT BP1 SORT/MERGE QUANTITY /MINUTE /THREAD /COMMIT
------------------------ -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
BUFFER UPDATES 36331 1513.89 137.10 126.15 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 # TIMES PGS UNLCK CASTOUT 0 0.00 0.00 0.00
DM CRITICAL THRESHOLD 0 0.00 0.00 0.00 # TIMES I/O ON CASTSOUT 0 0.00 0.00 0.00
WRITE ENGINE NOT AVAIL N/P N/P 0.00 0.00
PAGE INS REQ FOR WRITE 0 0.00 0.00 0.00
SYNC HPOOL WRITE N/P N/P 0.00 0.00
ASYNC HPOOL WRITE N/P N/P 0.00 0.00
HPOOL WRITE FAILED N/P N/P 0.00 0.00
ASYN DA MVR HPOOL WRIT-S N/P N/P 0.00 0.00
ASYN DA MVR HPOOL WRIT-F N/P N/P 0.00 0.00
1 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 53
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
BP8K0 GENERAL QUANTITY /MINUTE /THREAD /COMMIT BP8K0 READ OPERATIONS QUANTITY /MINUTE /THREAD /COMMIT
------------------------ -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
AVERAGE ACTIVE BUFFERS 0 N/A N/A N/A GETPAGE REQUESTS 97 4.04 0.37 0.34
UNAVAIL BUF-VPOOL FULL 0 0.00 0.00 0.00 GETPAGE REQUEST-SEQUENTIAL 0 0.00 0.00 0.00
GETPAGE REQUEST-RANDOM 97 4.04 0.37 0.34
NUMBER OF DATASET OPENS 0 0.00 0.00 0.00
SYNCHRONOUS READS 0 0.00 0.00 0.00
BUFFERS ALLOCATED-VPOOL 128 5.33 0.48 0.44 SYNCHRON READS-SEQUENTIAL 0 0.00 0.00 0.00
BUFFERS ALLOCATED-HPOOL N/P N/P N/P N/P SYNCHRON READS-RANDOM N/A N/A N/A N/A
HPOOL BUFFERS BACKED N/P N/P N/P N/P
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 N/P 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 10 0.42 0.04 0.03
SYNC HPOOL READ N/P N/P 0.00 0.00
ASYNC HPOOL READ N/P N/P 0.00 0.00
HPOOL READ FAILED N/P N/P 0.00 0.00
ASYN DA MOVR HPOOL READ-S N/P N/P 0.00 0.00
ASYN DA MOVR HPOOL READ-F N/P N/P 0.00 0.00
BPOOL HIT RATIO (%) 100.00
HPOOL HIT RATIO (%) 0.00
HPOOL R/W RATIO (%) N/P
1 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 54
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
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 # TIMES PGS UNLCK CASTOUT 0 0.00 0.00 0.00
DM CRITICAL THRESHOLD 0 0.00 0.00 0.00 # TIMES I/O ON CASTSOUT 0 0.00 0.00 0.00
WRITE ENGINE NOT AVAIL N/P N/P 0.00 0.00
PAGE INS REQ FOR WRITE 0 0.00 0.00 0.00
SYNC HPOOL WRITE N/P N/P 0.00 0.00
ASYNC HPOOL WRITE N/P N/P 0.00 0.00
HPOOL WRITE FAILED N/P N/P 0.00 0.00
ASYN DA MVR HPOOL WRIT-S N/P N/P 0.00 0.00
ASYN DA MVR HPOOL WRIT-F N/P N/P 0.00 0.00
1 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 55
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
BP16K0 GENERAL QUANTITY /MINUTE /THREAD /COMMIT BP16K0 READ OPERATIONS QUANTITY /MINUTE /THREAD /COMMIT
------------------------ -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
AVERAGE ACTIVE BUFFERS 0 N/A N/A N/A GETPAGE REQUESTS 2 0.08 0.01 0.01
UNAVAIL BUF-VPOOL FULL 0 0.00 0.00 0.00 GETPAGE REQUEST-SEQUENTIAL 0 0.00 0.00 0.00
GETPAGE REQUEST-RANDOM 2 0.08 0.01 0.01
NUMBER OF DATASET OPENS 0 0.00 0.00 0.00
SYNCHRONOUS READS 1 0.04 0.00 0.00
BUFFERS ALLOCATED-VPOOL 64 2.67 0.24 0.22 SYNCHRON READS-SEQUENTIAL 0 0.00 0.00 0.00
BUFFERS ALLOCATED-HPOOL N/P N/P N/P N/P SYNCHRON READS-RANDOM N/A N/A N/A N/A
HPOOL BUFFERS BACKED N/P N/P N/P N/P
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 N/P 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 7 0.29 0.03 0.02
SYNC HPOOL READ N/P N/P 0.00 0.00
ASYNC HPOOL READ N/P N/P 0.00 0.00
HPOOL READ FAILED N/P N/P 0.00 0.00
ASYN DA MOVR HPOOL READ-S N/P N/P 0.00 0.00
ASYN DA MOVR HPOOL READ-F N/P N/P 0.00 0.00
BPOOL HIT RATIO (%) 50.00
HPOOL HIT RATIO (%) 0.00
HPOOL R/W RATIO (%) N/P
1 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 56
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
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 # TIMES PGS UNLCK CASTOUT 0 0.00 0.00 0.00
DM CRITICAL THRESHOLD 0 0.00 0.00 0.00 # TIMES I/O ON CASTSOUT 0 0.00 0.00 0.00
WRITE ENGINE NOT AVAIL N/P N/P 0.00 0.00
PAGE INS REQ FOR WRITE 0 0.00 0.00 0.00
SYNC HPOOL WRITE N/P N/P 0.00 0.00
ASYNC HPOOL WRITE N/P N/P 0.00 0.00
HPOOL WRITE FAILED N/P N/P 0.00 0.00
ASYN DA MVR HPOOL WRIT-S N/P N/P 0.00 0.00
ASYN DA MVR HPOOL WRIT-F N/P N/P 0.00 0.00
1 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 57
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
BP32K GENERAL QUANTITY /MINUTE /THREAD /COMMIT BP32K READ OPERATIONS QUANTITY /MINUTE /THREAD /COMMIT
------------------------ -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
AVERAGE ACTIVE BUFFERS 0 N/A N/A N/A GETPAGE REQUESTS 0 0.00 0.00 0.00
UNAVAIL BUF-VPOOL FULL 0 0.00 0.00 0.00 GETPAGE REQUEST-SEQUENTIAL 0 0.00 0.00 0.00
GETPAGE REQUEST-RANDOM 0 0.00 0.00 0.00
NUMBER OF DATASET OPENS 0 0.00 0.00 0.00
SYNCHRONOUS READS 0 0.00 0.00 0.00
BUFFERS ALLOCATED-VPOOL 32 1.33 0.12 0.11 SYNCHRON READS-SEQUENTIAL 0 0.00 0.00 0.00
BUFFERS ALLOCATED-HPOOL N/P N/P N/P N/P SYNCHRON READS-RANDOM N/A N/A N/A N/A
HPOOL BUFFERS BACKED N/P N/P N/P N/P
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 N/P 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 4 0.17 0.02 0.01
SYNC HPOOL READ N/P N/P 0.00 0.00
ASYNC HPOOL READ N/P N/P 0.00 0.00
HPOOL READ FAILED N/P N/P 0.00 0.00
ASYN DA MOVR HPOOL READ-S N/P N/P 0.00 0.00
ASYN DA MOVR HPOOL READ-F N/P N/P 0.00 0.00
BPOOL HIT RATIO (%) N/P
HPOOL HIT RATIO (%) N/P
HPOOL R/W RATIO (%) N/P
1 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 58
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
BP32K WRITE OPERATIONS QUANTITY /MINUTE /THREAD /COMMIT BP32K 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 # TIMES PGS UNLCK CASTOUT 0 0.00 0.00 0.00
DM CRITICAL THRESHOLD 0 0.00 0.00 0.00 # TIMES I/O ON CASTSOUT 0 0.00 0.00 0.00
WRITE ENGINE NOT AVAIL N/P N/P 0.00 0.00
PAGE INS REQ FOR WRITE 0 0.00 0.00 0.00
SYNC HPOOL WRITE N/P N/P 0.00 0.00
ASYNC HPOOL WRITE N/P N/P 0.00 0.00
HPOOL WRITE FAILED N/P N/P 0.00 0.00
ASYN DA MVR HPOOL WRIT-S N/P N/P 0.00 0.00
ASYN DA MVR HPOOL WRIT-F N/P N/P 0.00 0.00
1 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 59
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
BP TOT GENERAL QUANTITY /MINUTE /THREAD /COMMIT BP TOT READ OPERATIONS QUANTITY /MINUTE /THREAD /COMMIT
------------------------ -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
AVERAGE ACTIVE BUFFERS 14 N/A N/A N/A GETPAGE REQUESTS 10446148 435283 39419.4 36271.3
UNAVAIL BUF-VPOOL FULL 0 0.00 0.00 0.00 GETPAGE REQUEST-SEQUENTIAL 15573 648.92 58.77 54.07
GETPAGE REQUEST-RANDOM 10430575 434634 39360.7 36217.3
NUMBER OF DATASET OPENS 1 0.04 0.00 0.00
SYNCHRONOUS READS 47400 1975.12 178.87 164.58
BUFFERS ALLOCATED-VPOOL 1776 370.02 33.51 30.83 SYNCHRON READS-SEQUENTIAL 2596 108.17 9.80 9.01
BUFFERS ALLOCATED-HPOOL N/P N/P N/P N/P SYNCHRON READS-RANDOM 44804 1866.95 169.07 155.57
HPOOL BUFFERS BACKED N/P N/P N/P N/P
GETPAGE PER SYNCH READS 232.80
DFHSM MIGRATED DATASETS 0 0.00 0.00 0.00
DFHSM RECALL TIMEOUTS 0 0.00 0.00 0.00 SEQUENT'L PREFETCH REQUEST 5192 216.35 19.59 18.03
SEQUENTIAL PREFETCH READS 2596 108.17 9.80 9.01
HPOOL EXPAND/CONTRACT N/P N/P 0.00 0.00 PAGES READ VIA SEQ PREF 23364 973.56 88.17 81.13
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 207649 8652.58 783.58 721.00
CONCUR PREF I/O - HWM 0 0.00 0.00 0.00 LIST PREFETCH READS 206699 8612.99 780.00 717.70
PREF I/O STREAM REDUCED 0 0.00 0.00 0.00 PAGES READ VIA LIST PREF 5130767 213795 19361.4 17815.2
PARALLEL QUERY REQUESTS 0 0.00 0.00 0.00 L PRF PAGE READ/L PRF READ 24.82
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 363327 15139.6 1371.05 1261.55
PREF QUANT REDUCED 1/4 0 0.00 0.00 0.00 DYNAMIC PREFETCH READS 311423 12976.8 1175.18 1081.33
PAGES READ VIA DYN PREFTCH 7637894 318265 28822.2 26520.5
D PRF PAGE READ/D PRF READ 24.53
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 1423 59.30 5.37 4.94
SYNC HPOOL READ N/P N/P 0.00 0.00
ASYNC HPOOL READ N/P N/P 0.00 0.00
HPOOL READ FAILED N/P N/P 0.00 0.00
ASYN DA MOVR HPOOL READ-S N/P N/P 0.00 0.00
ASYN DA MOVR HPOOL READ-F N/P N/P 0.00 0.00
BPOOL HIT RATIO (%) 99.52
HPOOL HIT RATIO (%) 0.00
HPOOL R/W RATIO (%) N/P
1 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 60
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
BP TOT WRITE OPERATIONS QUANTITY /MINUTE /THREAD /COMMIT BP TOT SORT/MERGE QUANTITY /MINUTE /THREAD /COMMIT
------------------------ -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
BUFFER UPDATES 36534 1522.34 137.86 126.85 MAX WORKFILES CONCURR USED 0 0.00 0.00 0.00
PAGES WRITTEN 67 2.79 0.25 0.23 MERGE PASSES REQUESTED 0 0.00 0.00 0.00
BUFF UPDATE/PAGE WRITTEN 545.28 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 9 0.38 0.03 0.03 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 7.44 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 # TIMES PGS UNLCK CASTOUT 0 0.00 0.00 0.00
DM CRITICAL THRESHOLD 0 0.00 0.00 0.00 # TIMES I/O ON CASTSOUT 0 0.00 0.00 0.00
WRITE ENGINE NOT AVAIL N/P N/P 0.00 0.00
PAGE INS REQ FOR WRITE 0 0.00 0.00 0.00
SYNC HPOOL WRITE N/P N/P 0.00 0.00
ASYNC HPOOL WRITE N/P N/P 0.00 0.00
HPOOL WRITE FAILED N/P N/P 0.00 0.00
ASYN DA MVR HPOOL WRIT-S N/P N/P 0.00 0.00
ASYN DA MVR HPOOL WRIT-F N/P N/P 0.00 0.00
DDF STATISTICS FOR REMOTE LOCATION: DRDA REMOTE LOCS
DESCRIPTION COUNT DESCRIPTION COUNT
---------------------------------------- ---------- --------------------------------------------- ----------
TRANSACTIONS SENT N/P TRANSACTIONS RECEIVED N/P
SINGLE PHASE COMMITS SENT 0 SINGLE PHASE COMMITS RECEIVED 0
SINGLE PHASE ROLLBACKS SENT 0 SINGLE PHASE ROLLBACKS RECEIVED 0
SQL STATEMENTS SENT 0 SQL STATEMENTS RECEIVED 0
ROWS SENT 0 ROWS RECEIVED 0
MESSAGES SENT 3463 MESSAGES RECEIVED 3452
BYTES SENT 141241 BYTES RECEIVED 1324563
BLOCKS SENT 0 BLOCKS RECEIVED 0
CONVERSATIONS SENT 2 CONVERSATIONS RECEIVED 0
CONVERSATIONS QUEUED 0 STATEMENTS BOUND AT SERVER N/P
LIMITED BLOCK FETCH SWITCH N/P MESSAGES IN BUFFER N/P
PREPARE REQUESTS SENT N/P PREPARE REQUESTS RECEIVED N/P
LAST AGENT REQUESTS SENT N/P LAST AGENT REQUESTS RECEIVED N/P
TWO PHASE COMMIT REQUESTS SENT N/P TWO PHASE COMMIT REQUESTS RECEIVED N/P
BACKOUT REQUESTS SENT N/P BACKOUT REQUESTS RECEIVED N/P
FORGET RESPONSES SENT N/P FORGET RESPONSES RECEIVED N/P
REQUEST COMMIT RESPONSES SENT N/P REQUEST COMMIT RESPONSES RECEIVED N/P
BACKOUT RESPONSES SENT N/P BACKOUT RESPONSES RECEIVED N/P
THREADS INDOUBT WITH REMOTE AS COORDINATOR 0 COMMITS WITH REMOTE LOCATION AS COORDINATOR N/P
BACKOUTS DONE WITH REMOTE AS COORDINATOR N/P
1 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 61
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
ACCELERATOR SERVER NAME: IDAAVIPA ACCELERATOR PRODUCT ID: AQT04010
--------------------------------------------------------------------------------------------------------------------------
QUERIES SUCCESSFULLY EXECUTED 0.00 AVG QUEUE LENGTH (LAST 3 HOURS) N/A
QUERIES FAILED TO EXECUTE 1.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 MAX QUEUE WAIT ELAPSED TIME 00:00:00.207246
MAXIMUM EXECUTING QUERIES N/A 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 (%) 1.99
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 ACCELERATOR 0.00 DATA SLICES 22.00
BLOCKS SENT TO ACCELERATOR 0.00 DATA SKEW (%) 0.00
BLOCKS RECEIVED FROM ACCELERATOR 0.00
ROWS SENT TO ACCELERATOR 0.00 PROCESSORS (AVG) 64.00
ROWS RECEIVED FROM ACCELERATOR 0.00
ELAPSED TIME IN ACCELERATOR 00:00:00.000000
TCP/IP SERVICES ELAPSED TIME 00:00:00.012209 CPU TIME SPENT IN ACCELERATOR 00:00:00.000000
TCP/IP SERVICES CPU TIME 00:00:00.001460 WAIT TIME IN ACCELERATOR 00:00:00.000000
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 (%) 3.99
BY ALL DB2 SUBSYSTEMS BY THIS DB2 (DEFG)
SUCCESSFUL QUERIES SENT 0.00 CURRENT QUERIES EXECUTING 0.00
FAILED QUERIES SENT 1.00 MAX QUERIES EXECUTED 3.00
CURRENT QUERIES EXECUTING 0.00 TOTAL QUERY CPU COST 00:00:00.10
MAX QUERIES EXECUTED 3.00 TOTAL MAINT CPU COST 00:00:00.00
TOTAL QUERY CPU COST 00:00:00.100000
TOTAL MAINT CPU COST 00:00:00.000000 CAPTURE AGENT
DISK SPACE (MB) 0.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 DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
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 24 1.00 0.09 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 261 10.88 0.98 0.91
PREPARE 5193 216.39 19.60 18.03 SET CURRENT DEGREE 2596 108.17 9.80 9.01
DESCRIBE 5193 216.39 19.60 18.03 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 2621 109.22 9.89 9.10 CONNECT TYPE 2 0 0.00 0.00 0.00
CLOSE CURSOR 2620 109.17 9.89 9.10 RELEASE 0 0.00 0.00 0.00
FETCH 5218 217.43 19.69 18.12 SET CONNECTION 0 0.00 0.00 0.00
SET CURRENT PATH 0 0.00 0.00 0.00
TOTAL 20869 869.60 78.75 72.46 SET CURRENT PRECISION 0 0.00 0.00 0.00
ASSOCIATE LOCATORS 0 0.00 0.00 0.00
ROWS DELETED N/P 0.00 0.00 0.00 ALLOCATE LOCATORS 0 0.00 0.00 0.00
ROWS FETCHED N/P 0.00 0.00 0.00 HOLD LOCATOR 0 0.00 0.00 0.00
ROWS INSERTED N/P 0.00 0.00 0.00 FREE LOCATOR 0 0.00 0.00 0.00
ROWS UPDATED N/P 0.00 0.00 0.00 HOLD LOCATOR 0 0.00 0.00 0.00
TOTAL 2857 119.05 10.78 9.92
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 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 38
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
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 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 SEQUENCE 0 0.00 0.00 0.00
ALTER VIEW 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
DROP TRUSTED CONTEXT 0 0.00 0.00 0.00
ALTER TRUSTED CONTEXT 0 0.00 0.00 0.00
1 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 39
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
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 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 40
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
EDM POOL QUANTITY /MINUTE /THREAD /COMMIT SUBSYSTEM SERVICES QUANTITY /MINUTE /THREAD /COMMIT
------------------------- -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
PAGES IN RDS POOL (BELOW) 0 N/A N/A N/A IDENTIFY 5 0.21 0.02 0.02
HELD BY CT 0 N/A N/A N/A CREATE THREAD 265 11.04 1.00 0.92
HELD BY PT 0 N/A N/A N/A SIGNON 0 0.00 0.00 0.00
FREE PAGES 0 N/A N/A N/A TERMINATE 268 11.17 1.01 0.93
FAILS DUE TO POOL FULL 0 0.00 0.00 0.00 ROLLBACK 1 0.04 0.00 0.00
PAGES IN RDS POOL (ABOVE) 0 N/A N/A N/A COMMIT PHASE 1 0 0.00 0.00 0.00
HELD BY CT 0 N/A N/A N/A COMMIT PHASE 2 0 0.00 0.00 0.00
HELD BY PT 0 N/A N/A N/A READ ONLY COMMIT 24 1.00 0.09 0.08
FREE PAGES 0 N/A N/A N/A
FAILS DUE TO POOL FULL 0 0.00 0.00 0.00
PAGES IN DBD POOL (ABOVE) 5850
HELD BY DBD 97
FREE PAGES 5753
FAILS DUE TO DBD PL FULL 0 0.00 0.00 0.00
PAGES IN STMT PL (ABOVE) 2500
HELD BY STATEMENTS 12
FREE PAGES 2488
FAILS DUE TO STMT PL FULL 0 0.00 0.00 0.00
PAGES IN SKEL PL (ABOVE) 1280
HELD BY SKCT 4
HELD BY SKPT 8
FREE PAGES 1268
FAILS DUE TO SKEL PL FULL 0 0.00 0.00 0.00
UNIT REC INDOUBT 0 0.00 0.00 0.00
CT REQUESTS 265 11.04 1.00 0.92 UNIT REC INDBT RSLVD 0 0.00 0.00 0.00
CT NOT IN EDMPOOL 0 0.00 0.00 0.00 SYNCHS(SINGLE PHASE) 263 10.96 0.99 0.91
FAILS DUE POOL FULL 0 0.00 0.00 0.00 Q'D CREATE THREAD 0 0.00 0.00 0.00
PAGES USED IN STMT POOL 12 0.00 0.04 0.04 SUBSYSTEM MEMORY EOT 1 0.04 0.00 0.00
FAILS DUE STMT POOL FULL 0 0.00 0.00 0.00 SUBSYSTEM MEMORY EOM 0 0.00 0.00 0.00
PAGES IN EDM STMT POOL 2500 0.00 9.43 8.68 SYSTEM EVENT CHKPT 0 0.00 0.00 0.00
FREE PAGES IN EDM STMT PL 2488 0.00 9.39 8.64 HIGH WATER MARK IDBACK 10 0.42 0.04 0.03
PAGES FOR DYN SQL CACHE N/P 0.00 0.00 0.00 HIGH WATER MARK IDFORE 0 0.00 0.00 0.00
CT REQS/NOT IN EDM N/P HIGH WATER MARK CTHREAD 10 0.42 0.04 0.03
PAGES IN DBD FREE CHAIN 5753 239.71 21.71 19.97
FAILS DUE TO DBD FULL 0 0 0 0 WRITE REGISTER REQUESTS QUANTITY /MINUTE /THREAD /COMMIT
%STMT POOL IN USE 0.46 -------------------------- -------- ------- ------- -------
REQ FOR PT SECTS 1114 46.42 4.20 3.87 # FAIL STMT SKEL POOL FULL 0 0 0 0
LOAD PT SECT/DASD 0 0.00 0.00 0.00 # PGS IN SKEL EDM POOL 1280 53 5 4
PT REQS/NOT IN EDM N/P #FREE PGS IN SKEL EDM POOL 1268 53 5 4
REQUESTS FOR DBD 846 35.25 3.19 2.94 # PGS USED CT ATB 0 0 0 0
LOAD DBD FROM DASD 1 0.04 0.00 0.00 # PGS USED PT ATB 0 0 0 0
DBD REQS/NOT IN EDM 846.00 # FAIL STMT ATB POOL FULL 0 0 0 0
STMTS IN GLOBAL CACHE 2 0.08 0.01 0.01 # PGS IN STMT ATB EDM POOL 0 0 0 0
PAGES IN DBD 5850 243.77 22.08 20.31 # FREE PGS ABOVE EDM POOL 0 0 0 0
%DBD POOL IN USE 0.02 # CACHED NOT FOUND RECORDS 0 0 0 0
1 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 41
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
PAGES USED IN DBD POOL 98 4 0 0 # NOT FOUND RECORDS ADDED 0 0 0 0
# NOT FOUND RECORDS REMOVED 0 0 0 0
PREP_STMT_CACHE_INSERTS 1 0.04 0.00 0.00
PREP_STMT_CACHE_REQUESTS 2598 108.26 9.80 9.02
PREP_STMT_CACHE_PAGES N/P 0.00 0.00 0.00
NUM OF XPROC REQUESTS 0 0.00 0.00 0.00
STRG ALLOC TO XPROC 0 0.00 0.00 0.00
STEALABLE SKEL PAGES 1 0.04 0.00 0.00
STEALABLE DBD PAGES 3 0.13 0.01 0.01
STRG ALLOC TO PLAN BTB 0 0.00 0.00 0.00
STRG ALLOC TO PKGS BTB 0 0.00 0.00 0.00
STRG ALLOC TO PLAN ATB 4224 176.01 15.94 14.67
STRG ALLOC TO PKGS ATB 0 0.00 0.00 0.00
1 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 42
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
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 103 4.29 0.39 0.36 READ SATISF'D-ACTIVE LOG 0 0.00 0.00 0.00
DS NOT IN USE/NOT CLOSED 50 2.08 0.19 0.17 READ SATISF'D-ACTV LOG(%) N/P
IN USE DATA SETS 54 2.24 0.20 0.19 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
DS CONVERTED R/W TO R/O 0 0.00 0.00 0.00 WRITE - NOWAIT 237 9.88 0.89 0.82
WRITE OUTPUT LOG BUFFERS 18 0.75 0.07 0.06
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 1.59 1.59 1.46
CONT INTERV CREATED-ACTV 29 1.21 0.11 0.10
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 N/P 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 WRITE I/O REQ 56 2.33 0.21 0.19
LOG CI WRITTEN 0 0.00 0.00 0.00
LOG RATE FOR 1 LOG (MB) N/A 0.00 N/A N/A
LOG WRITE SUSPENDED 18 0.75 0.07 0.06
1 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 43
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
PLAN/PACKAGE PROCESSING QUANTITY /MINUTE /THREAD /COMMIT DB2 COMMANDS QUANTITY /MINUTE
------------------------- -------- ------- ------- ------- -------------------------- -------- -------
PLAN ALLOC ATTEMPTS 265 11.04 1.00 0.92 DISPLAY DATABASE 0 0.00
PLAN ALLOC SUCCESSFUL 265 11.04 1.00 0.92 DISPLAY THREAD 0 0.00
PACKAGE ALLOC ATTEMPTS 285 11.88 1.08 0.99 DISPLAY UTILITY 0 0.00
PACKAGE ALLOC SUCCESSFUL 285 11.88 1.08 0.99 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
REBIND PKG SUBCMDS 0 0.00 0.00 0.00 ALTER BUFFERPOOL 0 0.00
ATTEMPT TO REBIND PACKAGE 0 0.00 0.00 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 2 0.08
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 1 0.04
PACKAGES REBOUND 0 0.00 0.00 0.00 STOP DB2 0 0.00
FREE PLAN SUBCOMMANDS 0 0.00 0.00 0.00 MODIFY TRACE 3 0.13
ATTEMPTS TO FREE A PLAN 0 0.00 0.00 0.00 CANCEL DDF THREAD 1 0.04
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 48 2.00 0.18 0.17 ARCHIVE LOG 0 0.00
SET ARCHIVE 0 0.00
UNRECOGNIZED CMDS 0 0.00
NUMBER START PROFILE CMDS 0 0.00
NUMBER STOP PROFILE CMDS 0 0.00
NUMBER ACCESS DB CMDS 0 0.00
TOTAL 7 0.29
1 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 44
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
RID LIST PROCESSING QUANTITY /MINUTE /THREAD /COMMIT AUTHORIZATION MANAGEMENT QUANTITY /MINUTE /THREAD /COMMIT
------------------------ -------- ------- ------- ------- -------------------------- -------- ------- ------- ------
MAX RID BLOCKS ALLOCATED 3 0.13 0.01 0.01 AUTHORIZATION ATTEMPTS 371 15.46 1.40 1.29
CURRENT RID BLOCKS ALLOC 2 0.08 0.01 0.01 AUTHORIZATION SUCCESSFUL 371 15.46 1.40 1.29
TERMINATED - NO STORAGE 0 0.00 0.00 0.00 AUTH SUCC-WITHOUT CATALOG 264 11.00 1.00 0.92
TERM'D-EXCEED RDS LIMIT 0 0.00 0.00 0.00 AUTH SUCC-EXEC TO PUBLIC 214 8.92 0.81 0.74
TERM'D-EXCEED DM LIMIT 0 0.00 0.00 0.00 AUTH SUCC-PKG W/O CATALOG 24 1.00 0.09 0.08
TERM'D-EXCEED PROC LIMIT 0 0.00 0.00 0.00 AUTH SUCC-PKG-PUB-W/O CAT 24 1.00 0.09 0.08
TIMES OVWFL NO RID STRG 0 0.00 0.00 0.00 AUTH UNSUCC-PKG-CACHE 0 0.00 0.00 0.00
TIMES OVWFL NO RID INTLMT 0 0.00 0.00 0.00 PKG CACHE OVERWRT - AUTHID 0 0.00 0.00 0.00
TIMES HYBRD JOIN INT STRG 0 0.00 0.00 0.00 PKG CACHE OVERWRT - ENTRY 0 0.00 0.00 0.00
TIMES HYBRD JOIN INT INTL 0 0.00 0.00 0.00 RTN_AUTH SUCC-W/O CATLG 0 0.00 0.00 0.00
TIMES MIAP SKIPPED PRE_OT 0 0.00 0.00 0.00 RTN_AUTH SUCC-PUB W/OCAT 0 0.00 0.00 0.00
RTN_AUTH UNSUCC_CACHE 0 0.00 0.00 0.00
RTN CACHE OVERWRT AUTH 0 0.00 0.00 0.00
RTN CACHE OVERWRT ENTRY 0 0.00 0.00 0.00
RTN CACHE ENTRY NOT ADDED 0 0.00 0.00 0.00
1 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 45
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
WORK FILE DATABASE QUANTITY /MINUTE /THREAD /COMMIT
------------------------ -------- ------- ------- -------
CURR TOT STG USED (KB) 0 0.00 0.00 0.00
MAX STORAGE USED (KB) 64 N/A N/A N/A
MAX LIMIT PER USER (KB) 0 N/A N/A N/A
NUMBER LIMIT EXCEEDED 0 0.00 0.00 0.00
4K TS STOR USED (KB) 0 0.00 0.00 0.00
32K TS STOR USED (KB) 0 0.00 0.00 0.00
4K USED, 32 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 /COMMIT
------------------------ -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
SUSPENSIONS (ALL) 2 0.08 0.01 0.01 LOCK REQUESTS (P-LOCKS) N/P N/P 0.00 0.00
SUSPENSIONS (LOCK ONLY) 0 0.00 0.00 0.00 UNLOCK REQUESTS (P-LOCKS) N/P N/P 0.00 0.00
SUSPENSIONS (LATCH ONLY) 2 0.08 0.01 0.01 CHANGE REQUESTS (P-LOCKS) N/P N/P 0.00 0.00
SUSPENSIONS (OTHER) 0 0.00 0.00 0.00
SYNCH.XES - LOCK REQUESTS N/P N/P 0.00 0.00
TIMEOUTS 0 0.00 0.00 0.00 SYNCH.XES - CHANGE REQS N/P N/P 0.00 0.00
DEADLOCKS 0 0.00 0.00 0.00 SYNCH.XES - UNLOCK REQS N/P N/P 0.00 0.00
ASYNCH.XES - RESOURCES N/P N/P 0.00 0.00
LOCK REQUESTS 5591 232.97 21.10 19.41
UNLOCK REQUESTS 4117 171.55 15.54 14.30 SUSPENDS - IRLM GLOB. CONT N/P N/P 0.00 0.00
QUERY REQUESTS 0 0.00 0.00 0.00 SUSPENDS - XES GLOBAL CONT N/P N/P 0.00 0.00
CHANGE REQUESTS 2873 119.72 10.84 9.98 SUSPENDS - FALSE CONT. N/P N/P 0.00 0.00
OTHER REQUESTS 0 0.00 0.00 0.00 INCOMPATIBLE RETAINED LOCK N/P N/P 0.00 0.00
LOCK ESCALATION (SHARED) 0 0.00 0.00 0.00 NOTIFY MESSAGES SENT N/P N/P 0.00 0.00
LOCK ESCALATION (EXCL) 0 0.00 0.00 0.00 NOTIFY MESSAGES RECEIVED N/P N/P 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 N/P 0.00 0.00
DRAIN REQUESTS FAILED 0 0.00 0.00 0.00
CLAIM REQUESTS 17176 715.71 64.82 59.64 PSET/PART P-LOCK NEG. N/P N/P 0.00 0.00
CLAIM REQUESTS FAILED 0 0.00 0.00 0.00 PAGE P-LOCK NEGOTIATION N/P N/P 0.00 0.00
OTHER P-LOCK NEGOTIATION N/P N/P 0.00 0.00
P-LOCK CHANGE DURING NEG. N/P N/P 0.00 0.00
REJECTIONS HEURSTIC ALG-XES N/P
GLOBAL CONTENTION RATE(%) N/P
FALSE CONTENTION RATE(%) N/P
XES RATE(%) 0
1 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 46
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
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 N/P 0.00 0.00
CURRENT ACTIVE DBATS 0 0.00 0.00 0.00 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 0.00 0.00 0.00 GROUPS INTFNDED - 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 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 47
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
TCB TIME SRB TIME TOTAL TIME ZIIP TIME
CPU TIMES H:MM:SS.THTTH H:MM.SS.THTTH H:MM.SS.THTTH H:MM.SS.THTTH
------------------------ ------------- ------------- ------------- -------------
SYSTEM SRVCS ADDR SPC 00:00.58180 00:00.27823 00:00.86004 00:00.00000
DATABASE SRVCS ADDR SPC 00:00.12384 00:32.56738 00:32.69123 00:13.56969
IRLM 00:00.00007 00:00.24173 00:00.24180 00:00.00000
DDF ADDRESS SPACE 00:00.18279 00:00.03185 00:00.21464 00:00.00000
TOTAL 00:00.88851 00:33.11919 00:34.00770
PREEMPTABLE SRB TIMER VALUE, NOT INCLUDING CPU ON AN IBM ZIIP (DB2 V7 ABOVE) 15:39:24
PREEMPTABLE SRB TIMER VALUE CONSUMED ON AN IBM ZIIP (DB2 V8 ABOVE) 15:33:47
DB2 APPL.PRGR.INTERFACE QUANTITIY /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 LOGREADS PERFORMED 0 0.00 0.00 0.00
COMMAND REQUESTS 5 0.21 0.02 0.02 LOG RECORDS RETURNED 0 0.00 0.00 0.00
READA REQUESTS 1399 58.30 5.28 4.86 DATA ROWS RETURNED 0 0.00 0.00 0.00
READS REQUESTS 125 5.21 0.47 0.43 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 1529 63.71 5.77 5.31
IFC DEST WRITTEN NOT WRTN BUF OVER NOT ACCP WRT FAIL
-------- -------- -------- -------- -------- --------
SMF 838 0 N/P 0 0
GTF 0 0 0 0 0
OP1 421 0 0 0 0
OP2 580 0 0 0 0
OP3 580 0 0 0 0
OP4 55 0 0 0 0
OP5 52 0 0 0 0
OP6 0 2603750 0 37113 0
OP7 0 2603750 0 36854 0
OP8 0 0 0 0 0
RES 0 0 0 0 0
TOTAL 2526 5207500 0 73967 0
IFC RECORD COUNT WRITTEN NOT WRTN LATCH CNT /SECOND /SECOND /SECOND /SECOND MISCELLANEOUS
---------------- -------- -------- --------- ------- ------- ------- ------- ----------------------------------------
SYSTEM RELATED 194 53 LC01-LC04 0.00 0.00 0.00 0.00 LOG RBA ADDRESS: 00000199C8BC3A84
DATABASE RELATED 194 53 LC05-LC08 0.00 0.00 0.00 0.00 STATS INVOKE RSN: ACTIVATED BY TIMER
ACCOUNTING 984 528 LC09-LC12 0.00 0.00 0.00 0.00 BYPASSED COLUMNS: 0
START TRACE 5 0 LC13-LC16 0.00 7.50 0.00 0.00 MAX SQL CASCAD LVL: N/P
STOP TRACE 4 0 LC17-LC20 0.00 0.00 0.00 0.00 MAX STOR LOB VALUES: N/P
SYSTEM PARMS 24 48 LC21-LC24 0.00 0.00 0.15 0.09
SYS PARMS-BPOOL 44 48 LC25-LC28 0.00 0.00 0.00 0.00
AUDIT 0 0 LC29-LC32 0.00 0.00 0.00 0.00
TOTAL 1449 730
1 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 48
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
OPTIMIZATION QUANTITY /MINUTE /THREAD /COMMIT MISCELLANEOUS
------------------------ -------- ------- ------- ------- ----------------------------------------------
PREPARE REQUESTS 2598 108.26 9.80 9.02 LOG RBA ADDRESS: 00000199C8BC3A84
FULL PREPARES 1 0.04 0.00 0.00 STATS INVOKE RSN: ACTIVATED BY TIMER
HALF PREPARES 2596 108.17 9.80 9.01 BYPASSED COLUMNS: 0
IMPLICIT_PREPARES 0 0.00 0.00 0.00
PREPARE AVOIDED 0 0.00 0.00 0.00
STMT INVALID (MAXKEEPD) 0 0.00 0.00 0.00
STMT INVALID (DDL) 0 0.00 0.00 0.00
NUMBER OF REOPTIMIZATION N/P 0.00 0.00 0.00
DB2 PARSED DY-ST CON STMT N/P 0.00 0.00 0.00
DB2 REPL DY-ST CON STMT N/P 0.00 0.00 0.00
DB2 MATCH DY-ST CON STMT N/P 0.00 0.00 0.00
DB2 DUPLIC DY-ST CON STMT N/P 0.00 0.00 0.00
GLOBAL CACHE HIT RATIO% 99.96
LOCAL CACHE HIT RATIO(%) N/P
TOTAL DBM1 STORAGE BELOW 2GB 618940
STORAGE CUSHION 119328K
REAL STORAGE IN USE 83679
AUXILIARY STORAGE IN USE 0
1 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 49
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
BP0 GENERAL QUANTITY /MINUTE /THREAD /COMMIT BP0 READ OPERATIONS QUANTITY /MINUTE /THREAD /COMMIT
------------------------ -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
AVERAGE ACTIVE BUFFERS 62 N/A N/A N/A GETPAGE REQUESTS 10403550 433508 39258.7 36123.4
UNAVAIL BUF-VPOOL FULL 0 0.00 0.00 0.00 GETPAGE REQUEST-SEQUENTIAL 2598 108.26 9.80 9.02
GETPAGE REQUEST-RANDOM 10400952 433400 39248.9 36114.4
NUMBER OF DATASET OPENS 1 0.04 0.00 0.00
SYNCHRONOUS READS 47399 1975.08 178.86 164.58
BUFFERS ALLOCATED-VPOOL 2000 83.34 7.55 6.94 SYNCHRON READS-SEQUENTIAL 2596 108.17 9.80 9.01
BUFFERS ALLOCATED-HPOOL N/P N/P N/P N/P SYNCHRON READS-RANDOM N/A N/A N/A N/A
HPOOL BUFFERS BACKED N/P N/P N/P N/P
GETPAGE PER SYNCH READS 232.15
DFHSM MIGRATED DATASETS 0 0.00 0.00 0.00
DFHSM RECALL TIMEOUTS 0 0.00 0.00 0.00 SEQUENT'L PREFETCH REQUEST 5192 216.35 19.59 18.03
SEQUENTIAL PREFETCH READS 2596 108.17 9.80 9.01
HPOOL EXPAND/CONTRACT N/P N/P 0.00 0.00 PAGES READ VIA SEQ PREF 23364 973.56 88.17 81.13
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 207649 8652.58 783.58 721.00
CONCUR PREF I/O - HWM 0 0.00 0.00 0.00 LIST PREFETCH READS 206699 8612.99 780.00 717.70
PREF I/O STREAM REDUCED 0 0.00 0.00 0.00 PAGES READ VIA LIST PREF 5130767 213795 19361.4 17815.2
PARALLEL QUERY REQUESTS 0 0.00 0.00 0.00 L PRF PAGE READ/L PRF READ 24.82
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 363327 15139.6 1371.05 1261.55
PREF QUANT REDUCED 1/4 0 0.00 0.00 0.00 DYNAMIC PREFETCH READS 311423 12976.8 1175.18 1081.33
PAGES READ VIA DYN PREFTCH 7637894 318265 28822.2 26520.5
D PRF PAGE READ/D PRF READ 24.53
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 N/P 0.00 0.00
ASYNC HPOOL READ N/P N/P 0.00 0.00
HPOOL READ FAILED N/P N/P 0.00 0.00
ASYN DA MOVR HPOOL READ-S N/P N/P 0.00 0.00
ASYN DA MOVR HPOOL READ-F N/P N/P 0.00 0.00
BPOOL HIT RATIO (%) 99.52
HPOOL HIT RATIO (%) 0.00
HPOOL R/W RATIO (%) N/P
1 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 50
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
BP0 WRITE OPERATIONS QUANTITY /MINUTE /THREAD /COMMIT BP0 SORT/MERGE QUANTITY /MINUTE /THREAD /COMMIT
------------------------ -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
BUFFER UPDATES 203 8.46 0.77 0.70 MAX WORKFILES CONCURR USED 0 0.00 0.00 0.00
PAGES WRITTEN 67 2.79 0.25 0.23 MERGE PASSES REQUESTED 0 0.00 0.00 0.00
BUFF UPDATE/PAGE WRITTEN 3.03 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 9 0.38 0.03 0.03 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 7.44 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 # TIMES PGS UNLCK CASTOUT 0 0.00 0.00 0.00
DM CRITICAL THRESHOLD 0 0.00 0.00 0.00 # TIMES I/O ON CASTSOUT 0 0.00 0.00 0.00
WRITE ENGINE NOT AVAIL N/P N/P 0.00 0.00
PAGE INS REQ FOR WRITE 0 0.00 0.00 0.00
SYNC HPOOL WRITE N/P N/P 0.00 0.00
ASYNC HPOOL WRITE N/P N/P 0.00 0.00
HPOOL WRITE FAILED N/P N/P 0.00 0.00
ASYN DA MVR HPOOL WRIT-S N/P N/P 0.00 0.00
ASYN DA MVR HPOOL WRIT-F N/P N/P 0.00 0.00
1 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 51
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
BP1 GENERAL QUANTITY /MINUTE /THREAD /COMMIT BP1 READ OPERATIONS QUANTITY /MINUTE /THREAD /COMMIT
------------------------ -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
AVERAGE ACTIVE BUFFERS 6 N/A N/A N/A GETPAGE REQUESTS 42499 1770.90 160.37 147.57
UNAVAIL BUF-VPOOL FULL 0 0.00 0.00 0.00 GETPAGE REQUEST-SEQUENTIAL 12975 540.66 48.96 45.05
GETPAGE REQUEST-RANDOM 29524 1230.24 111.41 102.51
NUMBER OF DATASET OPENS 0 0.00 0.00 0.00
SYNCHRONOUS READS 0 0.00 0.00 0.00
BUFFERS ALLOCATED-VPOOL 6656 277.35 25.12 23.11 SYNCHRON READS-SEQUENTIAL 0 0.00 0.00 0.00
BUFFERS ALLOCATED-HPOOL N/P N/P N/P N/P SYNCHRON READS-RANDOM N/A N/A N/A N/A
HPOOL BUFFERS BACKED N/P N/P N/P N/P
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 N/P 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 1402 58.42 5.29 4.87
SYNC HPOOL READ N/P N/P 0.00 0.00
ASYNC HPOOL READ N/P N/P 0.00 0.00
HPOOL READ FAILED N/P N/P 0.00 0.00
ASYN DA MOVR HPOOL READ-S N/P N/P 0.00 0.00
ASYN DA MOVR HPOOL READ-F N/P N/P 0.00 0.00
BPOOL HIT RATIO (%) 100.00
HPOOL HIT RATIO (%) 0.00
HPOOL R/W RATIO (%) N/P
1 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 52
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
BP1 WRITE OPERATIONS QUANTITY /MINUTE /THREAD /COMMIT BP1 SORT/MERGE QUANTITY /MINUTE /THREAD /COMMIT
------------------------ -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
BUFFER UPDATES 36331 1513.89 137.10 126.15 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 # TIMES PGS UNLCK CASTOUT 0 0.00 0.00 0.00
DM CRITICAL THRESHOLD 0 0.00 0.00 0.00 # TIMES I/O ON CASTSOUT 0 0.00 0.00 0.00
WRITE ENGINE NOT AVAIL N/P N/P 0.00 0.00
PAGE INS REQ FOR WRITE 0 0.00 0.00 0.00
SYNC HPOOL WRITE N/P N/P 0.00 0.00
ASYNC HPOOL WRITE N/P N/P 0.00 0.00
HPOOL WRITE FAILED N/P N/P 0.00 0.00
ASYN DA MVR HPOOL WRIT-S N/P N/P 0.00 0.00
ASYN DA MVR HPOOL WRIT-F N/P N/P 0.00 0.00
1 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 53
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
BP8K0 GENERAL QUANTITY /MINUTE /THREAD /COMMIT BP8K0 READ OPERATIONS QUANTITY /MINUTE /THREAD /COMMIT
------------------------ -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
AVERAGE ACTIVE BUFFERS 0 N/A N/A N/A GETPAGE REQUESTS 97 4.04 0.37 0.34
UNAVAIL BUF-VPOOL FULL 0 0.00 0.00 0.00 GETPAGE REQUEST-SEQUENTIAL 0 0.00 0.00 0.00
GETPAGE REQUEST-RANDOM 97 4.04 0.37 0.34
NUMBER OF DATASET OPENS 0 0.00 0.00 0.00
SYNCHRONOUS READS 0 0.00 0.00 0.00
BUFFERS ALLOCATED-VPOOL 128 5.33 0.48 0.44 SYNCHRON READS-SEQUENTIAL 0 0.00 0.00 0.00
BUFFERS ALLOCATED-HPOOL N/P N/P N/P N/P SYNCHRON READS-RANDOM N/A N/A N/A N/A
HPOOL BUFFERS BACKED N/P N/P N/P N/P
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 N/P 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 10 0.42 0.04 0.03
SYNC HPOOL READ N/P N/P 0.00 0.00
ASYNC HPOOL READ N/P N/P 0.00 0.00
HPOOL READ FAILED N/P N/P 0.00 0.00
ASYN DA MOVR HPOOL READ-S N/P N/P 0.00 0.00
ASYN DA MOVR HPOOL READ-F N/P N/P 0.00 0.00
BPOOL HIT RATIO (%) 100.00
HPOOL HIT RATIO (%) 0.00
HPOOL R/W RATIO (%) N/P
1 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 54
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
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 # TIMES PGS UNLCK CASTOUT 0 0.00 0.00 0.00
DM CRITICAL THRESHOLD 0 0.00 0.00 0.00 # TIMES I/O ON CASTSOUT 0 0.00 0.00 0.00
WRITE ENGINE NOT AVAIL N/P N/P 0.00 0.00
PAGE INS REQ FOR WRITE 0 0.00 0.00 0.00
SYNC HPOOL WRITE N/P N/P 0.00 0.00
ASYNC HPOOL WRITE N/P N/P 0.00 0.00
HPOOL WRITE FAILED N/P N/P 0.00 0.00
ASYN DA MVR HPOOL WRIT-S N/P N/P 0.00 0.00
ASYN DA MVR HPOOL WRIT-F N/P N/P 0.00 0.00
1 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 55
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
BP16K0 GENERAL QUANTITY /MINUTE /THREAD /COMMIT BP16K0 READ OPERATIONS QUANTITY /MINUTE /THREAD /COMMIT
------------------------ -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
AVERAGE ACTIVE BUFFERS 0 N/A N/A N/A GETPAGE REQUESTS 2 0.08 0.01 0.01
UNAVAIL BUF-VPOOL FULL 0 0.00 0.00 0.00 GETPAGE REQUEST-SEQUENTIAL 0 0.00 0.00 0.00
GETPAGE REQUEST-RANDOM 2 0.08 0.01 0.01
NUMBER OF DATASET OPENS 0 0.00 0.00 0.00
SYNCHRONOUS READS 1 0.04 0.00 0.00
BUFFERS ALLOCATED-VPOOL 64 2.67 0.24 0.22 SYNCHRON READS-SEQUENTIAL 0 0.00 0.00 0.00
BUFFERS ALLOCATED-HPOOL N/P N/P N/P N/P SYNCHRON READS-RANDOM N/A N/A N/A N/A
HPOOL BUFFERS BACKED N/P N/P N/P N/P
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 N/P 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 7 0.29 0.03 0.02
SYNC HPOOL READ N/P N/P 0.00 0.00
ASYNC HPOOL READ N/P N/P 0.00 0.00
HPOOL READ FAILED N/P N/P 0.00 0.00
ASYN DA MOVR HPOOL READ-S N/P N/P 0.00 0.00
ASYN DA MOVR HPOOL READ-F N/P N/P 0.00 0.00
BPOOL HIT RATIO (%) 50.00
HPOOL HIT RATIO (%) 0.00
HPOOL R/W RATIO (%) N/P
1 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 56
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
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 # TIMES PGS UNLCK CASTOUT 0 0.00 0.00 0.00
DM CRITICAL THRESHOLD 0 0.00 0.00 0.00 # TIMES I/O ON CASTSOUT 0 0.00 0.00 0.00
WRITE ENGINE NOT AVAIL N/P N/P 0.00 0.00
PAGE INS REQ FOR WRITE 0 0.00 0.00 0.00
SYNC HPOOL WRITE N/P N/P 0.00 0.00
ASYNC HPOOL WRITE N/P N/P 0.00 0.00
HPOOL WRITE FAILED N/P N/P 0.00 0.00
ASYN DA MVR HPOOL WRIT-S N/P N/P 0.00 0.00
ASYN DA MVR HPOOL WRIT-F N/P N/P 0.00 0.00
1 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 57
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
BP32K GENERAL QUANTITY /MINUTE /THREAD /COMMIT BP32K READ OPERATIONS QUANTITY /MINUTE /THREAD /COMMIT
------------------------ -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
AVERAGE ACTIVE BUFFERS 0 N/A N/A N/A GETPAGE REQUESTS 0 0.00 0.00 0.00
UNAVAIL BUF-VPOOL FULL 0 0.00 0.00 0.00 GETPAGE REQUEST-SEQUENTIAL 0 0.00 0.00 0.00
GETPAGE REQUEST-RANDOM 0 0.00 0.00 0.00
NUMBER OF DATASET OPENS 0 0.00 0.00 0.00
SYNCHRONOUS READS 0 0.00 0.00 0.00
BUFFERS ALLOCATED-VPOOL 32 1.33 0.12 0.11 SYNCHRON READS-SEQUENTIAL 0 0.00 0.00 0.00
BUFFERS ALLOCATED-HPOOL N/P N/P N/P N/P SYNCHRON READS-RANDOM N/A N/A N/A N/A
HPOOL BUFFERS BACKED N/P N/P N/P N/P
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 N/P 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 4 0.17 0.02 0.01
SYNC HPOOL READ N/P N/P 0.00 0.00
ASYNC HPOOL READ N/P N/P 0.00 0.00
HPOOL READ FAILED N/P N/P 0.00 0.00
ASYN DA MOVR HPOOL READ-S N/P N/P 0.00 0.00
ASYN DA MOVR HPOOL READ-F N/P N/P 0.00 0.00
BPOOL HIT RATIO (%) N/P
HPOOL HIT RATIO (%) N/P
HPOOL R/W RATIO (%) N/P
1 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 58
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
BP32K WRITE OPERATIONS QUANTITY /MINUTE /THREAD /COMMIT BP32K 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 # TIMES PGS UNLCK CASTOUT 0 0.00 0.00 0.00
DM CRITICAL THRESHOLD 0 0.00 0.00 0.00 # TIMES I/O ON CASTSOUT 0 0.00 0.00 0.00
WRITE ENGINE NOT AVAIL N/P N/P 0.00 0.00
PAGE INS REQ FOR WRITE 0 0.00 0.00 0.00
SYNC HPOOL WRITE N/P N/P 0.00 0.00
ASYNC HPOOL WRITE N/P N/P 0.00 0.00
HPOOL WRITE FAILED N/P N/P 0.00 0.00
ASYN DA MVR HPOOL WRIT-S N/P N/P 0.00 0.00
ASYN DA MVR HPOOL WRIT-F N/P N/P 0.00 0.00
1 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 59
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
BP TOT GENERAL QUANTITY /MINUTE /THREAD /COMMIT BP TOT READ OPERATIONS QUANTITY /MINUTE /THREAD /COMMIT
------------------------ -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
AVERAGE ACTIVE BUFFERS 14 N/A N/A N/A GETPAGE REQUESTS 10446148 435283 39419.4 36271.3
UNAVAIL BUF-VPOOL FULL 0 0.00 0.00 0.00 GETPAGE REQUEST-SEQUENTIAL 15573 648.92 58.77 54.07
GETPAGE REQUEST-RANDOM 10430575 434634 39360.7 36217.3
NUMBER OF DATASET OPENS 1 0.04 0.00 0.00
SYNCHRONOUS READS 47400 1975.12 178.87 164.58
BUFFERS ALLOCATED-VPOOL 1776 370.02 33.51 30.83 SYNCHRON READS-SEQUENTIAL 2596 108.17 9.80 9.01
BUFFERS ALLOCATED-HPOOL N/P N/P N/P N/P SYNCHRON READS-RANDOM 44804 1866.95 169.07 155.57
HPOOL BUFFERS BACKED N/P N/P N/P N/P
GETPAGE PER SYNCH READS 232.80
DFHSM MIGRATED DATASETS 0 0.00 0.00 0.00
DFHSM RECALL TIMEOUTS 0 0.00 0.00 0.00 SEQUENT'L PREFETCH REQUEST 5192 216.35 19.59 18.03
SEQUENTIAL PREFETCH READS 2596 108.17 9.80 9.01
HPOOL EXPAND/CONTRACT N/P N/P 0.00 0.00 PAGES READ VIA SEQ PREF 23364 973.56 88.17 81.13
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 207649 8652.58 783.58 721.00
CONCUR PREF I/O - HWM 0 0.00 0.00 0.00 LIST PREFETCH READS 206699 8612.99 780.00 717.70
PREF I/O STREAM REDUCED 0 0.00 0.00 0.00 PAGES READ VIA LIST PREF 5130767 213795 19361.4 17815.2
PARALLEL QUERY REQUESTS 0 0.00 0.00 0.00 L PRF PAGE READ/L PRF READ 24.82
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 363327 15139.6 1371.05 1261.55
PREF QUANT REDUCED 1/4 0 0.00 0.00 0.00 DYNAMIC PREFETCH READS 311423 12976.8 1175.18 1081.33
PAGES READ VIA DYN PREFTCH 7637894 318265 28822.2 26520.5
D PRF PAGE READ/D PRF READ 24.53
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 1423 59.30 5.37 4.94
SYNC HPOOL READ N/P N/P 0.00 0.00
ASYNC HPOOL READ N/P N/P 0.00 0.00
HPOOL READ FAILED N/P N/P 0.00 0.00
ASYN DA MOVR HPOOL READ-S N/P N/P 0.00 0.00
ASYN DA MOVR HPOOL READ-F N/P N/P 0.00 0.00
BPOOL HIT RATIO (%) 99.52
HPOOL HIT RATIO (%) 0.00
HPOOL R/W RATIO (%) N/P
1 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 60
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
BP TOT WRITE OPERATIONS QUANTITY /MINUTE /THREAD /COMMIT BP TOT SORT/MERGE QUANTITY /MINUTE /THREAD /COMMIT
------------------------ -------- ------- ------- ------- -------------------------- -------- ------- ------- -------
BUFFER UPDATES 36534 1522.34 137.86 126.85 MAX WORKFILES CONCURR USED 0 0.00 0.00 0.00
PAGES WRITTEN 67 2.79 0.25 0.23 MERGE PASSES REQUESTED 0 0.00 0.00 0.00
BUFF UPDATE/PAGE WRITTEN 545.28 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 9 0.38 0.03 0.03 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 7.44 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 # TIMES PGS UNLCK CASTOUT 0 0.00 0.00 0.00
DM CRITICAL THRESHOLD 0 0.00 0.00 0.00 # TIMES I/O ON CASTSOUT 0 0.00 0.00 0.00
WRITE ENGINE NOT AVAIL N/P N/P 0.00 0.00
PAGE INS REQ FOR WRITE 0 0.00 0.00 0.00
SYNC HPOOL WRITE N/P N/P 0.00 0.00
ASYNC HPOOL WRITE N/P N/P 0.00 0.00
HPOOL WRITE FAILED N/P N/P 0.00 0.00
ASYN DA MVR HPOOL WRIT-S N/P N/P 0.00 0.00
ASYN DA MVR HPOOL WRIT-F N/P N/P 0.00 0.00
DDF STATISTICS FOR REMOTE LOCATION: DRDA REMOTE LOCS
DESCRIPTION COUNT DESCRIPTION COUNT
---------------------------------------- ---------- --------------------------------------------- ----------
TRANSACTIONS SENT N/P TRANSACTIONS RECEIVED N/P
SINGLE PHASE COMMITS SENT 0 SINGLE PHASE COMMITS RECEIVED 0
SINGLE PHASE ROLLBACKS SENT 0 SINGLE PHASE ROLLBACKS RECEIVED 0
SQL STATEMENTS SENT 0 SQL STATEMENTS RECEIVED 0
ROWS SENT 0 ROWS RECEIVED 0
MESSAGES SENT 3463 MESSAGES RECEIVED 3452
BYTES SENT 141241 BYTES RECEIVED 1324563
BLOCKS SENT 0 BLOCKS RECEIVED 0
CONVERSATIONS SENT 2 CONVERSATIONS RECEIVED 0
CONVERSATIONS QUEUED 0 STATEMENTS BOUND AT SERVER N/P
LIMITED BLOCK FETCH SWITCH N/P MESSAGES IN BUFFER N/P
PREPARE REQUESTS SENT N/P PREPARE REQUESTS RECEIVED N/P
LAST AGENT REQUESTS SENT N/P LAST AGENT REQUESTS RECEIVED N/P
TWO PHASE COMMIT REQUESTS SENT N/P TWO PHASE COMMIT REQUESTS RECEIVED N/P
BACKOUT REQUESTS SENT N/P BACKOUT REQUESTS RECEIVED N/P
FORGET RESPONSES SENT N/P FORGET RESPONSES RECEIVED N/P
REQUEST COMMIT RESPONSES SENT N/P REQUEST COMMIT RESPONSES RECEIVED N/P
BACKOUT RESPONSES SENT N/P BACKOUT RESPONSES RECEIVED N/P
THREADS INDOUBT WITH REMOTE AS COORDINATOR 0 COMMITS WITH REMOTE LOCATION AS COORDINATOR N/P
BACKOUTS DONE WITH REMOTE AS COORDINATOR N/P
1 BSTATDR : DB2 STATISTICS DETAIL REPORT 02/23/15 08:14:38 PAGE 61
GROUP : DB2 STATISTICS DETAIL DB2 SUBSYSTEM: DEFG 10.1
MEMBER: LOCATION: DEFG
BEGIN RECORD: ( 15.054 ) 02/23/15 07:50:00.14 END RECORD: ( 15.054 ) 02/23/15 08:14:00.05
ELAPSED TIME: 0 DAYS 00:24:00 TOTAL THREADS: 265 #DBATS: 0 COMMITS: 288 INCREMENTAL BIND: 48
ACCELERATOR SERVER NAME: IDAAVIPA ACCELERATOR PRODUCT ID: AQT04010
--------------------------------------------------------------------------------------------------------------------------
QUERIES SUCCESSFULLY EXECUTED 0.00 AVG QUEUE LENGTH (LAST 3 HOURS) N/A
QUERIES FAILED TO EXECUTE 1.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 MAX QUEUE WAIT ELAPSED TIME 00:00:00.207246
MAXIMUM EXECUTING QUERIES N/A 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 (%) 1.99
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 ACCELERATOR 0.00 DATA SLICES 22.00
BLOCKS SENT TO ACCELERATOR 0.00 DATA SKEW (%) 0.00
BLOCKS RECEIVED FROM ACCELERATOR 0.00
ROWS SENT TO ACCELERATOR 0.00 PROCESSORS (AVG) 64.00
ROWS RECEIVED FROM ACCELERATOR 0.00
ELAPSED TIME IN ACCELERATOR 00:00:00.000000
TCP/IP SERVICES ELAPSED TIME 00:00:00.012209 CPU TIME SPENT IN ACCELERATOR 00:00:00.000000
TCP/IP SERVICES CPU TIME 00:00:00.001460 WAIT TIME IN ACCELERATOR 00:00:00.000000
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 (%) 3.99
BY ALL DB2 SUBSYSTEMS BY THIS DB2 (DEFG)
SUCCESSFUL QUERIES SENT 0.00 CURRENT QUERIES EXECUTING 0.00
FAILED QUERIES SENT 1.00 MAX QUERIES EXECUTED 3.00
CURRENT QUERIES EXECUTING 0.00 TOTAL QUERY CPU COST 00:00:00.10
MAX QUERIES EXECUTED 3.00 TOTAL MAINT CPU COST 00:00:00.00
TOTAL QUERY CPU COST 00:00:00.100000
TOTAL MAINT CPU COST 00:00:00.000000 CAPTURE AGENT
DISK SPACE (MB) 0.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*