Data Element list used by SAP ABAP Table DB4IDC0200 (iSeries: Database Performance: Created Indexes (Detail scr.))
SAP ABAP Table 
DB4IDC0200 (iSeries: Database Performance: Created Indexes (Detail scr.)) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Data Element |
CHAR14 | Text field length 14 | |
| 2 | Data Element |
INT2 | 2 byte integer (signed) | |
| 3 | Data Element |
QIFNM | iSeries: System Name of Index (Database Monitor) | |
| 4 | Data Element |
QPTFN | iSeries: System Name of Base Table (Database Monitor) | |
| 5 | Data Element |
QQAVGT | iSeries: Average Time (Database Monitor) | |
| 6 | Data Element |
QQCIC | iSeries: Number of Index Creates (Database Monitor) | |
| 7 | Data Element |
QQCNT | iSeries: No. of Executions of a Statement (Database Monitor) | |
| 8 | Data Element |
QQCRTK | iSeries: Key Fields of Created Index (Database Monitor) | |
| 9 | Data Element |
QQCST | iSeries: Constraint Used (Y/N) (Database Monitor) | |
| 10 | Data Element |
QQCSTN | iSeries: Constraint Name (Database Monitor) | |
| 11 | Data Element |
QQIDXA | iSeries: Optimizer Advised Index (Database Monitor) | |
| 12 | Data Element |
QQILNM | iSeries: System Name of Index Library (Database Monitor) | |
| 13 | Data Element |
QQKEY | iSeries: Key Field (Database Monitor) | |
| 14 | Data Element |
QQLIFN | iSeries: Index Name (Database Monitor) | |
| 15 | Data Element |
QQLILN | iSeries: Index Library (Database Monitor) | |
| 16 | Data Element |
QQLPTF | iSeries: Base Table (Database Monitor) | |
| 17 | Data Element |
QQLPTL | iSeries: Base Library (Database Monitor) | |
| 18 | Data Element |
QQLTFN | iSeries: Table Name (Database Monitor) | |
| 19 | Data Element |
QQLTLN | iSeries: Library Name (Database Monitor) | |
| 20 | Data Element |
QQMAXT | iSeries: Maximum Time (Database Monitor) | |
| 21 | Data Element |
QQMETU | iSeries: Timest. of Most Expensive Stmt. (Database Monitor) | |
| 22 | Data Element |
QQMINT | iSeries: Minimum Time (Database Monitor) | |
| 23 | Data Element |
QQPLIB | iSeries: Package/Program Library (Database Monitor) | |
| 24 | Data Element |
QQPNAM | iSeries: Package/Program Name (Database Monitor) | |
| 25 | Data Element |
QQPTLN | iSeries: System Name of Base Library (Database Monitor) | |
| 26 | Data Element |
QQRCODIDC | iSeries: Reason Code (Database Monitor) | |
| 27 | Data Element |
QQRROW | iSeries: Result Rows (Database Monitor) | |
| 28 | Data Element |
QQSNAM | iSeries: Statement Name (Database Monitor) | |
| 29 | Data Element |
QQSTTX | iSeries: Statement Text (Database Monitor) | |
| 30 | Data Element |
QQTLN | iSeries: System Name of Library (Database Monitor) | |
| 31 | Data Element |
QQTTIM | iSeries: Time for Index Create (Database Monitor) | |
| 32 | Data Element |
QQUSER | iSeries: Job User (Database Monitor) | |
| 33 | Data Element |
QRIDX | iSeries: Number of Entries in Created Index | |
| 34 | Data Element |
QTFN | iSeries: System Name of Table (Database Monitor) | |
| 35 | Data Element |
QTOTR | iSeries: Total Rows in Table (Database Monitor) | |
| 36 | Data Element |
SYSYSID | Name of SAP System | |
| 37 | Data Element |
TOTTIME | iSeries: Total Time (Database Monitor) |
