Data Element list used by SAP ABAP Table DB2QW199 (DB2 IFI 199 - Data sets statistics)
SAP ABAP Table 
DB2QW199 (DB2 IFI 199 - Data sets statistics) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Data Element |
DATS | Field of type DATS | |
| 2 | Data Element |
DB20199AC | Total number of asynchronous I/Os | |
| 3 | Data Element |
DB20199AD | Average asynchronous I/O delay | |
| 4 | Data Element |
DB20199AP | Total number of pages read or written asynchronously | |
| 5 | Data Element |
DB20199AX | Maximum asynchronous I/O delay | |
| 6 | Data Element |
DB20199BP | Buffer pool ID | |
| 7 | Data Element |
DB20199DB | Database ID | |
| 8 | Data Element |
DB20199DN | Partition or piece number | |
| 9 | Data Element |
DB20199DS | DSS Flags | |
| 10 | Data Element |
DB20199HP | Number of pages cached in hiperpool | |
| 11 | Data Element |
DB20199OB | Pageset OBID | |
| 12 | Data Element |
DB20199SP | Total number of pages read or written synchronously | |
| 13 | Data Element |
DB20199SV | Average synchronous I/O delay | |
| 14 | Data Element |
DB20199SX | Maximum synchronous I/O delay | |
| 15 | Data Element |
DB20199TS | Start timestamp for collection of dataset values | |
| 16 | Data Element |
DB20199VD | Number of changed pages cached in virtual pool | |
| 17 | Data Element |
DB20199VP | Number of pages cached in virtual pool | |
| 18 | Data Element |
DB2199AP | Total asynchronous I/O minute (count) | |
| 19 | Data Element |
DB2AIOMIN | Asyncronous I/Os per minute (pages) | |
| 20 | Data Element |
DB2APGAIO | Avg. number of pages read or written per asynchronous I/O | |
| 21 | Data Element |
DB2CASHPG | Cached pages | |
| 22 | Data Element |
DB2CHANPG | Changed pages | |
| 23 | Data Element |
DB2CLGUID | DB2CLGUID- | |
| 24 | Data Element |
DB2DBNAME | Database name | |
| 25 | Data Element |
DB2DBPNM | Name of buffer pool | |
| 26 | Data Element |
DB2EVTTMS | Event time stamp (milliseconds) | |
| 27 | Data Element |
DB2GBPDEP | Group bufferpool dependence | |
| 28 | Data Element |
DB2HPCAPG | Percentage of buffers in the HP containing pages of the PS | |
| 29 | Data Element |
DB2MEMN | DB2 member name in data sharing environment | |
| 30 | Data Element |
DB2PSTYPE | Type of pageset | |
| 31 | Data Element |
DB2SYNCIO | Synchronous I/O per minute (pages) | |
| 32 | Data Element |
DB2TSNAME | Name of the tablespace | |
| 33 | Data Element |
DB2USERID | DB2USERID- | |
| 34 | Data Element |
DB2WP1DTIM | Time Interval Before DB2 Resets Data Set Statistics (Min.) | |
| 35 | Data Element |
TIMS | Field of type TIMS |
