The Data Set Statistics section
The data set statistics values are retrieved from IFCID 199.
1 OMEGAMON XE FOR DB2 PE (V5R4M0) - BUFFER POOL ACTIVITY REPORT PAGE: 1-10
ORDER: BPID-QPAGESET
SORTBY: BPID,ASYNCPAGE TOP: 17 LEVEL: SUMMARY
GROUP: N/P LOCATION: OMPDC61 DB2 VERSION: V12
MEMBER: N/P REQUESTED FROM: NOT SPECIFIED TO: NOT SPECIFIED
SUBSYSTEM: DC61 INTERVAL FROM: 04/05/16 13:40:56 TO: 04/05/16 14:47:00
======= Dataset Statistics =======
BPID BP0 BP0 BP0 BP0 BP0
PSTYPE T I T T I
QPAGESET DSNDB01 DSNDB01 DSNDB06 DSNDB06 DSNDB06
SYSSPUXB DSNSPEXA SYSTSTSP SYSTSSFB DSNDCX06
PARTITION 1 1 1 1 1
-------------- ---------- ---------- ---------- ---------- ----------
Synchronous
Request 202 134 62 61 60
Avg delay ms 0.969 0.866 0.763 0.789 2.074
Max delay ms 21.957 13.411 8.566 9.661 35.771
Tot delay sec 0.196 0.116 0.047 0.048 0.124
Asynchronous
Request 4 5 61 48 23
Page 70 132 400 452 27
Avg delay ms 0.050 0.111 0.524 0.445 11.201
Max delay ms 0.376 0.329 39.198 17.518 171.133
Tot delay sec 0.000 0.001 0.032 0.021 0.258
VP current
Avg pages 201 134 15 59 4
Max pages 201 134 15 59 4
VP changed
Avg pages 0 0 1 2 1
Max pages 0 0 1 2 1
GBP-dependent No No No No No
Shadow DS No No No No No
============== ========== ========== ========== ========== ==========
BPID BP32K
PSTYPE T
QPAGESET DSNDB01
SPT01
PARTITION 1
-------------- ----------
Synchronous
Request 78
Avg delay ms 4.413
Max delay ms 33.024
Tot delay sec 0.344
Asynchronous
Request 52
Page 139
Avg delay ms 0.743
Max delay ms 9.071
Tot delay sec 0.039
VP current
Avg pages 132
Max pages 132
VP changed
Avg pages 0
Max pages 0
GBP-dependent No
Shadow DS No
============== ==========
1 OMEGAMON XE FOR DB2 PE (V5R4M0) - BUFFER POOL ACTIVITY REPORT PAGE: 1-11
ORDER: BPID-QPAGESET
SORTBY: BPID,ASYNCPAGE TOP: 17 LEVEL: SUMMARY
GROUP: N/P LOCATION: OMPDC61 DB2 VERSION: V12
MEMBER: N/P REQUESTED FROM: NOT SPECIFIED TO: NOT SPECIFIED
SUBSYSTEM: DC61 INTERVAL FROM: 04/05/16 13:40:56 TO: 04/05/16 14:47:00
======= Dataset Statistics =======
BPID BP8K4
PSTYPE T
QPAGESET EDVADB
EDVATSA
PARTITION 1
-------------- ----------
Synchronous
Request 429
Avg delay ms 0.327
Max delay ms 2.724
Tot delay sec 0.140
Asynchronous
Request 83
Page 948
Avg delay ms 0.068
Max delay ms 0.364
Tot delay sec 0.006
VP current
Avg pages 450
Max pages 450
VP changed
Avg pages 0
Max pages 0
GBP-dependent No
Shadow DS No
============== ==========
BPID BP16K4
PSTYPE T
QPAGESET EDVADB
EDVATSA
PARTITION 2
-------------- ----------
Synchronous
Request 525
Avg delay ms 0.337
Max delay ms 2.227
Tot delay sec 0.177
Asynchronous
Request 136
Page 910
Avg delay ms 0.120
Max delay ms 1.066
Tot delay sec 0.016
VP current
Avg pages 505
Max pages 505
VP changed
Avg pages 45
Max pages 45
GBP-dependent No
Shadow DS No
============== ==========
1 OMEGAMON XE FOR DB2 PE (V5R4M0) - BUFFER POOL ACTIVITY REPORT PAGE: 1-12
ORDER: BPID-QPAGESET
SORTBY: BPID,ASYNCPAGE TOP: 17 LEVEL: SUMMARY
GROUP: N/P LOCATION: OMPDC61 DB2 VERSION: V12
MEMBER: N/P REQUESTED FROM: NOT SPECIFIED TO: NOT SPECIFIED
SUBSYSTEM: DC61 INTERVAL FROM: 04/05/16 13:40:56 TO: 04/05/16 14:47:00
********** TOTAL **********
BPID BP0 BP32K BP8K4 BP16K4
-------------- ---------- ---------- ---------- ----------
Synchronous
Request 519 78 429 525
Avg delay ms 1.024 4.413 0.327 0.337
Max delay ms 35.771 33.024 2.724 2.227
Tot delay sec 0.532 0.344 0.140 0.177
Asynchronous
Request 141 52 83 136
Page 1081 139 948 910
Avg delay ms 2.211 0.743 0.068 0.120
Max delay ms 171.133 9.071 0.364 1.066
Tot delay sec 0.312 0.039 0.006 0.016
VP current
Avg pages 83 132 450 505
Max pages 201 132 450 505
VP changed
Avg pages 1 0 0 45
Max pages 2 0 0 45
GBP-dependent No No No No
Shadow DS No No No No
============== ========== ========== ========== ==========
⋮- Synchronous — Request
- Number of synchronous I/Os in the reported interval for the page set.
- Synchronous — Avg delay ms
- Average synchronous I/O delay for pages in the page set, in milliseconds.
- Synchronous — Max delay ms
- Maximum synchronous I/O delay for pages in the page set, in milliseconds.
- Synchronous — Tot delay sec
- Total accumulated synchronous I/O delay for pages in the page set, in seconds.
- Asynchronous — Request
- Number of asynchronous I/Os for the page set in the reported interval.
- Asynchronous — Page
- Number of page set pages read or written asynchronously in the reported interval.
- Asynchronous — Avg delay ms
- Average asynchronous I/O delay for pages in the page set, in milliseconds.
- Asynchronous — Max delay ms
- Maximum asynchronous I/O delay for pages in the page set, in milliseconds.
- Asynchronous — Tot delay ms
- Total accumulated asynchronous I/O delay for pages in the page set, in seconds.
- VP current
- Number of page set pages in the virtual buffer pool.
- VP current— Avg pages
- Average number of page set pages in the virtual buffer pool per IFCID 199 interval.
- VP current— Max pages
- Maximum number of page set pages in the virtual buffer pool per IFCID 199 interval.
- VP changed
- Number of changed page set pages in the virtual buffer pool.
- VP changed— Avg pages
- Average number of changed page set pages in the virtual buffer pool per IFCID 199 interval.
- VP changed — Max pages
- Maximum number of changed page set pages in the virtual buffer pool per IFCID 199 interval.