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.
Procedure
- Navigate to the MDM_INSTALL_HOME/database/Full/DB2/Standard/ddl directory.
- Run the following script: db2 -tvf Insensitive_search_enabled.sql -l <log_file_name>