Data set statistics report
This topic shows detailed information about Statistics - Data Set Statistics
.
Within IFCID 199, Db2® externalizes data set performance counters for open data sets that had high I/O activities (at least 1 I/O per second) in the last Statistics interval (determined by system parameter STATIME). The metrics are reported with respect to a page set to which a data set belongs and which makes up a Db2 table space or index space. The average values are calculated with respect to the I/O start and end times shown in the report.
You have to use the DSETSTAT report option for creating the data set Statistics report block. The report shows data set metrics from the perspective of buffer pools which are assigned to page sets and related data sets. The DSETSTAT report option is ignored in the Statistics REPORT or SAVE subcommand if an INTERVAL(X) option with X>0 has been specified.
Statistics - Data Set Statistics
---- HIGHLIGHTS ----------------------------------------------------------------------------------------------------
INTERVAL START : 02/09/19 08:51:48.20 SAMPLING START: 02/09/19 08:51:48.20 TOTAL THREADS : 16.00
INTERVAL END : 02/09/19 09:35:00.08 SAMPLING END : 02/09/19 09:35:00.08 TOTAL COMMITS : 1.00
INTERVAL ELAPSED: 43:11.878763 OUTAGE ELAPSED: 0.000000 DATA SHARING MEMBER: N/A
BPOOL DATABASE TYPE I/O START TIME SYNCH I/O AVG SYN I/O AVG DELAY ASYN I/O AVG DELAY CURRENT PAGES (VP)
SPACENAM GBP I/O END TIME ASYNC I/O AVG SYN I/O MAX DELAY ASYN I/O MAX DELAY CHANGED PAGES (VP)
PART SHDW ASY I/O PGS AVG ZHL I/O AVG DELAY NUMBER OF GETPAGES
ZHL I/O AVG ZHL I/O MAX DELAY
------ -------- ---- -------------------- --------------- ----------------- ------------------ ------------------
BP0 DB2HYP22 TSP 02/09/19 08:51:48.20 3.29 0.04233 0.01700 28.69
TSHYP22 N 02/09/19 09:30:00.09 794.33 0.36200 1.32900 0.00
1 N 15.99 0.04233 30782.2K
3.28 0.10000
BP0 DB2HYP22 TSP 02/09/19 08:51:48.20 2.54 0.04955 0.01756 352.35
TSHYP22 N 02/09/19 09:30:00.09 794.39 0.51400 1.33100 0.00
2 N 15.99 0.04913 30783.9K
2.54 0.08800
BP0 DB2PYH22 TSP 02/09/19 08:14:50.88 1.65 0.17300 0.01800 1787.00
TSPYH22 N 02/09/19 09:30:00.09 381.80 1.79200 2.21600 0.00
1 N 15.99 0.00000 57725.2K
0.00 0.00000
BP0 DB2PYH22 TSP 02/09/19 08:14:50.89 1.64 0.17400 0.01800 18.00
TSPYH22 N 02/09/19 09:30:00.09 381.78 6.77500 0.96200 0.00
2 N 15.96 0.00000 57719.2K
- BPOOL
-
The name of the buffer pool to which this information refers.
Field Name: S199BPNM
- DATABASE
-
Database name.
Field Name: S199DBNM
- SPACENAM
-
Pageset name, which can be a table space or an index space.
This is derived from the internal pageset identifier. For a table space this is the value in the PSID column in SYSIBM.SYSTABLESPACE of the catalog when the Db2 trace record was written. For an index space, this is the value in the ISOBID column in SYSIBM.SYSINDEXES.
When OMEGAMON for Db2 PE cannot determine the pageset name, the ID is shown in hexadecimal.
Field Name: S199OBNM
- PART
-
For a partitioned table space or index space, this is the partition number. For a nonpartitioned table space or index space, this is the data set number.
Field Name: QW0199DN
- TYPE
-
This field indicates whether the pageset is a table space (T or TSP) or an index space (I or IDX).
Field Name: S199TYP
- GBP
-
The value in this field specifies whether the pageset is group buffer pool dependent. This is only possible if Db2 has been set up for data sharing.
Field Name: S199GBP
- SHDW
-
Indicates if it is a shadow data set.
Field Name: QW0199SD
- I/O START TIME
-
The start time of the I/O activities for this data set externalized in the data set Statistics record. The field value is derived from QW0199SC.
Field Name: S199SC
- I/O END TIME
-
The end time of the I/O activities for this dataset externalized in the data set Statistics record.
Field Name: S199EC
- SYNCH I/O AVG
-
Average number of synchronous I/Os for the pageset, per second.
Field Name: S199SPAV
- ASYNC I/O AVG
-
Average number of asynchronous I/Os for the pageset, per second.
Field Name: S199ACAV
- ASY I/O PGS AVG
-
Average number of pageset pages read or written per asynchronous I/O.
Field Name: S199APAV
- SYN I/O AVG DELAY
-
Average synchronous I/O delay for pages in the pageset, in milliseconds.
Field Name: QW0199S1
- SYN I/O MAX DELAY
-
Maximum synchronous I/O delay for pages in the pageset, in milliseconds.
Field Name: QW0199S2
- ZHL I/O AVG
- The average number of zHyperLink I/Os for the pageset, per second.
Field Name: S199ZPA1
- ZHL I/O AVG DELAY
- The average zHyperLink I/O delay for the pageset, in milliseconds.
Field Name: QW0199Z1
- ZHL I/O MAX DELAY
- The maximum zHyperLink I/O delay for the pageset, in milliseconds.
Field Name: QW0199Z2
- ASYN I/O AVG DELAY
-
Average asynchronous I/O delay for pages in the pageset, in milliseconds.
Field Name: QW0199A1
- ASYN I/O MAX DELAY
-
The maximum asynchronous I/O delay for pages in the pageset, in milliseconds.
Field Name: QW0199A2
- CURRENT PAGES (VP)
-
Number of pageset pages in the virtual buffer pool.
Field Name: QW0199VP
- CHANGED PAGES (VP)
-
Number of changed page set pages in the virtual buffer pool.
Field Name: QW0199VD
- NUMBER OF GETPAGES
-
The current number of Getpage requests.
Field Name: QW0199GP