ai_optimizer - AI Optimizer model usage control configuration parameter
The ai_optimizer configuration parameter controls the use of AI Optimizer models within the optimizer.
- Configuration type
- Database
- Parameter type
- Configurable online
- Propagation class
- Immediate
- Default [range]
- ON [ON; OFF]
By default, this parameter is set to ON for new databases and OFF for databases created before Db2 version 12.1.
Note: In Db2®
12.1.3 and
earlier, AI Optimizer model usage was controlled using the AUTO_AI_OPTIMIZER configuration
parameter. Databases running Db2
12.1.4
automatically default this parameter to the value of AUTO_AI_OPTIMIZER with respect to the
enablement of its parent parameters.