DB2 Version 9.7 for Linux, UNIX, and Windows

ClientEncAlg CLI/ODBC configuration keyword

Specifies the type of encryption algorithm to be used when encrypting user IDs and passwords.

db2cli.ini keyword syntax:
ClientEncAlg = 1 | 2 | AES
Default setting:
Any encryption algorithm can be used.
Applicable when:
Connecting to remote databases.
Equivalent environment or connection attribute:
SQL_ATTR_CLIENT_ENCALG
Usage notes:
The values for this keyword are defined as follows:
  • 1 - Encrypt the user ID and password using any encryption algorithm.
  • 2 - Encrypt the user ID and password using an Advanced Encryption Standard (AES) encryption algorithm.
  • AES - Equivalent to 2.

The CLI attribute SQL_ATTR_CLIENT_ENCALG has a similar behavior as the keyword, except when an invalid attribute value is specified an error is returned: CLI0191E Invalid attribute value. The CLI keyword or connection attribute values take precedence over the authentication type specified in the system database directory.