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 | QQRID |
| Short Description | Record ID |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | QQRID | |
| Data Type | INT4 | 4-byte integer, integer number with sign |
| Length | 10 | |
| Decimal Places | 0 | |
| Output Length | 10 | |
| 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 | 9 | Record ID |
| Medium | 9 | Record ID |
| Long | 9 | Record ID |
| Heading | 9 | Record ID |
Documentation
Definition
Record identification number: identification of the information type that the database monitor has stored in a QAQQPRF record.
The File QAQQPRF:
The same information obtainable using the debug mode of interactive SQL on the iSeries - plus some additional information - should be obtainable using the database monitor.
Depending on the SQL statement that is to be executed, the optimizer has to perform different types of steps (for example, creating a temporary index, using an existing index, performing a sort). For each step that is performed, information is obtainable. All these different types of information are stored into QAQQPRF using the QQRID to identify the type of information. As a result, several records with different QQRIDs can exist for one SQL query.
A record with QQRID 1000 exists for all SQL queries. The record IDs of other records depend on the SQL statement.
To provide easier access to the information, special views are defined depending on the Record ID (for example, view QQQ1000, Q3000).
Use
QQRID Definition
1000 Summary Record for SQL information
3000 Summary Record for Arrival Sequence
3001 Summary Record for Using Existing Index
3002 Summary Record for Index Created
3003 Summary Record for Query Sort
3004 Summary Record for Temporary File
3005 Summary Record for Table locked
3006 Summary Record for Access Plan Rebuilt
3007 Summary Record for Optimizer Timed Out
3008 Summary Record for Subquery Processing
3010 Summary Record for Host Variable Implementation
3014 Summary Record for Generic Query Information
3018 Summary Record for STRDBMON/ENDDBMON
History
| Last changed by/on | SAP | 20070813 |
| SAP Release Created in |
