SAP Table DB4IDA0200
iSeries: Database Performance: Advised Indexes (Detail scr.)
DB4IDA0200 (iSeries: Database Performance: Advised Indexes (Detail scr.)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link DB4IDA0200 to other SAP tables.
DB4IDA0200 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| SYSID | Name of SAP System | SYSYSID | CHAR | 8 | 0 | |||
| IPLTIME | Text field length 14 | CHAR14 | CHAR | 14 | 0 | |||
| QQKEY | iSeries: Key Field (Database Monitor) | QQKEY | CHAR | 17 | 0 | |||
| QQPTLN | iSeries: System Name of Base Library (Database Monitor) | QQPTLN | CHAR | 10 | 0 | |||
| QQPTFN | iSeries: System Name of Base Table (Database Monitor) | QPTFN | CHAR | 30 | 0 | |||
| QQTLN | iSeries: System Name of Library (Database Monitor) | QQTLN | CHAR | 10 | 0 | |||
| QQTFN | iSeries: System Name of Table (Database Monitor) | QTFN | CHAR | 30 | 0 | |||
| QQLPTL | iSeries: Base Library (Database Monitor) | QQLPTL | CHAR | 128 | 0 | |||
| QQLPTF | iSeries: Base Table (Database Monitor) | QQLPTF | CHAR | 128 | 0 | |||
| QQLTLN | iSeries: Library Name (Database Monitor) | QQLTLN | CHAR | 128 | 0 | |||
| QQLTFN | iSeries: Table Name (Database Monitor) | QQLTFN | CHAR | 128 | 0 | |||
| QQPLIB | iSeries: Package/Program Library (Database Monitor) | QQPLIB | CHAR | 10 | 0 | |||
| QQPNAM | iSeries: Package/Program Name (Database Monitor) | QQPNAM | CHAR | 10 | 0 | |||
| QQSNAM | iSeries: Statement Name (Database Monitor) | QQSNAM | CHAR | 18 | 0 | |||
| QQCNT | iSeries: No. of Executions of a Statement (Database Monitor) | QQCNT | DEC | 15 | 0 | |||
| QQCIA | iSeries: Index Advice (Database Monitor) | QQCIA | DEC | 15 | 0 | |||
| QQTOTR | iSeries: Total Rows in Table (Database Monitor) | QTOTR | DEC | 15 | 0 | |||
| QQARSS | iSeries: Average Result Set Size (Database Monitor) | QQARSS | DEC | 15 | 0 | |||
| QQAVGT | iSeries: Average Time (Database Monitor) | QQAVGT | DEC | 15 | 0 | |||
| TOTTIME | iSeries: Total Time (Database Monitor) | TOTTIME | DEC | 15 | 0 | |||
| QQMINT | iSeries: Minimum Time (Database Monitor) | QQMINT | DEC | 15 | 0 | |||
| QQMAXT | iSeries: Maximum Time (Database Monitor) | QQMAXT | DEC | 15 | 0 | |||
| QQMETU | iSeries: Timest. of Most Expensive Stmt. (Database Monitor) | QQMETU | CHAR | 26 | 0 | |||
| QQIDXD | iSeries: Definition of Advised Index (Database Monitor) | QIDXD | LCHR | 1000 | 0 | |||
| QQSTTX_LEN | 2 byte integer (signed) | INT2 | INT2 | 5 | 0 | |||
| QQSTTX | iSeries: Statement Text (Database Monitor) | QQSTTX | LCHR | 8000 | 0 | |||
| QQUSER | iSeries: Job User (Database Monitor) | QQUSER | CHAR | 10 | 0 | |||
