KD2_PFnn_TRACES_318

Start IFCID 318

Description

Used to specify whether a start trace command should be issued for IFCID 318. IFCID 318 is a flag IFCID that causes Db2 to collect detailed information on SQL statements in the dynamic statement cache. The collected information is externalized by means of IFCID 316. The default is N.

Required or optional
Required
Default value
N
Permissible values
Y, N
Location where the parameter value is stored
This value is not stored in a configuration member.
In the Configuration Tool (ICAT)
Panel name
Start Additional DB2 Traces
Panel ID
KD2PTRAC
Panel field
IFCID 318 (Dynamic SQL statement cache)
Default value
N
Permissible values
Y, N
Batch parameter name
KD2_PF_TRACES_318
PARMGEN name
KD2_PFnn_TRACES_318
PARMGEN classification
DB2