SQ3007_DB4 - iSeries: Optimizer Timed Out (Database Monitor)
iSeries: Optimizer Timed Out (Database Monitor) information is stored in SAP table SQ3007_DB4.
It is part of development package STU4 in software component BC-DB-DB4. This development package consists of objects that can be grouped under "CCMS / AS/400".
It is part of development package STU4 in software component BC-DB-DB4. This development package consists of objects that can be grouped under "CCMS / AS/400".
Fields for table SQ3007_DB4
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| SYSID | Name of SAP System | X | SYSYSID | CHAR | 8 | SQ1000_DB4 |
| IPLTIME | Text field length 14 | X | CHAR14 | CHAR | 14 | |
| QQKEY | iSeries: Key Field (Database Monitor) | X | QQKEY | CHAR | 17 | |
| QQKEY2 | iSeries: 2nd Key Field of Database Monitor Files | X | QQKEY2 | DEC | 8 | |
| QQTIME | iSeries: Record Creation Timestamp (Database Monitor) | QQTIME | CHAR | 26 | ||
| QQQDTN | iSeries: Query Definition Template Number | QQDTN | DEC | 8 | ||
| QQQDTL | iSeries: Query Definition Template Level | QQDTL | DEC | 8 | ||
| QQMATN | iSeries: Mat. QDT Number (Database Monitor) | QMATN | DEC | 8 | ||
| QQMATL | iSeries: Mat. QDT Level (Database Monitor) | QMATL | DEC | 8 | ||
| QQTLN | iSeries: System Name of Library (Database Monitor) | QQTLN | CHAR | 10 | ||
| QQTFN | iSeries: System Name of Table (Database Monitor) | QTFN | CHAR | 30 | * | |
| QQPTLN | iSeries: System Name of Base Library (Database Monitor) | QQPTLN | CHAR | 10 | ||
| QQPTFN | iSeries: System Name of Base Table (Database Monitor) | QPTFN | CHAR | 30 | * | |
| QQTOUT | iSeries: Timeout (Database Monitor) | QQTOUT | CHAR | 1 | ||
| QQIRSN | iSeries: Index Reason Code (Database Monitor) | QQIRSN | CHAR | 30 | ||
| QQLTLN | iSeries: Library Name (Database Monitor) | QQLTLN | CHAR | 128 | ||
| QQLTFN | iSeries: Table Name (Database Monitor) | QQLTFN | CHAR | 128 | ||
| QQLPTL | iSeries: Base Library (Database Monitor) | QQLPTL | CHAR | 128 | ||
| QQLPTF | iSeries: Base Table (Database Monitor) | QQLPTF | CHAR | 128 | ||
| QQC11 | iSeries: Reserved Field (Database Monitor) | QQC11 | CHAR | 1 | ||
| QQC12 | iSeries: Reserved Field (Database Monitor) | QQC12 | CHAR | 1 | ||
| QQC21 | iSeries: Reserved Field (Database Monitor) | QQC21 | CHAR | 2 | ||
| QQC22 | iSeries: Reserved Field (Database Monitor) | QQC22 | CHAR | 2 | ||
| QQI1 | iSeries: Reserved Field (Database Monitor) | QQI1 | INT4 | 4 | ||
| QQI2 | iSeries: Reserved Field (Database Monitor) | QQI2 | INT4 | 4 | ||
| QQC301 | iSeries: Reserved Field (Database Monitor) | QQC301 | CHAR | 30 | ||
| QQC302 | iSeries: Reserved Field (Database Monitor) | QQC302 | CHAR | 30 | ||
| QQ1000 | iSeries: Reserved Field (Database Monitor) | QQ1000 | CHAR | 255 | ||
| QQIDXN_LEN | 2 Byte Signed Integer | INT2 | INT2 | 2 | ||
| QQIDXN | iSeries: Indexes (Database Monitor) | QQIDXN | LCHR | 1000 |