Applications Administration Guide > Ongoing Application Administration Tasks >

Modifying the InsensitivityFactor Parameter

When you change the CaseInsensitive parameter, you may also want to change the InsensitivityFactor parameter to minimize performance degradation.

The default setting for the InsensitivityFactor parameter is 2.

NOTE:  Do not change the default value of InsensitivityFactor for Gateway Datasource (GatewayDataSrc). Gateway Datasource does not go against a database. Changing the value may cause problems.

You may want to test a number of values for this parameter with your database, spool the SQL to see the effect of different settings on response time, and then choose a value that meets your needs.


 Applications Administration Guide
 Published: 09 September 2004