Purpose

Specifies the DB2 optimization profile that is used during SQL optimization. The optimization profile contains optimization guidelines that are passed to DB2 to influence the generation of query plans. This property sets the value of the DB2 OPTIMIZATION PROFILE special register.

This property only applies to DB2 V9.1 and higher for Linux/UNIX/Windows.

Valid Values

profile_name

where:

profile_name
is the name of a valid DB2 optimization profile.

Default

null

Data Type

String

See also

Performance Considerations