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 | QQJFLD |
| Short Description | Join field |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | QQJFLD | |
| Data Type | RAW | Uninterpreted sequence of bytes |
| Length | 46 | |
| Decimal Places | 0 | |
| Output Length | 46 | |
| 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 | 10 | Join field |
| Medium | 10 | Join field |
| Long | 10 | Join field |
| Heading | 10 | Join field |
Documentation
Definition
QQJFLD is the unique identification of the iSeries job within which the query was run, for which the database monitor information is stored.
This field contains the name of the iSeries, the iSeries job ID (job name/job user/job number) and some other related information.
In combination with the fields QQUCNT and QQRCNT (QQI5), each query run is identified uniquely.
Use
For one query, a lot of data is available in multiple records in QAQQPRF. By using the QQQ views over QAQQPRF and joining these by fields QQJFLD and QQUCNT or QQJFLD, QQUCNT and QQRCNT, all of this data can be obtained.
Example
The native SQL statement
select a.qqtln, a.qqtfn, a.qqidxa, b.qqsttx
from lib_name/qqq3000 a, lib_name/qqq1000 b
where a.qqjfld = b.qqjfld and a.qqucnt = b.qqucnt
(lib_name is the library name of the SAP System)
lists for all queries where the optimizer chose to perform a table scan the file specified in the query (qqtln/ qqtfn), Yes or No for index advised and the statement text.
History
| Last changed by/on | SAP | 20070813 |
| SAP Release Created in |
