Simulated buffer pool statistics tables (DMRSYxxx)
The following table describes the columns in the DMRSYDTL, DMRSYSUM, and DMRSYSM2 tables.
Performance report column name | SMF field name | Used in report | Field type | Description |
|---|---|---|---|---|
DMRTABLEVERSION | Not applicable | NO | Char(8) | Version of Performance Reporter that created or modified the table definition |
DMRVERSION | Not applicable | NO | Char(8) | Version of Performance Reporter that created or modified the row |
SYSTEMID | SM100SID | YES | Char(4) | System ID (SMF ID) |
SUBSYSTEM | SM100SSI | YES | Char(4) | Subsystem ID - name of Db2 subsystem |
QWHS - Standard Header | ||||
DATETIME | QWHSSTCK | YES | TIMESTAMP | Date and time record was created |
DATE | QWHSSTCK | YES | DATE | Date record was created |
YEAR | QWHSSTCK | YES | CHAR(4) | Year record was created |
MONTH | QWHSSTCK | YES | CHAR(2) | Month record was created |
DAY | QWHSSTCK | YES | CHAR(2) | Day record was created |
TIME | QWHSSTCK | YES | TIME | Time record was created |
HOUR | QWHSSTCK | YES | CHAR(2) | Hour record was created |
DAYOFWEEK# | QWHSSTCK | NO | SMALLINT | Relative day of week, 1 to 7, where Monday=1 and Sunday=7 |
DAYOFWEEK | QWHSSTCK | NO | CHAR(3) | MON, TUE, WED, THU, FRI, SAT, SUN |
WEEK# | QWHSSTCK | NO | INTEGER | Week number relative to the 1 January 1900 epoch |
INTERVAL | None | YES | INTEGER | Summation interval |
TRANSCNT | QWACPCNT for rollup records, otherwise, see description | YES | INTEGER | Number of transactions |
IFCIDSEQ# | QWHSISEQ | NO | INTEGER | Internal sequence number |
LOCATION | QWHSLOCN | YES | CHAR(16) | Local location name |
GROUPNAME | QWHADSGN | YES | CHAR(8) | Group name |
MEMBERNAME | QWHAMEMN | YES | CHAR(8) | Member name |
QBSP - Simulated Buffer Pool Statistics | ||||
BPNAME | QBSPBPID | NO | CHAR(6) | Simulated buffer pool ID |
CURSIMPAGES | QBSPIUS | NO | BIGINT | Current number of pages in simulated buffer pool |
HWMSIMPAGES | QBSPHUS | NO | BIGINT | Highest number of pages in simulated buffer pool |
SEQSIMPAGES | QBSPSUS | NO | BIGINT | Number of sequential pages in simulated buffer pool |
HWMSEQSIMPAGES | QBSPHSU | NO | BIGINT | Highest number of sequential pages in simulated buffer pool |
RDMSIOSIMPAGES | QBSPDRR | NO | BIGINT | Number of pages found in the simulated buffer pool for a random request that resulted in a synchronous read I/O |
SEQSIOSIMPAGES | QBSPDRS | NO | BIGINT | Number of pages found in the simulated buffer pool for a sequential request that resulted in a synchronous read I/O |
PRFASYCSIMPAGES | QBSPDRA | NO | BIGINT | Number of pages found in the simulated buffer pool for a prefetch request that resulted in an asynchronous read I/O |
RDMSYCGBPSIMPGS | QBSPGRR | NO | BIGINT | Number of pages found in the simulated buffer pool for a random request that resulted in a synchronous GBP read |
SEQSYCGBPSIMPGS | QBSPGRS | NO | BIGINT | Number of pages found in the simulated buffer pool for a sequential request that resulted in a synchronous GBP read |
PRFSYCGBPSIMPGS | QBSPGRA | NO | BIGINT | Number of pages found in the simulated buffer pool for a prefetch request that resulted in an asynchronous GBP read |
LOGICMOVEDSIMPGS | QBSPMVI | NO | BIGINT | Number of pages logically moved into the simulated buffer pool |
WAITSIMSYNCIO | QBSPDTM | NO | BIGINT | Total time in microseconds waiting for synchronous read I/O for pages found in the simulated buffer pool |
LOCATION_L | QWHSLOCN | NO | VARCHAR(128) | Long name version of the local location (Db2 subsystem ID if not defined) |