IFCID 199 - Buffer Pool Statistics at Data Set Level
This topic shows detailed information about Record Trace - IFCID 199 - Buffer Pool Statistics at Data Set Level
.
Record trace - IFCID 199 - Buffer Pool Statistics at Data Set Level
The field labels shown in the following sample layout of Record Trace - IFCID 199 - Buffer Pool Statistics at Data Set Level
are described in the following section.
INTERVAL STATIME COMPLETED: 02/09/19 08:51:48.206479
-------------------------------------------------------------------------------------------------------------------------
DBID: 452 DBNAME : 452 GBP DEPENDENT : NO LAST IN SEQUENCE NO
OBID: 2 OBNAME : 2 TYPE OF DATASET: DATA
BPID: BP0 SHADOW COPY: NO PARTITION : 1
LAST STATISTICS: 02/09/19 08:14:50.720136
SYNC.I/O FOR WRITE AND READ ASYNC.I/O FOR WRITE, READ, CASTOUT BUFFER POOL CACHED PAGES
AVG. DELAY I/O (USEC) 40 AVG. DELAY I/O (USEC) 17 VPOOL CACHE CURR. 1759
MAX. DELAY I/O (USEC) 979 MAX. DELAY I/O (USEC) 1575 VPOOL CACHE CHANGED 0
TOTAL I/O PAGES 7727 TOTAL I/O PAGES 28765645
TOTAL I/O COUNT 1798520
ZHYPERLINK READ
AVG. DELAY I/O (USEC) 39
MAX. DELAY I/O (USEC) 393
TOTAL I/O PAGES 7706
CURRENT GETPAGES 60177764- INTERVAL STATIME COMPLETED
-
Stores the clock value at the end of the statistics interval.
Field Name: QW0199TS
- DBID
-
Internal identifier of the database where the tablespace or indexspace resides.
The ID can be used to match column DBID of table SYSIBM.SYSDATABASE in the Db2 catalog.
Be aware the value in the catalog may have changed since the time the Db2 trace record was written.
Field Name: QW0199DB
- DBNAME
-
Internal identifier of the database where the tablespace or indexspace resides.
The ID can be used to match column DBID of table SYSIBM.SYSDATABASE in the Db2 catalog.
Be aware the value in the catalog may have changed since the time the Db2 trace record was written.
Field Name: QW0199DB
- GBP DEPENDENT
-
Indicates whether the pageset is group buffer pool dependent. This is possible only if Db2 has been set up for data sharing.
Field Name: QW0199GD
- LAST IN SEQUENCE
-
Indicates if this is the last IFCID 0199 record.
Field Name: QW0199LS
- OBID
-
The internal identifier of the pageset. This can be either a table space or an index space.
For a table space the ID can be used to match column 'PSID' in SYSIBM.SYSTABLESPACE of the catalog.
For an index space the ID can be used to match column 'ISOBID' in SYSIBM.SYSINDEXES.
Be aware the value in the catalog may have changed since the time the Db2 trace record was written.
Field Name: QW0199OB
- OBNAME
-
The internal identifier of the pageset. This can be either a table space or an index space.
For a table space the ID can be used to match column 'PSID' in SYSIBM.SYSTABLESPACE of the catalog.
For an index space the ID can be used to match column 'ISOBID' in SYSIBM.SYSINDEXES.
Be aware the value in the catalog may have changed since the time the Db2 trace record was written.
Field Name: QW0199OB
- TYPE OF DATASET
-
Indicates whether the data set is a data table or an index space.
Field Name: QW0199ID
- BPID
-
Identifies the buffer pool to which the information in this section refers:
- Values 0 through 49 are identifiers for BP0 through BP49.
- Values 80 through 89 are identifiers for BP32K through BP32K9.
- Values 100 through 109 are identifiers for BP8K through BP8K9.
- Values 120 through 129 are identifiers for BP16K through BP16K9.
Field Name: QW0199BP
- SHADOW COPY
-
Indicates if it is a shadow data set.
Field Name: QW0199SD
- PARTITION
-
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
- LAST STATISTICS
-
The timestamp of the last time this data set was externalized in the data set Statistics record. If this is the first time, this data set appears in the Statistics record, this timestamp represents the time when the data set was opened.
Field Name: QW0199SC
- SYNC.I/O FOR WRITE AND READ – AVG. DELAY I/O (USEC)
- Average synchronous I/O delay for pages in the pageset, in microseconds.
Field Name: QW0199S1
- SYNC.I/O FOR WRITE AND READ – MAX. DELAY I/O (USEC)
- Maximum synchronous I/O delay for pages in the pageset, in microseconds.
Field Name: QW0199S2
- SYNC.I/O FOR WRITE AND READ - TOTAL I/O PAGES
-
The number of synchronous I/Os for the pageset in the reported interval.
Field Name: QW0199SP
- ASYNC.I/O FOR WRITE, READ, CASTOUT – AVG. DELAY I/O (MS)
- Average asynchronous I/O delay for pages in the pageset, in microseconds.
Field Name: QW0199A1
- ASYNC.I/O FOR WRITE, READ, CASTOUT – AVG. DELAY I/O (MS)
- Average asynchronous I/O delay for pages in the pageset, in microseconds.
Field Name: QW0199A2
- ASYNC.I/ASYNC.I/O FOR WRITE, READ, CASTOUT - TOTAL I/O PAGES
-
Number of pages read or written asynchronously for the pageset in the reported interval.
Field Name: QW0199AP
- ASYNC.I/ASYNC.I/O FOR WRITE, READ, CASTOUT - TOTAL I/O COUNT
-
The number of asynchronous I/Os for the pageset during the reported interval.
Field Name: QW0199AC
- BUFFER POOL CACHED PAGES - VPOOL CACHE CURR.
-
Number of pageset pages in the virtual buffer pool.
Field Name: QW0199VP
- BUFFER POOL CACHED PAGES - VPOOL CACHED CHANGED
-
Number of changed page set pages in the virtual buffer pool.
Field Name: QW0199VD
- ZHYPERLINK READ – AVG. DELAY I/O (USEC)
- Average delay for zHyperLink read I/O for pages in the pageset, in microseconds.
Field Name: QW0199Z1
- ZHYPERLINK READ – MAX. DELAY I/O (USEC)
- Maximum delay for zHyperLink read I/O for pages in the pageset, in microseconds.
Field Name: QW0199Z2
- ZHYPERLINK READ – TOTAL I/O PAGES
- The number of pages in the pageset read using zHyperLink during the reported
interval.
Field Name: QW0199ZP
- CURRENT GETPAGES
-
The current number of Getpage requests.
Field Name: QW0199GP