SERVER_ENCRYPT_AES authentication in CLPPlus

In Db2® Cancun Release 10.5.0.4, the CLPPlus interface adds support for connections to DSN aliases that use SERVER_ENCRYPT_AES authentication. The SERVER_ENCRYPT_AES authentication option is defined in the IBM® data server driver configuration file (db2dsdriver.cfg).

The IBM data server driver configuration file is an XML file that contains a list of DSN aliases and their properties. If the DSN alias entry contains the Authentication property value that is set to SERVER_ENCRYPT_AES, the SERVER_ENCRYPT_AES authentication mechanism is used. For more information, see the DSN aliases in CLPPlus topic.

Examples

The following example shows a connection being established with the contents of the IBM data server driver configuration file, which includes the Authentication parameter value.

Consider the following IBM data server driver configuration file contents:

<configuration>
	<dsncollection>
		<dsn alias="S" name="SAMPLE" host="9.121.221.159" port="50000">
       <parameter name="Authentication" value="SERVER_ENCRYPT_AES"/>
		</dsn>
	</dsncollection>
	<databases>
		<database name="SAMPLE" host="9.121.221.159" port="50000">
			<parameter name="UserID" value="john"/>
		</database>
	</databases>
</configuration>

The user starts a CLPPlus session and attempts a connection to the DSN alias "S".

C:\>clpplus -nw
CLPPlus: Version 1.6
Copyright (c) 2009, 2011, IBM CORPORATION.  All rights reserved.

SQL> connect
Enter DATABASE NAME [SAMPLE]: S
Enter ID [john]:
Enter password: **********

Database Connection Information :
---------------------------------
Hostname = 9.121.221.159
Database server = DB2/NT  SQL09075
SQL authorization ID = john
Local database alias = S
Port = 50000