SAP ABAP Table DB4_SQ1000 (iSeries: SQL Information (Database Monitor))
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-DB4 (Application Component) DB2 for AS/400
⤷
STU4 (Package) CCMS / AS/400
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 | INTTAB | Structure |
| Structure | DB4_SQ1000 |
Table Relationship Diagram 
|
| Short Description | iSeries: SQL Information (Database Monitor) |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | ||
| 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 |  QQKEY |
QQKEY | QQKEY | CHAR | 17 | 0 | iSeries: Key Field (Database Monitor) | ||
| 2 | QQTIME |
QQTIME | QQTIME | CHAR | 26 | 0 | iSeries: Record Creation Timestamp (Database Monitor) | ||
| 3 | QQJOB |
QQJOB | QQJOB | CHAR | 10 | 0 | iSeries: Job Name (Database Monitor) | ||
| 4 | QQUSER |
QQUSER | QQUSER | CHAR | 10 | 0 | iSeries: Job User (Database Monitor) | ||
| 5 | QQJNUM |
QQJNUM | QQJNUM | CHAR | 6 | 0 | iSeries: Job Number (Database Monitor) | ||
| 6 | QQUDEF |
QUDEF | QQC18 | CHAR | 18 | 0 | iSeries: User-defined Field (Database Monitor) | ||
| 7 | QQPLIB |
QQPLIB | QQC10 | CHAR | 10 | 0 | iSeries: Package/Program Library (Database Monitor) | ||
| 8 | QQPNAM |
QQPNAM | QQC10 | CHAR | 10 | 0 | iSeries: Package/Program Name (Database Monitor) | ||
| 9 | QQCNAM |
QQCNAM | QQC18 | CHAR | 18 | 0 | iSeries: Cursor Name (Database Monitor) | ||
| 10 | QQSNAM |
QQSNAM | QQC18 | CHAR | 18 | 0 | iSeries: Statement Name (Database Monitor) | ||
| 11 | QQCNT |
QQCNT | QQDEC150 | DEC | 15 | 0 | iSeries: No. of Executions of a Statement (Database Monitor) | ||
| 12 | QQAVGT |
QQAVGT | QQDEC150 | DEC | 15 | 0 | iSeries: Average Time (Database Monitor) | ||
| 13 | QQMINT |
QQMINT | QQDEC150 | DEC | 15 | 0 | iSeries: Minimum Time (Database Monitor) | ||
| 14 | QQMAXT |
QQMAXT | QQDEC150 | DEC | 15 | 0 | iSeries: Maximum Time (Database Monitor) | ||
| 15 | QQOPNT |
QQOPNT | QQDEC150 | DEC | 15 | 0 | iSeries: Open time (Database Monitor) | ||
| 16 | QQFETT |
QQFETT | QQDEC150 | DEC | 15 | 0 | iSeries: FETCH time (Database Monitor) | ||
| 17 | QQCLST |
QQCLST | QQDEC150 | DEC | 15 | 0 | iSeries: CLOSE time (Database Monitor) | ||
| 18 | QQOTHT |
QQOTHT | QQDEC150 | DEC | 15 | 0 | iSeries: Any other time (Database Monitor) | ||
| 19 | QQLTU |
QQLTU | QQTIME | CHAR | 26 | 0 | iSeries: Time Last Used (Database Monitor) | ||
| 20 | QQMETU |
QQMETU | QQTIME | CHAR | 26 | 0 | iSeries: Timest. of Most Expensive Stmt. (Database Monitor) | ||
| 21 | QQAPRT |
QQAPRT | QQTIME | CHAR | 26 | 0 | iSeries: Timestamp of Access Plan Rebuild (Database Monitor) | ||
| 22 | QQFULO |
QQFULO | QQDEC150 | DEC | 15 | 0 | iSeries: Number of FULL OPENs (Database Monitor) | ||
| 23 | QQPSUO |
QQPSUO | QQDEC150 | DEC | 15 | 0 | iSeries: Number of PSEUDO OPENs (Database Monitor) | ||
| 24 | QQTOTR |
QTOTR | QQDEC150 | DEC | 15 | 0 | iSeries: Total Rows in Table (Database Monitor) | ||
| 25 | QQRROW |
QQRROW | QQDEC150 | DEC | 15 | 0 | iSeries: Result Rows (Database Monitor) | ||
| 26 | QQSTF |
QQSTF | QQSTF | CHAR | 1 | 0 | iSeries: Statement Function (Database Monitor) | ||
| 27 | QQSTOP |
QQSTOP | QQC21 | CHAR | 2 | 0 | iSeries: Statement Operation (Database Monitor) | ||
| 28 | QQODPI |
QQODPI | QQC11 | CHAR | 1 | 0 | iSeries: ODP Implementation (Database Monitor) | ||
| 29 | QQHVI |
QQHVI | QQC11 | CHAR | 1 | 0 | iSeries: Host Variable Implementation (Database Monitor) | ||
| 30 | QQAPR |
QQAPR | QQC41 | CHAR | 4 | 0 | iSeries: Reason Code for Access Plan Rebuild | ||
| 31 | QQDACV |
QQDACV | QQC11 | CHAR | 1 | 0 | iSeries: Data Conversion (Database Monitor) | ||
| 32 | QQCTS |
QQCTS | QQDEC150 | DEC | 15 | 0 | iSeries: Number of Table Scans (Database Monitor) | ||
| 33 | QQCIU |
QQCIU | QQDEC150 | DEC | 15 | 0 | iSeries: Index Usage (Database Monitor) | ||
| 34 | QQCIC |
QQCIC | QQDEC150 | DEC | 15 | 0 | iSeries: Number of Index Creates (Database Monitor) | ||
| 35 | QQCSO |
QQCSO | QQDEC150 | DEC | 15 | 0 | iSeries: No. of Sorts (Database Monitor) | ||
| 36 | QQCTF |
QQCTF | QQDEC150 | DEC | 15 | 0 | iSeries: No. of Temporaray File Creates (Database Monitor) | ||
| 37 | QQCIA |
QQCIA | QQDEC150 | DEC | 15 | 0 | iSeries: Index Advice (Database Monitor) | ||
| 38 | QQCAPR |
QQCAPR | QQDEC150 | DEC | 15 | 0 | iSeries: No of Access Plan Rebuilds (Database Monitor) | ||
| 39 | QQARSS |
QQARSS | QQDEC150 | DEC | 15 | 0 | iSeries: Average Result Set Size (Database Monitor) | ||
| 40 | QQC11 |
QQC11 | QQC11 | CHAR | 1 | 0 | iSeries: Reserved Field (Database Monitor) | ||
| 41 | QQC12 |
QQC12 | QQC12 | CHAR | 1 | 0 | iSeries: Reserved Field (Database Monitor) | ||
| 42 | QQC21 |
QQC21 | QQC21 | CHAR | 2 | 0 | iSeries: Reserved Field (Database Monitor) | ||
| 43 | QQC22 |
QQC22 | QQC22 | CHAR | 2 | 0 | iSeries: Reserved Field (Database Monitor) | ||
| 44 | QQI1 |
QQI1 | QQI1 | INT4 | 10 | 0 | iSeries: Reserved Field (Database Monitor) | ||
| 45 | QQI2 |
QQI2 | QQI2 | INT4 | 10 | 0 | iSeries: Reserved Field (Database Monitor) | ||
| 46 | QQC301 |
QQC301 | QQC301 | CHAR | 30 | 0 | iSeries: Reserved Field (Database Monitor) | ||
| 47 | QQC302 |
QQC302 | CHAR | 30 | 0 | iSeries: Reserved Field (Database Monitor) | |||
| 48 | QQ1000 |
CHAR | 1000 | 0 |
History
| Last changed by/on | SAP | 20070813 |
| SAP Release Created in | 640 |
