SAP ABAP Data Element QQKEY (iSeries: Key Field (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
| Data Element | QQKEY |
| Short Description | iSeries: Key Field (Database Monitor) |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | QQKEY | |
| Data Type | CHAR | Character String |
| Length | 17 | |
| Decimal Places | 0 | |
| Output Length | 17 | |
| Value Table |
Further Characteristics
| Search Help: Name | ||
| Search Help: Parameters | ||
| Parameter ID | ||
| Default Component name | ||
| Change document | ||
| No Input History | ||
| Basic direction is set to LTR | ||
| No BIDI Filtering |
Field Label
| Length | Field Label | |
| Short | 11 | Key |
| Medium | 21 | Key Field |
| Long | 41 | Key Field (Database Monitor) |
| Heading | 55 | Key Field (Database Monitor) |
Documentation
Definition
QQKEY is the unique identification of a set of statistics about the execution of a statement recorded by the memory-resident database monitor.
Use
These statistics are spread over several tables: SQ1000_DB4, SQTEXT_DB4, SQHVAR_DB4, SQ3000_DB4, SQ3001_DB4, SQ3002_DB4, SQ3003_DB4, SQ3004_DB4, SQ3007_DB4, SQ3008_DB4.
By joining these tables with qqkey, the database performance statistics of each recorded statement are obtained.
Technical information
QQKEY is a concatenation of the system name (10 bytes), a key hash value (2 bytes; a hash value of the statement) and a key collating sequence (7 bytes; sequence number for hash collision).
History
| Last changed by/on | SAP | 20070813 |
| SAP Release Created in |
