SQ3001_DB4 - iSeries: Used Indexes (Database Monitor)
iSeries: Used Indexes (Database Monitor) information is stored in SAP table SQ3001_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 SQ3001_DB4
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
SYSID | Name of SAP System | X | SYSYSID | CHAR | 16 | SQ1000_DB4 |
IPLTIME | Text field length 14 | X | CHAR14 | CHAR | 28 | |
QQKEY | iSeries: Key Field (Database Monitor) | X | QQKEY | CHAR | 34 | |
QQKEY2 | iSeries: 2nd Key Field of Database Monitor Files | X | QQKEY2 | DEC | 8 | |
QQTIME | iSeries: Record Creation Timestamp (Database Monitor) | QQTIME | CHAR | 52 | ||
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 | 20 | ||
QQTFN | iSeries: System Name of Table (Database Monitor) | QTFN | CHAR | 60 | ||
QQPTLN | iSeries: System Name of Base Library (Database Monitor) | QQPTLN | CHAR | 20 | ||
QQPTFN | iSeries: System Name of Base Table (Database Monitor) | QPTFN | CHAR | 60 | ||
QQILNM | iSeries: System Name of Index Library (Database Monitor) | QQILNM | CHAR | 20 | ||
QQIFNM | iSeries: System Name of Index (Database Monitor) | QIFNM | CHAR | 80 | ||
QQTOTR | iSeries: Total Rows in Table (Database Monitor) | QTOTR | DEC | 8 | ||
QQREST | iSeries: Estimated No. of Selected Rows (Database Monitor) | QREST | DEC | 8 | ||
QQFKEY | iSeries: Estimated Rows Returned by Key Positioning | QFKEY | DEC | 8 | ||
QQKSEL | iSeries: Estimated Rows Returned by Key Selection | QKSEL | DEC | 8 | ||
QQAJN | iSeries: Estimated Number of Joined Rows (Database Monitor) | QAJN | DEC | 8 | ||
QQEPT | iSeries: Estimated Processing Time (Database Monitor) | QEPT | DEC | 8 | ||
QQJNP | iSeries: Join Position (Database Monitor) | QJNP | DEC | 8 | ||
QQJNDS | iSeries: Dataspace Number (Database Monitor) | QQJNDS | DEC | 8 | ||
QQJNMT | iSeries: Join Method (Database Monitor) | QQJNMT | CHAR | 4 | ||
QQJNTY | iSeries: Join Type (Database Monitor) | QQJNTY | CHAR | 4 | ||
QQJNOP | iSeries: Join Operator (Database Monitor) | QQJNOP | CHAR | 4 | ||
QQIDXK | iSeries: No. of Key Fields of Advised Index | QQIDXK | DEC | 8 | ||
QQKP | iSeries: Key Positioning (Database Monitor) | QQKP | CHAR | 2 | ||
QQKPN | iSeries: No. of Key Positioning Keys (Database Monitor) | QQKPN | DEC | 8 | ||
QQKS | iSeries: Key Selection (Database Monitor) | QQKS | CHAR | 2 | ||
QQDSS | iSeries: Dataspace Selection (Database Monitor) | QQDSS | CHAR | 2 | ||
QQIDXA | iSeries: Optimizer Advised Index (Database Monitor) | QQIDXA | CHAR | 2 | ||
QQRCOD | iSeries: Reason Code for Used Index (Database Monitor) | QQRCODIDU | CHAR | 4 | ||
QQCST | iSeries: Constraint Used (Y/N) (Database Monitor) | QQCST | CHAR | 2 | ||
QQCSTN | iSeries: Constraint Name (Database Monitor) | QQCSTN | CHAR | 80 | ||
QQLTLN | iSeries: Library Name (Database Monitor) | QQLTLN | CHAR | 256 | ||
QQLTFN | iSeries: Table Name (Database Monitor) | QQLTFN | CHAR | 256 | ||
QQLPTL | iSeries: Base Library (Database Monitor) | QQLPTL | CHAR | 256 | ||
QQLPTF | iSeries: Base Table (Database Monitor) | QQLPTF | CHAR | 256 | ||
QQLILN | iSeries: Index Library (Database Monitor) | QQLILN | CHAR | 256 | ||
QQLIFN | iSeries: Index Name (Database Monitor) | QQLIFN | CHAR | 256 | ||
QQC11 | iSeries: Reserved Field (Database Monitor) | QQC11 | CHAR | 2 | ||
QQC12 | iSeries: Reserved Field (Database Monitor) | QQC12 | CHAR | 2 | ||
QQC21 | iSeries: Reserved Field (Database Monitor) | QQC21 | CHAR | 4 | ||
QQC22 | iSeries: Reserved Field (Database Monitor) | QQC22 | CHAR | 4 | ||
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 | 60 | ||
QQC302 | iSeries: Reserved Field (Database Monitor) | QQC302 | CHAR | 60 | ||
QQ1000 | iSeries: Reserved Field (Database Monitor) | QQ1000 | CHAR | 510 | ||
QQIDXD_LEN | 2 Byte Signed Integer | INT2 | INT2 | 2 | ||
QQIDXD | iSeries: Definition of Advised Index (Database Monitor) | QIDXD | LCHR | 2000 |