SQ3003_DB4 - iSeries: Sorts (Database Monitor)
iSeries: Sorts (Database Monitor) information is stored in SAP table SQ3003_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 SQ3003_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 | ||
QQTTIM | iSeries: Sort Time (Database Monitor) | QQTTIM_SRT | DEC | 8 | ||
QQRSS | iSeries: Number of Rows Sorted (Database Monitor) | QRSS | DEC | 8 | ||
QQSSIZ | iSeries: Sort Size (Database Monitor) | QQSSIZ | DEC | 8 | ||
QQPSIZ | iSeries: Pool Size (Database Monitor) | QQPSIZ | DEC | 8 | ||
QQPID | iSeries: Pool ID (Database Monitor) | QQPID | DEC | 8 | ||
QQIBUF | iSeries: Internal Buffer (Database Monitor) | QQIBUF | DEC | 8 | ||
QQEBUF | iSeries: External Buffer (Database Monitor) | QQEBUF | DEC | 8 | ||
QQRCOD | iSeries: Reason Code (Database Monitor) | QQRCODSRT | CHAR | 2 | ||
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 |