DB2 Version 9.7 for Linux, UNIX, and Windows

DB2Optimization CLI/ODBC configuration keyword

Sets the query optimization level.

db2cli.ini keyword syntax:
DB2Optimization = integer value from 0 to 9
Default setting:
No SET CURRENT QUERY OPTIMIZATION statement issued.
Usage notes:
 
If this option is set then CLI will issue the following SQL statement after a successful connection: 
 
SET CURRENT QUERY OPTIMIZATION positive number

This specifies the query optimization level at which the optimizer should operate the SQL queries.

Parent topic: CLI/ODBC configuration keywords listing by category
Related reference:
CLI/ODBC configuration keywords listing by category
SET CURRENT QUERY OPTIMIZATION statement
Related information:
QueryOptimizationLevel IBM Data Server Driver configuration keyword