SAP ABAP Data Element QQKEY2 (iSeries: 2nd Key Field of Database Monitor Files)

Hierarchy

☛ 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	QQKEY2
Short Description	iSeries: 2nd Key Field of Database Monitor Files

Data Type

Category of Dictionary Type	D	Domain
Type of Object Referenced		No Information
Domain / Name of Reference Type	QQDEC150
Data Type	DEC	Counter or amount field with comma and sign
Length	15
Decimal Places	0
Output Length	19
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	2nd Keyf.
Medium	21	2nd Key Field DBMon.
Long	41	2nd Key Field of Database Monitor
Heading	55	2nd Key Field of Database Monitor

Documentation

Definition

QQKEY2 is the identification of a specific part of the set of statistics about the execution of a statement recorded by the memory-resident database monitor.
The set of statistics is identified by QQKEY.

Use

QQKEY2 is only used in the performance tables SQ3000_DB4, SQ3001_DB4, SQ3002_DB4, SQ3003_DB4, SQ3004_DB4, SQ3007_DB4, SQ3008_DB4.

Example

SQ3001_DB4 contains information about index usage. For one index used to perform one part of a statement, there can be several records in SQ3001_DB4.
A complex statement is split into several parts by the opitmizer. For each of these parts multiple records can exist.

Technical information

QQKEY2 is an artifical key created because no other combination of fields exist that would guarantee uniqueness.

History

Last changed by/on	SAP	20070813
SAP Release Created in