KD2_PFnn_THRDHIS_DYN_SQL
Collect dynamic SQL data
- Description
-
This specifies whether dynamic SQL text and access path information is collected.
If Y is entered, the collector activates IFCIDs 22,63,105,107.
If F is entered, the collector activates IFCIDs 22,350,105,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 in case KD2_PF_HIS_START is set to Y)
- Default value
- N
- Permissible values
- Y, N, F
- Location where the parameter value is stored
- In the COPTssid member of the %RTE_HILEV%.%RTE_NAME%.RKD2PAR library
- Output line
-
THRDSQL(<value>Y)
- PARMGEN name
- KD2_PFnn_THRDHIS_DYN_SQL
- PARMGEN classification
- NTH