Enabling non-case-sensitive search capability

The automatic upgrade process does not include an option to enable non-case-sensitive search for DB2®. If you want to have the ability to do non-case-sensitive search, you can manually enable the capability after you have finished the automatic upgrade.


  1. Navigate to the MDM_INSTALL_HOME/database/Full/DB2/Standard/ddl directory.
  2. Run the following script: db2 -tvf Insensitive_search_enabled.sql -l <log_file_name>