ClientEncAlg CLI/ODBC and IBM data server driver 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
- IBM data server driver configuration file (db2dsdriver.cfg) syntax:
- <parameter name="ClientEncAlg" value="1 | 2 | AES"/>
Attention: The IBM data server
driver configuration
file (db2dsdriver.cfg) syntax is available in Db2 11.5.4 and later.
- 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.