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