CURRENTOPTIMIZATIONPROFILE CLI/ODBC and IBM data server driver 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
- IBM data server driver configuration file (db2dsdriver.cfg) syntax:
- <parameter name="CURRENTOPTIMIZATIONPROFILE" value="NULL │optimization-profile-name"/>
Attention: The IBM data server
driver configuration
file (db2dsdriver.cfg) syntax is available in Db2 11.5.4 and later.
- 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 lowercase characters.