DB2Optimization CLI/ODBC and IBM data server driver configuration keyword

Sets the query optimization level.

db2cli.ini keyword syntax:
DB2Optimization = integer value from 0 to 9
IBM® data server driver configuration file (db2dsdriver.cfg) syntax:
<parameter name="DB2Optimization" value="integer value from 0 to 9"/>
Attention: The IBM data server driver configuration file (db2dsdriver.cfg) syntax is available in Db2 11.5.4 and later.
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.