Table/Structure Field list used by SAP ABAP Function Module DB4_INDEX_USED_INFO (AS/400: Get index used info for ST04 Detail Analysis)
SAP ABAP Function Module 
DB4_INDEX_USED_INFO (AS/400: Get index used info for ST04 Detail Analysis) is using
-
Class (5)
-
Data Element (3)
-
Table/Structure Field (68)
-
Function Module (1)
-
Message Class (1)
-
Message Number (4)
-
Class Method (7)
-
Table (12)
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 | Table/Structure Field |
DB4IDU0100 - QQIFNM | iSeries: System Name of Index (Database Monitor) | |
| 2 | Table/Structure Field |
DB4IDU0100 - QQILNM | iSeries: System Name of Index Library (Database Monitor) | |
| 3 | Table/Structure Field |
DB4IDU0100 - QQQRYCNT | iSeries: Number of Different Statements (Database Monitor) | |
| 4 | Table/Structure Field |
DB4IDU0100 - QQRROW | iSeries: Result Rows (Database Monitor) | |
| 5 | Table/Structure Field |
DB4IDU0100 - QQTOTR | iSeries: Total Rows in Table (Database Monitor) | |
| 6 | Table/Structure Field |
DB4IDU0100 - QQAVGT | iSeries: Average Time (Database Monitor) | |
| 7 | Table/Structure Field |
DB4IDU0200 - QQMETU | iSeries: Timest. of Most Expensive Stmt. (Database Monitor) | |
| 8 | Table/Structure Field |
DB4IDU0200 - QQTLN | iSeries: System Name of Library (Database Monitor) | |
| 9 | Table/Structure Field |
DB4IDU0200 - QQMINT | iSeries: Minimum Time (Database Monitor) | |
| 10 | Table/Structure Field |
DB4IDU0200 - QQPLIB | iSeries: Package/Program Library (Database Monitor) | |
| 11 | Table/Structure Field |
DB4IDU0200 - QQPNAM | iSeries: Package/Program Name (Database Monitor) | |
| 12 | Table/Structure Field |
DB4IDU0200 - QQPTFN | iSeries: System Name of Base Table (Database Monitor) | |
| 13 | Table/Structure Field |
DB4IDU0200 - QQPTLN | iSeries: System Name of Base Library (Database Monitor) | |
| 14 | Table/Structure Field |
DB4IDU0200 - QQRCOD | iSeries: Reason Code for Used Index (Database Monitor) | |
| 15 | Table/Structure Field |
DB4IDU0200 - QQRROW | iSeries: Result Rows (Database Monitor) | |
| 16 | Table/Structure Field |
DB4IDU0200 - QQSNAM | iSeries: Statement Name (Database Monitor) | |
| 17 | Table/Structure Field |
DB4IDU0200 - QQSTTX | iSeries: Statement Text (Database Monitor) | |
| 18 | Table/Structure Field |
DB4IDU0200 - QQTFN | iSeries: System Name of Table (Database Monitor) | |
| 19 | Table/Structure Field |
DB4IDU0200 - QQTOTR | iSeries: Total Rows in Table (Database Monitor) | |
| 20 | Table/Structure Field |
DB4IDU0200 - QQUSER | iSeries: Job User (Database Monitor) | |
| 21 | Table/Structure Field |
DB4IDU0200 - SYSID | Name of SAP System | |
| 22 | Table/Structure Field |
DB4IDU0200 - TOTTIME | iSeries: Total Time (Database Monitor) | |
| 23 | Table/Structure Field |
DB4IDU0200 - QQLTLN | iSeries: Library Name (Database Monitor) | |
| 24 | Table/Structure Field |
DB4IDU0200 - QQMAXT | iSeries: Maximum Time (Database Monitor) | |
| 25 | Table/Structure Field |
DB4IDU0200 - IPLTIME | Text field length 14 | |
| 26 | Table/Structure Field |
DB4IDU0200 - QQAVGT | iSeries: Average Time (Database Monitor) | |
| 27 | Table/Structure Field |
DB4IDU0200 - QQCIU | iSeries: Index Usage (Database Monitor) | |
| 28 | Table/Structure Field |
DB4IDU0200 - QQCNT | iSeries: No. of Executions of a Statement (Database Monitor) | |
| 29 | Table/Structure Field |
DB4IDU0200 - QQCST | iSeries: Constraint Used (Y/N) (Database Monitor) | |
| 30 | Table/Structure Field |
DB4IDU0200 - QQCSTN | iSeries: Constraint Name (Database Monitor) | |
| 31 | Table/Structure Field |
DB4IDU0200 - QQIDXA | iSeries: Optimizer Advised Index (Database Monitor) | |
| 32 | Table/Structure Field |
DB4IDU0200 - QQILNM | iSeries: System Name of Index Library (Database Monitor) | |
| 33 | Table/Structure Field |
DB4IDU0200 - QQKEY | iSeries: Key Field (Database Monitor) | |
| 34 | Table/Structure Field |
DB4IDU0200 - QQLIFN | iSeries: Index Name (Database Monitor) | |
| 35 | Table/Structure Field |
DB4IDU0200 - QQLILN | iSeries: Index Library (Database Monitor) | |
| 36 | Table/Structure Field |
DB4IDU0200 - QQLPTF | iSeries: Base Table (Database Monitor) | |
| 37 | Table/Structure Field |
DB4IDU0200 - QQLPTL | iSeries: Base Library (Database Monitor) | |
| 38 | Table/Structure Field |
DB4IDU0200 - QQLTFN | iSeries: Table Name (Database Monitor) | |
| 39 | Table/Structure Field |
DB4IDU0200 - QQIFNM | iSeries: System Name of Index (Database Monitor) | |
| 40 | Table/Structure Field |
DB4IDULST - QQIFNM | iSeries: System Name of Index (Database Monitor) | |
| 41 | Table/Structure Field |
DB4IDULST - QQILNM | iSeries: System Name of Index Library (Database Monitor) | |
| 42 | Table/Structure Field |
DB4IDULST - QQCST | iSeries: Constraint Used (Y/N) (Database Monitor) | |
| 43 | Table/Structure Field |
DB4QQPAR - QRESET | iSeries: Flag to indicate reset in ST04 | SOURCE VALUE(RESETFLAG) LIKE DB4QQPAR-QRESET DEFAULT SPACE |
| 44 | Table/Structure Field |
DB4QQPAR - QRESET | iSeries: Flag to indicate reset in ST04 | |
| 45 | Table/Structure Field |
DB6NAVSYST - DBCNAME | Logical name for a database connection | |
| 46 | Table/Structure Field |
SQ1000_DB4 - QQAVGT | iSeries: Average Time (Database Monitor) | |
| 47 | Table/Structure Field |
SQ1000_DB4 - TOTTIME | iSeries: Total Time (Database Monitor) | |
| 48 | Table/Structure Field |
SQ1000_DB4 - QQUSER | iSeries: Job User (Database Monitor) | |
| 49 | Table/Structure Field |
SQ1000_DB4 - QQSNAM | iSeries: Statement Name (Database Monitor) | |
| 50 | Table/Structure Field |
SQ1000_DB4 - QQRROW | iSeries: Result Rows (Database Monitor) | |
| 51 | Table/Structure Field |
SQ1000_DB4 - QQPLIB | iSeries: Package/Program Library (Database Monitor) | |
| 52 | Table/Structure Field |
SQ1000_DB4 - QQKEY | iSeries: Key Field (Database Monitor) | |
| 53 | Table/Structure Field |
SQ1000_DB4 - QQCNT | iSeries: No. of Executions of a Statement (Database Monitor) | |
| 54 | Table/Structure Field |
SQ1000_DB4 - QQCIU | iSeries: Index Usage (Database Monitor) | |
| 55 | Table/Structure Field |
SQ1000_DB4 - QQPNAM | iSeries: Package/Program Name (Database Monitor) | |
| 56 | Table/Structure Field |
SQ3001_DB4 - QQLIFN | iSeries: Index Name (Database Monitor) | |
| 57 | Table/Structure Field |
SQ3001_DB4 - QQTOTR | iSeries: Total Rows in Table (Database Monitor) | |
| 58 | Table/Structure Field |
SQ3001_DB4 - QQTLN | iSeries: System Name of Library (Database Monitor) | |
| 59 | Table/Structure Field |
SQ3001_DB4 - QQTFN | iSeries: System Name of Table (Database Monitor) | |
| 60 | Table/Structure Field |
SQ3001_DB4 - QQLPTL | iSeries: Base Library (Database Monitor) | |
| 61 | Table/Structure Field |
SQ3001_DB4 - QQLPTF | iSeries: Base Table (Database Monitor) | |
| 62 | Table/Structure Field |
SQ3001_DB4 - QQLILN | iSeries: Index Library (Database Monitor) | |
| 63 | Table/Structure Field |
SQ3001_DB4 - QQILNM | iSeries: System Name of Index Library (Database Monitor) | |
| 64 | Table/Structure Field |
SQ3001_DB4 - QQIFNM | iSeries: System Name of Index (Database Monitor) | |
| 65 | Table/Structure Field |
SQ3001_DB4 - QQCSTN | iSeries: Constraint Name (Database Monitor) | |
| 66 | Table/Structure Field |
SQ3001_DB4 - QQCST | iSeries: Constraint Used (Y/N) (Database Monitor) | |
| 67 | Table/Structure Field |
SQTEXT_DB4 - QQSTTX_LNG | 2 byte integer (signed) | |
| 68 | Table/Structure Field |
SYST - TABIX | ABAP System Field: Row Index of Internal Tables |
