Specifies the DB2 optimization profile to be removed from the optimization profile cache. An optimization profile is processed the first time it is used to optimize a SQL statement, and the output is stored in the optimization profile cache. If the profile is modified after it is processed, its output should be removed from the optimization profile cache.
This property is only applicable to connections to DB2 V9.1 and higher for Linux/UNIX/Windows.
Valid Values
profile_name | all
where:
profile_name
is the name of a valid DB2 optimization profile.
Behavior
If set to profile_name, the driver removes the specified profile from the optimization profile cache.
If set to all, the driver removes all profiles from the optimization profile cache.
Notes
The user specifying this property must have administrator privileges to remove optimization profiles from the optimization profile cache. Consult with your system administrator.