KD2_PF_HIS_DYN_SQL
The KD2_PF_HIS_DYN_SQL parameter specifies whether to collect SQL text data.
- Description
-
This parameter specifies whether dynamic SQL text and access path information are collected.
If Y is specified, the collector activates IFCIDs 22, 63, 105, and 107.
If F is specified, 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.
- Default value
- N
- Permissible values
- Y, N, F