KD2_PFnn_SH_D2SHSQLT
Thread data including statement text
- Description
-
Used to specify whether thread data collected for Snapshot history is to include SQL statement text.
- Required or optional
- Optional (Required in case KD2_PF_SH_D2SHKHST is set to Y and KD2_PF_SH_D2SHTHDD is set to Y)
- Default value
- N
- Permissible values
- Y, N
- Location where the parameter value is stored
- In the OMPEssid member of the rhilev.midlev.rtename.RKD2PAR library
- Output line
-
SHTHREADSQL=<value>
- In the Configuration Tool (ICAT)
-
- Panel name
- Snapshot History
- Panel ID
- KD261PE
- Panel field
- Thread Include Stmt Text
- Default value
- N
- Permissible values
- Y, N
- Batch parameter name
- KD2_PF_SH_D2SHSQLT
- PARMGEN name
- KD2_PFnn_SH_D2SHSQLT
- PARMGEN classification
- SS_HIS