Table/Structure Field list used by SAP ABAP Function Module DB4_INDEX_ADVISED_INFO (AS/400: Get Indexes Advised info for ST04 Detail Analysis)
SAP ABAP Function Module 
DB4_INDEX_ADVISED_INFO (AS/400: Get Indexes Advised info for ST04 Detail Analysis) is using
-
Class (5)
-
Data Element (3)
-
Table/Structure Field (54)
-
Function Module (1)
-
Message Class (1)
-
Message Number (4)
-
Class Method (8)
-
Table (14)
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 | Table/Structure Field |
DB4IDA0100 - QQAVGT | iSeries: Average Time (Database Monitor) | |
| 2 | Table/Structure Field |
DB4IDA0100 - QQARSS | iSeries: Average Result Set Size (Database Monitor) | |
| 3 | Table/Structure Field |
DB4IDA0100 - TOTTIME | iSeries: Total Time (Database Monitor) | |
| 4 | Table/Structure Field |
DB4IDA0100 - QQUSER | iSeries: Job User (Database Monitor) | |
| 5 | Table/Structure Field |
DB4IDA0100 - QQTOTR | iSeries: Total Rows in Table (Database Monitor) | |
| 6 | Table/Structure Field |
DB4IDA0100 - QQQRYCNT | iSeries: Number of Different Statements (Database Monitor) | |
| 7 | Table/Structure Field |
DB4IDA0100 - QQPTLN | iSeries: System Name of Base Library (Database Monitor) | |
| 8 | Table/Structure Field |
DB4IDA0100 - QQPTFN | iSeries: System Name of Base Table (Database Monitor) | |
| 9 | Table/Structure Field |
DB4IDA0100 - QQLTLN | iSeries: Library Name (Database Monitor) | |
| 10 | Table/Structure Field |
DB4IDA0100 - QQLTFN | iSeries: Table Name (Database Monitor) | |
| 11 | Table/Structure Field |
DB4IDA0100 - QQCNT | iSeries: No. of Executions of a Statement (Database Monitor) | |
| 12 | Table/Structure Field |
DB4IDA0100 - QQCIA | iSeries: Index Advice (Database Monitor) | |
| 13 | Table/Structure Field |
DB4IDA0200 - QQPTFN | iSeries: System Name of Base Table (Database Monitor) | |
| 14 | Table/Structure Field |
DB4IDA0200 - QQPNAM | iSeries: Package/Program Name (Database Monitor) | |
| 15 | Table/Structure Field |
DB4IDA0200 - QQPLIB | iSeries: Package/Program Library (Database Monitor) | |
| 16 | Table/Structure Field |
DB4IDA0200 - QQPTLN | iSeries: System Name of Base Library (Database Monitor) | |
| 17 | Table/Structure Field |
DB4IDA0200 - QQSNAM | iSeries: Statement Name (Database Monitor) | |
| 18 | Table/Structure Field |
DB4IDA0200 - QQSTTX | iSeries: Statement Text (Database Monitor) | |
| 19 | Table/Structure Field |
DB4IDA0200 - QQTFN | iSeries: System Name of Table (Database Monitor) | |
| 20 | Table/Structure Field |
DB4IDA0200 - QQTLN | iSeries: System Name of Library (Database Monitor) | |
| 21 | Table/Structure Field |
DB4IDA0200 - QQTOTR | iSeries: Total Rows in Table (Database Monitor) | |
| 22 | Table/Structure Field |
DB4IDA0200 - QQUSER | iSeries: Job User (Database Monitor) | |
| 23 | Table/Structure Field |
DB4IDA0200 - SYSID | Name of SAP System | |
| 24 | Table/Structure Field |
DB4IDA0200 - TOTTIME | iSeries: Total Time (Database Monitor) | |
| 25 | Table/Structure Field |
DB4IDA0200 - QQMETU | iSeries: Timest. of Most Expensive Stmt. (Database Monitor) | |
| 26 | Table/Structure Field |
DB4IDA0200 - QQMAXT | iSeries: Maximum Time (Database Monitor) | |
| 27 | Table/Structure Field |
DB4IDA0200 - QQLTLN | iSeries: Library Name (Database Monitor) | |
| 28 | Table/Structure Field |
DB4IDA0200 - QQLTFN | iSeries: Table Name (Database Monitor) | |
| 29 | Table/Structure Field |
DB4IDA0200 - QQLPTL | iSeries: Base Library (Database Monitor) | |
| 30 | Table/Structure Field |
DB4IDA0200 - QQLPTF | iSeries: Base Table (Database Monitor) | |
| 31 | Table/Structure Field |
DB4IDA0200 - QQKEY | iSeries: Key Field (Database Monitor) | |
| 32 | Table/Structure Field |
DB4IDA0200 - QQIDXD | iSeries: Definition of Advised Index (Database Monitor) | |
| 33 | Table/Structure Field |
DB4IDA0200 - QQCNT | iSeries: No. of Executions of a Statement (Database Monitor) | |
| 34 | Table/Structure Field |
DB4IDA0200 - QQCIA | iSeries: Index Advice (Database Monitor) | |
| 35 | Table/Structure Field |
DB4IDA0200 - QQAVGT | iSeries: Average Time (Database Monitor) | |
| 36 | Table/Structure Field |
DB4IDA0200 - IPLTIME | Text field length 14 | |
| 37 | Table/Structure Field |
DB4IDA0200 - QQMINT | iSeries: Minimum Time (Database Monitor) | |
| 38 | Table/Structure Field |
DB4IDA0300 - QQPTFN | iSeries: System Name of Base Table (Database Monitor) | |
| 39 | Table/Structure Field |
DB4IDA0300 - QQPTLN | iSeries: System Name of Base Library (Database Monitor) | |
| 40 | Table/Structure Field |
DB4IDA0300 - QQIDXD | iSeries: Key Fields for the Advised Index | |
| 41 | Table/Structure Field |
DB4IDA0300 - QQCIA | iSeries: Index Advice (Database Monitor) | |
| 42 | Table/Structure Field |
DB4QQPAR - QRESET | iSeries: Flag to indicate reset in ST04 | SOURCE VALUE(RESETFLAG) LIKE DB4QQPAR-QRESET DEFAULT SPACE |
| 43 | Table/Structure Field |
DB4QQPAR - QRESET | iSeries: Flag to indicate reset in ST04 | |
| 44 | Table/Structure Field |
DB4TABLST - QQTFN | iSeries: System Name of Table (Database Monitor) | |
| 45 | Table/Structure Field |
DB4TABLST - QQTLN | iSeries: System Name of Library (Database Monitor) | |
| 46 | Table/Structure Field |
DB6NAVSYST - DBCNAME | Logical name for a database connection | |
| 47 | Table/Structure Field |
SQ1000_DB4 - QQKEY | iSeries: Key Field (Database Monitor) | |
| 48 | Table/Structure Field |
SQ1000_DB4 - QQPLIB | iSeries: Package/Program Library (Database Monitor) | |
| 49 | Table/Structure Field |
SQ1000_DB4 - QQPNAM | iSeries: Package/Program Name (Database Monitor) | |
| 50 | Table/Structure Field |
SQ1000_DB4 - QQSNAM | iSeries: Statement Name (Database Monitor) | |
| 51 | Table/Structure Field |
SQ3000_DB4 - QQIDXD | iSeries: Definition of Advised Index (Database Monitor) | |
| 52 | Table/Structure Field |
SQ3000_DB4 - QQIDXD_LEN | 2 byte integer (signed) | |
| 53 | Table/Structure Field |
SQTEXT_DB4 - QQSTTX_LNG | 2 byte integer (signed) | |
| 54 | Table/Structure Field |
SYST - TABIX | ABAP System Field: Row Index of Internal Tables |
