Hierarchy
⤷ BC-DB-DB4 (Application Component) DB2 for AS/400
⤷ STU4 (Package) CCMS / AS/400
Basic Data
Data Element | QQDSS |
Short Description | iSeries: Dataspace Selection (Database Monitor) |
Data Type
Category of Dictionary Type | D | Domain |
Type of Object Referenced | No Information | |
Domain / Name of Reference Type | QQYN | |
Data Type | CHAR | Character String |
Length | 1 | |
Decimal Places | 0 | |
Output Length | 1 | |
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 | Datasp.Sel |
Medium | 21 | Dataspace Selection |
Long | 41 | Dataspace Selection |
Heading | 55 | Dataspace Selection |
Documentation
Definition
QQDSS indicates if a dataspace selection was performed.
Y = Dataspace selection performed
N = No dataspace selection performed
Note
For the conventional database monitor (STRDBMON/ENDDBMON), QQDSS is only available for records with QQRID 3000, 3001, and 3002.
For the memory-based SQL database monitor QQDSS is only available in the detail information tables SQ3000_DB4, SQ3001_DB4 and SQ3002_DB4.
Note
When the optimizer chooses to perform a table scan, this can be done in different ways:
1. Intermediate buffer selection (QDSS = N)
All fields selected are mapped to an internal buffer performing all derived operations. Then all field values are copied to the internal buffer while evaluating the selection criteria. If the selection criteria is fullfilled, the values are copied to the user's answer buffer.
2. Dataspace element selection (QDSS = Y)
Record-by-record access directly in the dataspace - without using an internal buffer - by an internal code to evaluate the the selection criteria.
History
Last changed by/on | SAP | 20070813 |
SAP Release Created in |