SQ1000_DB4 - iSeries: SQL Information (Database Monitor)
iSeries: SQL Information (Database Monitor) information is stored in SAP table SQ1000_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 SQ1000_DB4
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| SYSID | Name of SAP System | X | SYSYSID | CHAR | 8 | |
| IPLTIME | Text field length 14 | X | CHAR14 | CHAR | 14 | |
| QQKEY | iSeries: Key Field (Database Monitor) | X | QQKEY | CHAR | 17 | |
| QQTIME | iSeries: Record Creation Timestamp (Database Monitor) | QQTIME | CHAR | 26 | ||
| QQJOB | iSeries: Job Name (Database Monitor) | QQJOB | CHAR | 10 | ||
| QQUSER | iSeries: Job User (Database Monitor) | QQUSER | CHAR | 10 | ||
| QQJNUM | iSeries: Job Number (Database Monitor) | QQJNUM | CHAR | 6 | ||
| QQUDEF | iSeries: User-defined Field (Database Monitor) | QUDEF | CHAR | 18 | ||
| QQPLIB | iSeries: Package/Program Library (Database Monitor) | QQPLIB | CHAR | 10 | ||
| QQPNAM | iSeries: Package/Program Name (Database Monitor) | QQPNAM | CHAR | 10 | ||
| QQCNAM | iSeries: Cursor Name (Database Monitor) | QQCNAM | CHAR | 18 | ||
| QQSNAM | iSeries: Statement Name (Database Monitor) | QQSNAM | CHAR | 18 | ||
| QQCNT | iSeries: No. of Executions of a Statement (Database Monitor) | QQCNT | DEC | 8 | ||
| QQAVGT | iSeries: Average Time (Database Monitor) | QQAVGT | DEC | 8 | ||
| QQMINT | iSeries: Minimum Time (Database Monitor) | QQMINT | DEC | 8 | ||
| QQMAXT | iSeries: Maximum Time (Database Monitor) | QQMAXT | DEC | 8 | ||
| QQOPNT | iSeries: Open time (Database Monitor) | QQOPNT | DEC | 8 | ||
| QQFETT | iSeries: FETCH time (Database Monitor) | QQFETT | DEC | 8 | ||
| QQCLST | iSeries: CLOSE time (Database Monitor) | QQCLST | DEC | 8 | ||
| QQOTHT | iSeries: Any other time (Database Monitor) | QQOTHT | DEC | 8 | ||
| QQLTU | iSeries: Time Last Used (Database Monitor) | QQLTU | CHAR | 26 | ||
| QQMETU | iSeries: Timest. of Most Expensive Stmt. (Database Monitor) | QQMETU | CHAR | 26 | ||
| QQAPRT | iSeries: Timestamp of Access Plan Rebuild (Database Monitor) | QQAPRT | CHAR | 26 | ||
| QQFULO | iSeries: Number of FULL OPENs (Database Monitor) | QQFULO | DEC | 8 | ||
| QQPSUO | iSeries: Number of PSEUDO OPENs (Database Monitor) | QQPSUO | DEC | 8 | ||
| QQTOTR | iSeries: Total Rows in Table (Database Monitor) | QTOTR | DEC | 8 | ||
| QQRROW | iSeries: Result Rows (Database Monitor) | QQRROW | DEC | 8 | ||
| QQSTF | iSeries: Statement Function (Database Monitor) | QQSTF | CHAR | 1 | ||
| QQSTOP | iSeries: Statement Operation (Database Monitor) | QQSTOP | CHAR | 2 | ||
| QQODPI | iSeries: ODP Implementation (Database Monitor) | QQODPI | CHAR | 1 | ||
| QQHVI | iSeries: Host Variable Implementation (Database Monitor) | QQHVI | CHAR | 1 | ||
| QQAPR | iSeries: Reason Code for Access Plan Rebuild | QQAPR | CHAR | 4 | ||
| QQDACV | iSeries: Data Conversion (Database Monitor) | QQDACV | CHAR | 1 | ||
| QQCTS | iSeries: Number of Table Scans (Database Monitor) | QQCTS | DEC | 8 | ||
| QQCIU | iSeries: Index Usage (Database Monitor) | QQCIU | DEC | 8 | ||
| QQCIC | iSeries: Number of Index Creates (Database Monitor) | QQCIC | DEC | 8 | ||
| QQCSO | iSeries: No. of Sorts (Database Monitor) | QQCSO | DEC | 8 | ||
| QQCTF | iSeries: No. of Temporaray File Creates (Database Monitor) | QQCTF | DEC | 8 | ||
| QQCIA | iSeries: Index Advice (Database Monitor) | QQCIA | DEC | 8 | ||
| QQCAPR | iSeries: No of Access Plan Rebuilds (Database Monitor) | QQCAPR | DEC | 8 | ||
| QQARSS | iSeries: Average Result Set Size (Database Monitor) | QQARSS | DEC | 8 | ||
| 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 | ||
| TOTTIME | iSeries: Total Time (Database Monitor) | TOTTIME | DEC | 8 |