Performance tuning for the Informix wrapper
You can use the FOLD_ID and FOLD_PW server options to improve connectivity between the federated server and Informix® data sources.
When the federated server connects to a data source, the server tries to connect using all possible combinations of uppercase and lowercase for the user ID and password. The server might make up to nine connect attempts before successfully connecting to the data source server. These attempts can slow down connect times and might result in the user ID getting locked out.
You
can improve performance by specifying the values for the FOLD_ID and FOLD_PW
server options.
- If all your Informix user
IDs and passwords are in lowercase, setting the FOLD_ID and FOLD_PW server
options with the value 'L' can improve your connect time.For example:
ALTER SERVER TYPE INFORMIX OPTIONS (ADD FOLD_ID 'L'); ALTER SERVER TYPE INFORMIX OPTIONS (ADD FOLD_PW 'L');
- The federated server attempts each combination of uppercase and lowercase
values for the user ID and password. You can reduce the chance of the maximum
number of failed login attempts being exceeded by setting these options to
'N' (do not fold the user ID and the password). If you establish these settings,
then you need to always specify the user ID and password in the correct case.
If an invalid user ID and password are specified, the wrapper will not keep
trying the various combinations.For example:
ALTER SERVER TYPE INFORMIX OPTIONS (ADD FOLD_ID 'N'); ALTER SERVER TYPE INFORMIX OPTIONS (ADD FOLD_PW 'N');