Data Element list used by SAP ABAP Table DB4IDU0200 (iSeries Database Performance: Used Indexes (Detail screen))
SAP ABAP Table DB4IDU0200 (iSeries Database Performance: Used Indexes (Detail screen)) 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 | QQCIU | iSeries: Index Usage (Database Monitor) | |
7 | Data Element | QQCNT | iSeries: No. of Executions of a Statement (Database Monitor) | |
8 | Data Element | QQCST | iSeries: Constraint Used (Y/N) (Database Monitor) | |
9 | Data Element | QQCSTN | iSeries: Constraint Name (Database Monitor) | |
10 | Data Element | QQIDXA | iSeries: Optimizer Advised Index (Database Monitor) | |
11 | Data Element | QQILNM | iSeries: System Name of Index Library (Database Monitor) | |
12 | Data Element | QQKEY | iSeries: Key Field (Database Monitor) | |
13 | Data Element | QQLIFN | iSeries: Index Name (Database Monitor) | |
14 | Data Element | QQLILN | iSeries: Index Library (Database Monitor) | |
15 | Data Element | QQLPTF | iSeries: Base Table (Database Monitor) | |
16 | Data Element | QQLPTL | iSeries: Base Library (Database Monitor) | |
17 | Data Element | QQLTFN | iSeries: Table Name (Database Monitor) | |
18 | Data Element | QQLTLN | iSeries: Library Name (Database Monitor) | |
19 | Data Element | QQMAXT | iSeries: Maximum Time (Database Monitor) | |
20 | Data Element | QQMETU | iSeries: Timest. of Most Expensive Stmt. (Database Monitor) | |
21 | Data Element | QQMINT | iSeries: Minimum Time (Database Monitor) | |
22 | Data Element | QQPLIB | iSeries: Package/Program Library (Database Monitor) | |
23 | Data Element | QQPNAM | iSeries: Package/Program Name (Database Monitor) | |
24 | Data Element | QQPTLN | iSeries: System Name of Base Library (Database Monitor) | |
25 | Data Element | QQRCODIDU | iSeries: Reason Code for Used Index (Database Monitor) | |
26 | Data Element | QQRROW | iSeries: Result Rows (Database Monitor) | |
27 | Data Element | QQSNAM | iSeries: Statement Name (Database Monitor) | |
28 | Data Element | QQSTTX | iSeries: Statement Text (Database Monitor) | |
29 | Data Element | QQTLN | iSeries: System Name of Library (Database Monitor) | |
30 | Data Element | QQUSER | iSeries: Job User (Database Monitor) | |
31 | Data Element | QTFN | iSeries: System Name of Table (Database Monitor) | |
32 | Data Element | QTOTR | iSeries: Total Rows in Table (Database Monitor) | |
33 | Data Element | SYSYSID | Name of SAP System | |
34 | Data Element | TOTTIME | iSeries: Total Time (Database Monitor) |