SAP Table DB4_SQ1000
iSeries: SQL Information (Database Monitor)
DB4_SQ1000 (iSeries: SQL Information (Database Monitor)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link DB4_SQ1000 to other SAP tables.
DB4_SQ1000 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| QQKEY | iSeries: Key Field (Database Monitor) | QQKEY | CHAR | 17 | 0 | |||||||||||||||
| QQTIME | iSeries: Record Creation Timestamp (Database Monitor) | QQTIME | CHAR | 26 | 0 | |||||||||||||||
| QQJOB | iSeries: Job Name (Database Monitor) | QQJOB | CHAR | 10 | 0 | |||||||||||||||
| QQUSER | iSeries: Job User (Database Monitor) | QQUSER | CHAR | 10 | 0 | |||||||||||||||
| QQJNUM | iSeries: Job Number (Database Monitor) | QQJNUM | CHAR | 6 | 0 | |||||||||||||||
| QQUDEF | iSeries: User-defined Field (Database Monitor) | QUDEF | CHAR | 18 | 0 | |||||||||||||||
| QQPLIB | iSeries: Package/Program Library (Database Monitor) | QQPLIB | CHAR | 10 | 0 | |||||||||||||||
| QQPNAM | iSeries: Package/Program Name (Database Monitor) | QQPNAM | CHAR | 10 | 0 | |||||||||||||||
| QQCNAM | iSeries: Cursor Name (Database Monitor) | QQCNAM | CHAR | 18 | 0 | |||||||||||||||
| QQSNAM | iSeries: Statement Name (Database Monitor) | QQSNAM | CHAR | 18 | 0 | |||||||||||||||
| QQCNT | iSeries: No. of Executions of a Statement (Database Monitor) | QQCNT | DEC | 15 | 0 | |||||||||||||||
| QQAVGT | iSeries: Average Time (Database Monitor) | QQAVGT | DEC | 15 | 0 | |||||||||||||||
| QQMINT | iSeries: Minimum Time (Database Monitor) | QQMINT | DEC | 15 | 0 | |||||||||||||||
| QQMAXT | iSeries: Maximum Time (Database Monitor) | QQMAXT | DEC | 15 | 0 | |||||||||||||||
| QQOPNT | iSeries: Open time (Database Monitor) | QQOPNT | DEC | 15 | 0 | |||||||||||||||
| QQFETT | iSeries: FETCH time (Database Monitor) | QQFETT | DEC | 15 | 0 | |||||||||||||||
| QQCLST | iSeries: CLOSE time (Database Monitor) | QQCLST | DEC | 15 | 0 | |||||||||||||||
| QQOTHT | iSeries: Any other time (Database Monitor) | QQOTHT | DEC | 15 | 0 | |||||||||||||||
| QQLTU | iSeries: Time Last Used (Database Monitor) | QQLTU | CHAR | 26 | 0 | |||||||||||||||
| QQMETU | iSeries: Timest. of Most Expensive Stmt. (Database Monitor) | QQMETU | CHAR | 26 | 0 | |||||||||||||||
| QQAPRT | iSeries: Timestamp of Access Plan Rebuild (Database Monitor) | QQAPRT | CHAR | 26 | 0 | |||||||||||||||
| QQFULO | iSeries: Number of FULL OPENs (Database Monitor) | QQFULO | DEC | 15 | 0 | |||||||||||||||
| QQPSUO | iSeries: Number of PSEUDO OPENs (Database Monitor) | QQPSUO | DEC | 15 | 0 | |||||||||||||||
| QQTOTR | iSeries: Total Rows in Table (Database Monitor) | QTOTR | DEC | 15 | 0 | |||||||||||||||
| QQRROW | iSeries: Result Rows (Database Monitor) | QQRROW | DEC | 15 | 0 | |||||||||||||||
| QQSTF | iSeries: Statement Function (Database Monitor) | QQSTF | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| QQSTOP | iSeries: Statement Operation (Database Monitor) | QQSTOP | CHAR | 2 | 0 | |||||||||||||||
| QQODPI | iSeries: ODP Implementation (Database Monitor) | QQODPI | CHAR | 1 | 0 | |||||||||||||||
| QQHVI | iSeries: Host Variable Implementation (Database Monitor) | QQHVI | CHAR | 1 | 0 | |||||||||||||||
| QQAPR | iSeries: Reason Code for Access Plan Rebuild | QQAPR | CHAR | 4 | 0 | |||||||||||||||
| QQDACV | iSeries: Data Conversion (Database Monitor) | QQDACV | CHAR | 1 | 0 | |||||||||||||||
| QQCTS | iSeries: Number of Table Scans (Database Monitor) | QQCTS | DEC | 15 | 0 | |||||||||||||||
| QQCIU | iSeries: Index Usage (Database Monitor) | QQCIU | DEC | 15 | 0 | |||||||||||||||
| QQCIC | iSeries: Number of Index Creates (Database Monitor) | QQCIC | DEC | 15 | 0 | |||||||||||||||
| QQCSO | iSeries: No. of Sorts (Database Monitor) | QQCSO | DEC | 15 | 0 | |||||||||||||||
| QQCTF | iSeries: No. of Temporaray File Creates (Database Monitor) | QQCTF | DEC | 15 | 0 | |||||||||||||||
| QQCIA | iSeries: Index Advice (Database Monitor) | QQCIA | DEC | 15 | 0 | |||||||||||||||
| QQCAPR | iSeries: No of Access Plan Rebuilds (Database Monitor) | QQCAPR | DEC | 15 | 0 | |||||||||||||||
| QQARSS | iSeries: Average Result Set Size (Database Monitor) | QQARSS | DEC | 15 | 0 | |||||||||||||||
| QQC11 | iSeries: Reserved Field (Database Monitor) | QQC11 | CHAR | 1 | 0 | |||||||||||||||
| QQC12 | iSeries: Reserved Field (Database Monitor) | QQC12 | CHAR | 1 | 0 | |||||||||||||||
| QQC21 | iSeries: Reserved Field (Database Monitor) | QQC21 | CHAR | 2 | 0 | |||||||||||||||
| QQC22 | iSeries: Reserved Field (Database Monitor) | QQC22 | CHAR | 2 | 0 | |||||||||||||||
| QQI1 | iSeries: Reserved Field (Database Monitor) | QQI1 | INT4 | 10 | 0 | |||||||||||||||
| QQI2 | iSeries: Reserved Field (Database Monitor) | QQI2 | INT4 | 10 | 0 | |||||||||||||||
| QQC301 | iSeries: Reserved Field (Database Monitor) | QQC301 | CHAR | 30 | 0 | |||||||||||||||
| QQC302 | iSeries: Reserved Field (Database Monitor) | QQC302 | CHAR | 30 | 0 | |||||||||||||||
| QQ1000 | CHAR | 1000 | 0 | |||||||||||||||||
