DB2 Version 9.7 for Linux, UNIX, and Windows

CURRENTOPTIMIZATIONPROFILE CLI/ODBC configuration keyword

Specifies the optimization profile used in a SET CURRENT OPTIMIZATION PROFILE statement upon a successful connection.

db2cli.ini keyword syntax:

CURRENTOPTIMIZATIONPROFILE =NULL│optimization-profile-name

Default setting:

NULL

Usage notes:

NULL: Sets the register to the null value.
optimization-profile-name: Sets the CURRENT OPTIMIZATION PROFILE special register to the name of an optimization profile. If optimization-profile-name is unqualified, then the default schema qualification is applied.

Examples

If a DB2CLI.INI file has the following entry, after each successful connection to the "Rochester" database, the CLI client would issue the command SET CURRENT OPTIMIZATION PROFILE = '"Hamid"."RochesterProfile"'.

   [Rochester] 
   CURRENTOPTIMIZATIONPROFILE='"Hamid"."RochesterProfile"'

In this example, the optimization profile name is delimited by quotation marks because it contains lower case characters.