Purpose

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.

Default

null

Data Type

String

See also

Performance Considerations