KD2_PFnn_HIS_DYN_SQL
The KD2_PFnn_HIS_DYN_SQL parameter specifies whether to collect dynamic SQL data.
- Valid values
-
This specifies whether dynamic SQL text and access path information is collected.
Y: the collector activates IFCIDs 22, 63, 105, and 107.
F: the collector activates IFCIDs 22, 350, 105, and 107. IFCID 350 records the complete text of a parsed SQL statement, while IFCID 63 is limited to the first 5000 bytes of a SQL statement.
- Required or optional
- Optional (Required if KD2_PF_HIS_START is set to Y.)
- Default value
- N
- Valid values
- Y, N, F
- Locations where the parameter value is stored
-
- Location 1
- In the DB2PROF member of the %RTE_HILEV%.%RTE_NAME%.RKD2PRF library
- Output line
-
DB2_DSNTIAD=<value>NTIA
- Location 2
- In the COPTssid member of the %RTE_HILEV%.%RTE_NAME%.RKD2PAR library
- Output line
-
DYNAMICSQL(<value>Y)
- PARMGEN name
- KD2_PFnn_HIS_DYN_SQL
- PARMGEN classification
- NTH