Data Element list used by SAP ABAP Table SQ3001_DB4 (iSeries: Used Indexes (Database Monitor))
SAP ABAP Table
SQ3001_DB4 (iSeries: Used Indexes (Database Monitor)) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | CHAR14 | Text field length 14 | ||
| 2 | INT2 | 2 byte integer (signed) | ||
| 3 | QAJN | iSeries: Estimated Number of Joined Rows (Database Monitor) | ||
| 4 | QEPT | iSeries: Estimated Processing Time (Database Monitor) | ||
| 5 | QFKEY | iSeries: Estimated Rows Returned by Key Positioning | ||
| 6 | QIDXD | iSeries: Definition of Advised Index (Database Monitor) | ||
| 7 | QIFNM | iSeries: System Name of Index (Database Monitor) | ||
| 8 | QJNP | iSeries: Join Position (Database Monitor) | ||
| 9 | QKSEL | iSeries: Estimated Rows Returned by Key Selection | ||
| 10 | QMATL | iSeries: Mat. QDT Level (Database Monitor) | ||
| 11 | QMATN | iSeries: Mat. QDT Number (Database Monitor) | ||
| 12 | QPTFN | iSeries: System Name of Base Table (Database Monitor) | ||
| 13 | QQ1000 | iSeries: Reserved Field (Database Monitor) | ||
| 14 | QQC11 | iSeries: Reserved Field (Database Monitor) | ||
| 15 | QQC12 | iSeries: Reserved Field (Database Monitor) | ||
| 16 | QQC21 | iSeries: Reserved Field (Database Monitor) | ||
| 17 | QQC22 | iSeries: Reserved Field (Database Monitor) | ||
| 18 | QQC301 | iSeries: Reserved Field (Database Monitor) | ||
| 19 | QQC302 | iSeries: Reserved Field (Database Monitor) | ||
| 20 | QQCST | iSeries: Constraint Used (Y/N) (Database Monitor) | ||
| 21 | QQCSTN | iSeries: Constraint Name (Database Monitor) | ||
| 22 | QQDSS | iSeries: Dataspace Selection (Database Monitor) | ||
| 23 | QQDTL | iSeries: Query Definition Template Level | ||
| 24 | QQDTN | iSeries: Query Definition Template Number | ||
| 25 | QQI1 | iSeries: Reserved Field (Database Monitor) | ||
| 26 | QQI2 | iSeries: Reserved Field (Database Monitor) | ||
| 27 | QQIDXA | iSeries: Optimizer Advised Index (Database Monitor) | ||
| 28 | QQIDXK | iSeries: No. of Key Fields of Advised Index | ||
| 29 | QQILNM | iSeries: System Name of Index Library (Database Monitor) | ||
| 30 | QQJNDS | iSeries: Dataspace Number (Database Monitor) | ||
| 31 | QQJNMT | iSeries: Join Method (Database Monitor) | ||
| 32 | QQJNOP | iSeries: Join Operator (Database Monitor) | ||
| 33 | QQJNTY | iSeries: Join Type (Database Monitor) | ||
| 34 | QQKEY | iSeries: Key Field (Database Monitor) | ||
| 35 | QQKEY2 | iSeries: 2nd Key Field of Database Monitor Files | ||
| 36 | QQKP | iSeries: Key Positioning (Database Monitor) | ||
| 37 | QQKPN | iSeries: No. of Key Positioning Keys (Database Monitor) | ||
| 38 | QQKS | iSeries: Key Selection (Database Monitor) | ||
| 39 | QQLIFN | iSeries: Index Name (Database Monitor) | ||
| 40 | QQLILN | iSeries: Index Library (Database Monitor) | ||
| 41 | QQLPTF | iSeries: Base Table (Database Monitor) | ||
| 42 | QQLPTL | iSeries: Base Library (Database Monitor) | ||
| 43 | QQLTFN | iSeries: Table Name (Database Monitor) | ||
| 44 | QQLTLN | iSeries: Library Name (Database Monitor) | ||
| 45 | QQPTLN | iSeries: System Name of Base Library (Database Monitor) | ||
| 46 | QQRCODIDU | iSeries: Reason Code for Used Index (Database Monitor) | ||
| 47 | QQTIME | iSeries: Record Creation Timestamp (Database Monitor) | ||
| 48 | QQTLN | iSeries: System Name of Library (Database Monitor) | ||
| 49 | QREST | iSeries: Estimated No. of Selected Rows (Database Monitor) | ||
| 50 | QTFN | iSeries: System Name of Table (Database Monitor) | ||
| 51 | QTOTR | iSeries: Total Rows in Table (Database Monitor) | ||
| 52 | SYSYSID | Name of SAP System |