Information
Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Ops Monitor for Db2 13.1 
.
.
I/O summary report by DB2 (BIOSUM)
The I/O summary report by DB2 (BIOSUM) is an overall summary report that aggregates all the selected data into one summarization at the Db2 member level. The report contains a summary section for each of the following data categories:
- Buffer pool
- EDM pool
- Active log
- Archive log
- BSDS
- XI activity
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
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*