Upgrading Query Optimizer

You can upgrade an active Query Optimizer in an existing IBM® watsonx.data instance.

About this task

Upgrade Query Optimizer in watsonx.data by using the following steps:

Procedure

  1. Upgrade your existing version of watsonx.data to any latest watsonx.data version. See Upgrading watsonx.data.
  2. From the navigation menu, select Configurations and click Query Optimizer Manager tile.
  3. Click Deactivate. A Deactivate query optimizer window displays. Click Deactivate and restart engines. See Deactivating Query Optimizer
  4. Activate Query Optimizer to upgrade to the latest version of Query Optimizer. See Activating Query Optimizer in IBM watsonx.data version 2.0.1 and later.
  5. Run the following pass through command to verify Query Optimizer version (Db2 build level) is updated to the latest version. 
    ExecuteWxdQueryOptimizer 'select service_level,
release_num,
ptf
from  sysibmadm.ENV_INST_INFO' ;