KD2_PFnn_HIS_NEQSQL
Negative SQL option
- Description
-
Specifies whether or not the number of SQL calls executed by a thread which resulted in a negative return code is collected. If Y is entered, the collector activates IFCIDs 58,59,60,61,62,64,65 and 66 to the DB2 START TRACE PERFORMANCE command.
- Required or optional
- Optional (Required in case KD2_PF_HIS_START is set to Y)
- Default value
- N
- Permissible values
- Y, N
- Location where the parameter value is stored
- In the COPTssid member of the rhilev.midlev.rtename.RKD2PAR library
- Output line
-
NEGSQL(<value>Y)
- In the Configuration Tool (ICAT)
-
- Panel name
- Near-Term History
- Panel ID
- KD261PB
- Panel field
- Negative SQL
- Default value
- N
- Permissible values
- Y, N
- Batch parameter name
- KD2_PF_HIS_NEQSQL
- PARMGEN name
- KD2_PFnn_HIS_NEQSQL
- PARMGEN classification
- NTH