SAP ABAP Table SQ3007_DB4 (iSeries: Optimizer Timed Out (Database Monitor))
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-DB4 (Application Component) DB2 for AS/400
⤷
STU4 (Package) CCMS / AS/400
⤷
⤷
Basic Data
| Table Category | TRANSP | Transparent table |
| Transparent table | SQ3007_DB4 |
|
| Short Description | iSeries: Optimizer Timed Out (Database Monitor) |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | L | Table for storing temporary data, delivered empty |
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
| |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 | |
SYSYSID | SYCHAR08 | CHAR | 8 | 0 | Name of SAP System | SQ1000_DB4 | |
| 2 | |
CHAR14 | CHAR14 | CHAR | 14 | 0 | Text field length 14 | ||
| 3 | |
QQKEY | QQKEY | CHAR | 17 | 0 | iSeries: Key Field (Database Monitor) | ||
| 4 | |
QQKEY2 | QQDEC150 | DEC | 15 | 0 | iSeries: 2nd Key Field of Database Monitor Files | ||
| 5 | |
QQTIME | QQTIME | CHAR | 26 | 0 | iSeries: Record Creation Timestamp (Database Monitor) | ||
| 6 | |
QQDTN | QQDEC150 | DEC | 15 | 0 | iSeries: Query Definition Template Number | ||
| 7 | |
QQDTL | QQDEC150 | DEC | 15 | 0 | iSeries: Query Definition Template Level | ||
| 8 | |
QMATN | QQDEC150 | DEC | 15 | 0 | iSeries: Mat. QDT Number (Database Monitor) | ||
| 9 | |
QMATL | QQDEC150 | DEC | 15 | 0 | iSeries: Mat. QDT Level (Database Monitor) | ||
| 10 | |
QQTLN | QQTLN | CHAR | 10 | 0 | iSeries: System Name of Library (Database Monitor) | ||
| 11 | |
QTFN | AS4TAB | CHAR | 30 | 0 | iSeries: System Name of Table (Database Monitor) | * | |
| 12 | |
QQPTLN | QQTLN | CHAR | 10 | 0 | iSeries: System Name of Base Library (Database Monitor) | ||
| 13 | |
QPTFN | AS4TAB | CHAR | 30 | 0 | iSeries: System Name of Base Table (Database Monitor) | * | |
| 14 | |
QQTOUT | QQC11 | CHAR | 1 | 0 | iSeries: Timeout (Database Monitor) | ||
| 15 | |
QQIRSN | QQC301 | CHAR | 30 | 0 | iSeries: Index Reason Code (Database Monitor) | ||
| 16 | |
QQLTLN | CHAR | 128 | 0 | iSeries: Library Name (Database Monitor) | |||
| 17 | |
QQLTFN | CHAR | 128 | 0 | iSeries: Table Name (Database Monitor) | |||
| 18 | |
QQLPTL | CHAR | 128 | 0 | iSeries: Base Library (Database Monitor) | |||
| 19 | |
QQLPTF | CHAR | 128 | 0 | iSeries: Base Table (Database Monitor) | |||
| 20 | |
QQC11 | QQC11 | CHAR | 1 | 0 | iSeries: Reserved Field (Database Monitor) | ||
| 21 | |
QQC12 | QQC12 | CHAR | 1 | 0 | iSeries: Reserved Field (Database Monitor) | ||
| 22 | |
QQC21 | QQC21 | CHAR | 2 | 0 | iSeries: Reserved Field (Database Monitor) | ||
| 23 | |
QQC22 | QQC22 | CHAR | 2 | 0 | iSeries: Reserved Field (Database Monitor) | ||
| 24 | |
QQI1 | QQI1 | INT4 | 10 | 0 | iSeries: Reserved Field (Database Monitor) | ||
| 25 | |
QQI2 | QQI2 | INT4 | 10 | 0 | iSeries: Reserved Field (Database Monitor) | ||
| 26 | |
QQC301 | QQC301 | CHAR | 30 | 0 | iSeries: Reserved Field (Database Monitor) | ||
| 27 | |
QQC302 | CHAR | 30 | 0 | iSeries: Reserved Field (Database Monitor) | |||
| 28 | |
QQ1000 | CHAR | 255 | 0 | iSeries: Reserved Field (Database Monitor) | |||
| 29 | |
INT2 | INT2 | INT2 | 5 | 0 | 2 byte integer (signed) | ||
| 30 | |
QQIDXN | QQCHAR1000 | LCHR | 1000 | 0 | iSeries: Indexes (Database Monitor) |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
| 1 | SQ3007_DB4 | SYSID | |
|
History
| Last changed by/on | SAP | 20130604 |
| SAP Release Created in |