SAP table DB2QW199 (DB2 IFI 199 - Data sets statistics)
SAP table DB2QW199 has 9 primary key fields being CLGUID,USERID,DSSDATE,DSSTIME,DSSMSEC,DSSDBNAME,DSSTSNAME,QW0199DN,DSSMEMB.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| CLGUID | CHAR | 32 | 0 | DB2CLGUID | |||
| USERID | INT2 | 5 | 0 | DB2USERID | |||
| DSSDATE | Field of type DATS | DATS | 8 | 0 | DATS | ||
| DSSTIME | Field of type TIMS | TIMS | 6 | 0 | TIMS | ||
| DSSMSEC | Event time stamp (milliseconds) | CHAR | 6 | 0 | DB2EVTTMS | ||
| DSSDBNAME | Database name | CHAR | 8 | 0 | DB2DBNAME | ||
| DSSTSNAME | Name of the tablespace | CHAR | 8 | 0 | DB2TSNAME | ||
| QW0199DN | Partition or piece number | INT2 | 5 | 0 | DB20199DN | ||
| DSSMEMB | DB2 member name in data sharing environment | CHAR | 8 | 0 | DB2MEMN | ||
| DB2PSTYPE | Type of pageset | CHAR | 5 | 0 | DB2PSTYPE | ||
| DB2GBPDEP | Group bufferpool dependence | CHAR | 3 | 0 | DB2GBPDEP | ||
| DB2SYNCIO | Synchronous I/O per minute (pages) | DEC | 8 | 2 | DB2SYNCIO | ||
| DB2APGAIO | Avg. number of pages read or written per asynchronous I/O | DEC | 8 | 2 | DB2APGAIO | ||
| DB2AIOMIN | Asyncronous I/Os per minute (pages) | DEC | 8 | 2 | DB2AIOMIN | ||
| DB2CASHPG | Cached pages | DEC | 5 | 2 | DB2CASHPG | ||
| DB2CHANPG | Changed pages | DEC | 5 | 2 | DB2CHANPG | ||
| DB2HPCAPG | Percentage of buffers in the HP containing pages of the PS | DEC | 4 | 2 | DB2HPCAPG | ||
| DB2DBPNM | Name of buffer pool | CHAR | 8 | 0 | DB2DBPNM | ||
| QW0199TS | Start timestamp for collection of dataset values | CHAR | 8 | 0 | DB20199TS | ||
| QW0199DB | Database ID | INT2 | 5 | 0 | DB20199DB | ||
| QW0199OB | Pageset OBID | INT2 | 5 | 0 | DB20199OB | ||
| QW0199BP | Buffer pool ID | INT4 | 10 | 0 | DB20199BP | ||
| QW0199DS | DSS Flags | CHAR | 1 | 0 | DB20199DS | ||
| QW0199SV | Average synchronous I/O delay | INT4 | 10 | 0 | DB20199SV | ||
| QW0199SX | Maximum synchronous I/O delay | INT4 | 10 | 0 | DB20199SX | ||
| QW0199SP | Total number of pages read or written synchronously | INT4 | 10 | 0 | DB20199SP | ||
| QW0199AD | Average asynchronous I/O delay | INT4 | 10 | 0 | DB20199AD | ||
| QW0199AX | Maximum asynchronous I/O delay | INT4 | 10 | 0 | DB20199AX | ||
| QW0199AP | Total number of pages read or written asynchronously | INT4 | 10 | 0 | DB20199AP | ||
| QW0199AC | Total number of asynchronous I/Os | INT4 | 10 | 0 | DB20199AC | ||
| QW0199VP | Number of pages cached in virtual pool | INT4 | 10 | 0 | DB20199VP | ||
| QW0199VD | Number of changed pages cached in virtual pool | INT4 | 10 | 0 | DB20199VD | ||
| QW0199HP | Number of pages cached in hiperpool | INT4 | 10 | 0 | DB20199HP | ||
| S199AP | Total asynchronous I/O minute (count) | DEC | 8 | 2 | DB2199AP | ||
| QWP1DTIM | Time Interval Before DB2 Resets Data Set Statistics (Min.) | INT2 | 5 | 0 | DB2WP1DTIM |