I/O summary report by DB2 (BIOSUM)
The report is based on Db2 performance trace IFCIDs 6-10, 29-30, 34-41, 114-116, 119-120, and 255. The following figure shows a sample of the BIOSUM report.
1 BIOSUM : IO ACTIVITY SUMMARY 11/04/14 08:44:06 PAGE 1
LOCATION: DEEF DATA FROM: 05/28/2013 14:03:07
D/S GROUP: MBR: IO ACTIVITY SUMMARY TO: 08/22/2013 11:32:40
SUBSYSTEM: DEEF VER: 10.1
. AVERAGE CT/PT/DBD LOADS(NOT AVERAGE AVG LEN
BUFFER POOL TOTALS ELAPSED EDM POOL REFERENCES IN POOL) ELAPSED (BYTES)
---------------------------- -------- --------- --------------------------- ---------- --------- --------- ---------
TOTAL I/O REQUESTS 178489 00.000621 CURSOR TABLE - HEADER N/P 0 N/P N/P
CURSOR TABLE - DIRECTORY N/P 0 N/P N/P
TOTAL READ I/O REQUESTS 172661 00.000596 CURSOR TABLE - RDS SECTION N/P 0 N/P N/P
NON-PREFETCH (SYNC) READS 56219 -- TOTAL PLANS ----- 0 0 N/P N/P
PREFETCH READS (ASYNC) 116442
WITHOUT I/O (BP HITS) 0 PACKAGE TABLE - HEADER N/P 0 N/P N/P
WITH I/O 116443 PACKAGE TABLE - DIRECTORY N/P 0 N/P N/P
PAGES READ 2075306 PACKAGE TABLE - RDS SECTION N/P 0 N/P N/P
PAGES READ / IO 17.82 -- TOTAL PACKAGES -- 0 0 N/P N/P
TOTAL WRITE REQUESTS 5828 00.001334 DATABASE DESCRIPTORS N/P 0 N/P N/P
SYNCHRONOUS WRITES 52 00.000487
COUPLING FACILITY CASTOUTS 0 N/P
PAGES WRITTEN PER WRITE IO 1.00
ASYNCHRONOUS WRITES 5776 00.001342
COUPLING FACILITY CASTOUTS 0 N/P
PAGES WRITTEN PER WRITE IO 27.28
AVERAGE AVERAGE AVERAGE
ACTIVE LOG TOTALS ELAPSED ARCHIVE LOG TOTALS ELAPSED BOOTSTRAP DATASET TOTALS ELAPSED
--------------------- -------- --------- ---------------------- -------- --------- -------------------- -------- ---------
TOTAL WAITS 4343 00.000971 TOTAL WAITS 950 00.000644
READ REQUESTS 139 00.003126 READ REQUESTS 0 N/P READ REQUESTS 888 00.000651
DASD READS 0 N/P
TAPE READS 0 N/P
WRITE REQUESTS 4204 00.000900 OFFLOAD REQUESTS 1 01.677667 WRITE REQUESTS 62 00.000547
CONTIG. CI/WRITE 6.79 BLOCKS/OFFLOAD 1439.00
OTHER WAITS 0 N/P OTHER WAITS 6 00.220538 CROSS-INVALIDATION ACTIVITY TOTALS
ALLOCATE 0 N/P ALLOCATE 1 00.286361 ----------------------------- --------
DEALLOCATE 0 N/P DEALLOCATE 1 00.207676 SYNCHRONOUS READS 0
OPEN 0 N/P OPEN 2 00.271016 REFRESHED FROM GRP BPOOL 0
CLOSE 0 N/P CLOSE 2 00.143581 REFRESHED FROM DASD 0
HSM RECALL 0 N/P
CATALOG LOCATE 0 N/P SEQUENTIAL PREFETCHES 0
MULTI-DATASET TAPE 0 N/P REFRESHED FROM GRP BPOOL 0
TAPE VOL POSITIONING 0 N/P REFRESHED FROM DASD 0
WTOR ISSUED 0 N/P
DATA SET UNAVAILABLE 0 N/P
PHYSICAL UNIT UNAV. 0 N/P
READER SERVICE UNAV. 0 N/P
1 BIOSUM : IO ACTIVITY SUMMARY 11/04/14 08:44:06 PAGE 2
LOCATION: DGR DATA FROM: 05/28/2013 14:03:07
D/S GROUP: DSNDGR MBR: DGR1 IO ACTIVITY SUMMARY TO: 08/22/2013 11:32:40
SUBSYSTEM: DGR1 VER: 10.1
. AVERAGE CT/PT/DBD LOADS(NOT AVERAGE AVG LEN
BUFFER POOL TOTALS ELAPSED EDM POOL REFERENCES IN POOL) ELAPSED (BYTES)
---------------------------- -------- --------- --------------------------- ---------- --------- --------- ---------
TOTAL I/O REQUESTS 0 N/P CURSOR TABLE - HEADER 1 1 00.000034 0.00
CURSOR TABLE - DIRECTORY 1 1 00.000033 0.00
TOTAL READ I/O REQUESTS 0 N/P CURSOR TABLE - RDS SECTION N/P 0 N/P N/P
NON-PREFETCH (SYNC) READS 0 -- TOTAL PLANS ----- 2 2 00.000033 0.00
PREFETCH READS (ASYNC) 0
WITHOUT I/O (BP HITS) 0 PACKAGE TABLE - HEADER 17 17 00.000053 3787.76
WITH I/O 0 PACKAGE TABLE - DIRECTORY 17 17 00.000027 536.47
PAGES READ 0 PACKAGE TABLE - RDS SECTION 19 19 00.000075 7394.11
PAGES READ / IO N/P -- TOTAL PACKAGES -- 53 53 00.000053 4037.74
TOTAL WRITE REQUESTS 0 N/P DATABASE DESCRIPTORS 2 2 00.003608 16142.00
SYNCHRONOUS WRITES 0 N/P
COUPLING FACILITY CASTOUTS 0 N/P
PAGES WRITTEN PER WRITE IO N/P
ASYNCHRONOUS WRITES 0 N/P
COUPLING FACILITY CASTOUTS 0 N/P
PAGES WRITTEN PER WRITE IO N/P
AVERAGE AVERAGE AVERAGE
ACTIVE LOG TOTALS ELAPSED ARCHIVE LOG TOTALS ELAPSED BOOTSTRAP DATASET TOTALS ELAPSED
--------------------- -------- --------- ---------------------- -------- --------- -------------------- -------- ---------
TOTAL WAITS 0 N/P TOTAL WAITS 0 N/P
READ REQUESTS 0 N/P READ REQUESTS 0 N/P READ REQUESTS 0 N/P
DASD READS 0 N/P
TAPE READS 0 N/P
WRITE REQUESTS 0 N/P OFFLOAD REQUESTS 0 N/P WRITE REQUESTS 0 N/P
CONTIG. CI/WRITE N/P BLOCKS/OFFLOAD N/P
OTHER WAITS 0 N/P OTHER WAITS 0 N/P CROSS-INVALIDATION ACTIVITY TOTALS
ALLOCATE 0 N/P ALLOCATE 0 N/P ----------------------------- --------
DEALLOCATE 0 N/P DEALLOCATE 0 N/P SYNCHRONOUS READS 0
OPEN 0 N/P OPEN 0 N/P REFRESHED FROM GRP BPOOL 0
CLOSE 0 N/P CLOSE 0 N/P REFRESHED FROM DASD 0
HSM RECALL 0 N/P
CATALOG LOCATE 0 N/P SEQUENTIAL PREFETCHES 0
MULTI-DATASET TAPE 0 N/P REFRESHED FROM GRP BPOOL 0
TAPE VOL POSITIONING 0 N/P REFRESHED FROM DASD 0
WTOR ISSUED 0 N/P
DATA SET UNAVAILABLE 0 N/P
PHYSICAL UNIT UNAV. 0 N/P
READER SERVICE UNAV. 0 N/P
LOCATION: DEEF DATA FROM: 05/28/2013 14:03:07
D/S GROUP: MBR: IO ACTIVITY SUMMARY TO: 08/22/2013 11:32:40
SUBSYSTEM: DEEF VER: 10.1
. AVERAGE CT/PT/DBD LOADS(NOT AVERAGE AVG LEN
BUFFER POOL TOTALS ELAPSED EDM POOL REFERENCES IN POOL) ELAPSED (BYTES)
---------------------------- -------- --------- --------------------------- ---------- --------- --------- ---------
TOTAL I/O REQUESTS 178489 00.000621 CURSOR TABLE - HEADER N/P 0 N/P N/P
CURSOR TABLE - DIRECTORY N/P 0 N/P N/P
TOTAL READ I/O REQUESTS 172661 00.000596 CURSOR TABLE - RDS SECTION N/P 0 N/P N/P
NON-PREFETCH (SYNC) READS 56219 -- TOTAL PLANS ----- 0 0 N/P N/P
PREFETCH READS (ASYNC) 116442
WITHOUT I/O (BP HITS) 0 PACKAGE TABLE - HEADER N/P 0 N/P N/P
WITH I/O 116443 PACKAGE TABLE - DIRECTORY N/P 0 N/P N/P
PAGES READ 2075306 PACKAGE TABLE - RDS SECTION N/P 0 N/P N/P
PAGES READ / IO 17.82 -- TOTAL PACKAGES -- 0 0 N/P N/P
TOTAL WRITE REQUESTS 5828 00.001334 DATABASE DESCRIPTORS N/P 0 N/P N/P
SYNCHRONOUS WRITES 52 00.000487
COUPLING FACILITY CASTOUTS 0 N/P
PAGES WRITTEN PER WRITE IO 1.00
ASYNCHRONOUS WRITES 5776 00.001342
COUPLING FACILITY CASTOUTS 0 N/P
PAGES WRITTEN PER WRITE IO 27.28
AVERAGE AVERAGE AVERAGE
ACTIVE LOG TOTALS ELAPSED ARCHIVE LOG TOTALS ELAPSED BOOTSTRAP DATASET TOTALS ELAPSED
--------------------- -------- --------- ---------------------- -------- --------- -------------------- -------- ---------
TOTAL WAITS 4343 00.000971 TOTAL WAITS 950 00.000644
READ REQUESTS 139 00.003126 READ REQUESTS 0 N/P READ REQUESTS 888 00.000651
DASD READS 0 N/P
TAPE READS 0 N/P
WRITE REQUESTS 4204 00.000900 OFFLOAD REQUESTS 1 01.677667 WRITE REQUESTS 62 00.000547
CONTIG. CI/WRITE 6.79 BLOCKS/OFFLOAD 1439.00
OTHER WAITS 0 N/P OTHER WAITS 6 00.220538 CROSS-INVALIDATION ACTIVITY TOTALS
ALLOCATE 0 N/P ALLOCATE 1 00.286361 ----------------------------- --------
DEALLOCATE 0 N/P DEALLOCATE 1 00.207676 SYNCHRONOUS READS 0
OPEN 0 N/P OPEN 2 00.271016 REFRESHED FROM GRP BPOOL 0
CLOSE 0 N/P CLOSE 2 00.143581 REFRESHED FROM DASD 0
HSM RECALL 0 N/P
CATALOG LOCATE 0 N/P SEQUENTIAL PREFETCHES 0
MULTI-DATASET TAPE 0 N/P REFRESHED FROM GRP BPOOL 0
TAPE VOL POSITIONING 0 N/P REFRESHED FROM DASD 0
WTOR ISSUED 0 N/P
DATA SET UNAVAILABLE 0 N/P
PHYSICAL UNIT UNAV. 0 N/P
READER SERVICE UNAV. 0 N/P
1 BIOSUM : IO ACTIVITY SUMMARY 11/04/14 08:44:06 PAGE 2
LOCATION: DGR DATA FROM: 05/28/2013 14:03:07
D/S GROUP: DSNDGR MBR: DGR1 IO ACTIVITY SUMMARY TO: 08/22/2013 11:32:40
SUBSYSTEM: DGR1 VER: 10.1
. AVERAGE CT/PT/DBD LOADS(NOT AVERAGE AVG LEN
BUFFER POOL TOTALS ELAPSED EDM POOL REFERENCES IN POOL) ELAPSED (BYTES)
---------------------------- -------- --------- --------------------------- ---------- --------- --------- ---------
TOTAL I/O REQUESTS 0 N/P CURSOR TABLE - HEADER 1 1 00.000034 0.00
CURSOR TABLE - DIRECTORY 1 1 00.000033 0.00
TOTAL READ I/O REQUESTS 0 N/P CURSOR TABLE - RDS SECTION N/P 0 N/P N/P
NON-PREFETCH (SYNC) READS 0 -- TOTAL PLANS ----- 2 2 00.000033 0.00
PREFETCH READS (ASYNC) 0
WITHOUT I/O (BP HITS) 0 PACKAGE TABLE - HEADER 17 17 00.000053 3787.76
WITH I/O 0 PACKAGE TABLE - DIRECTORY 17 17 00.000027 536.47
PAGES READ 0 PACKAGE TABLE - RDS SECTION 19 19 00.000075 7394.11
PAGES READ / IO N/P -- TOTAL PACKAGES -- 53 53 00.000053 4037.74
TOTAL WRITE REQUESTS 0 N/P DATABASE DESCRIPTORS 2 2 00.003608 16142.00
SYNCHRONOUS WRITES 0 N/P
COUPLING FACILITY CASTOUTS 0 N/P
PAGES WRITTEN PER WRITE IO N/P
ASYNCHRONOUS WRITES 0 N/P
COUPLING FACILITY CASTOUTS 0 N/P
PAGES WRITTEN PER WRITE IO N/P
AVERAGE AVERAGE AVERAGE
ACTIVE LOG TOTALS ELAPSED ARCHIVE LOG TOTALS ELAPSED BOOTSTRAP DATASET TOTALS ELAPSED
--------------------- -------- --------- ---------------------- -------- --------- -------------------- -------- ---------
TOTAL WAITS 0 N/P TOTAL WAITS 0 N/P
READ REQUESTS 0 N/P READ REQUESTS 0 N/P READ REQUESTS 0 N/P
DASD READS 0 N/P
TAPE READS 0 N/P
WRITE REQUESTS 0 N/P OFFLOAD REQUESTS 0 N/P WRITE REQUESTS 0 N/P
CONTIG. CI/WRITE N/P BLOCKS/OFFLOAD N/P
OTHER WAITS 0 N/P OTHER WAITS 0 N/P CROSS-INVALIDATION ACTIVITY TOTALS
ALLOCATE 0 N/P ALLOCATE 0 N/P ----------------------------- --------
DEALLOCATE 0 N/P DEALLOCATE 0 N/P SYNCHRONOUS READS 0
OPEN 0 N/P OPEN 0 N/P REFRESHED FROM GRP BPOOL 0
CLOSE 0 N/P CLOSE 0 N/P REFRESHED FROM DASD 0
HSM RECALL 0 N/P
CATALOG LOCATE 0 N/P SEQUENTIAL PREFETCHES 0
MULTI-DATASET TAPE 0 N/P REFRESHED FROM GRP BPOOL 0
TAPE VOL POSITIONING 0 N/P REFRESHED FROM DASD 0
WTOR ISSUED 0 N/P
DATA SET UNAVAILABLE 0 N/P
PHYSICAL UNIT UNAV. 0 N/P
READER SERVICE UNAV. 0 N/P
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*