Running the Case Insensitivity Wizard Multiple Times

You can run the Case Insensitivity Wizard multiple times. Typically, you would do this to tune the CIAI configuration of columns. If you have already run the Case Insensitivity Wizard once to configure columns, then you might run it again to perform additional tasks. The following table lists operations that you can perform when running the Case Insensitivity Wizard again:

Task	How to Run the Case Insensitivity Wizard
Configure new columns to support CIAI queries.	You can use either an input file, or you can select files manually.
Inactivate CIAI configuration for specified columns.	Run the Case Insensitivity Wizard using an input file that specifies the desired columns. For each column, specify Operation indicates Off.
Run the Case Insensitivity Wizard to change the Default Insensitivity property from None to DB Case & Accent for eligible columns without indexes.	Start the Case Insensitivity Wizard from the Case Insensitivity menu (navigate to Tools, Utilities, then Case Insensitivity) and select the mode Enable for all unindexed columns.
For columns already configured, change the method from Force Case to Database.	You can use either an input file, or you can select files manually.
For columns already configured, change the method from Database to Force Case.	Run the Case Insensitivity Wizard using an input file that specifies the desired columns. For each column, specify Operation indicates Off. This deactivates the CIAI column and CIAI indexes. Verify that the base columns have the Force Case property set.
For columns already configured, change the index strategy from Single to Copy All.	Run the Case Insensitivity Wizard with an input file that specifies this change.
For columns already configured, change the index strategy from Copy All to Single.	Run the Case Insensitivity Wizard using an input file that specifies the desired columns. For each column, specify Operation indicates Off. This deactivates the CIAI column and CIAI indexes. Then run the Case Insensitivity Wizard on the same base columns, with the Database method and the Single index strategy. This activates the index on the CIAI columns.