Configuring IBM data server driver configuration file

Data server driver configuration contains the remote data source information namely hostname, port number, username, password and other parameters.

1. Go to sqllib/cfg folder and open db2dsdriver.cfgsample file.
2. Set the DSN name, database name and other parameters. For example:

   <dsncollection>
   <dsn alias="STLEC1" name="STLEC1" host="SDTEC2.vmec.svl.ibm.com" port="4
   <parameter name="Authentication" value="SERVER"/>
   <parameter name="commprotocol" value="TCPIP"/>
   <parameter name="clientApplCompat" value="V12R1M501"/>
   </dsn>
   </dsncollection>
   </databases>
   <database name="STLEC1" host="SDTEC2.vmec.svl.ibm.com" port="446">
   <parameter name="CurrentSchema" value="SYSADM"/>
   <wlb>
   <parameter name="enableWLB" value="true"/>
   <parameter name="maxTransports" value="50"/>
   </wlb>
   </database>

   Note: If the data source is Db2 z/OS V12R1M500 or less than V12R1M500, you must remove the parameter clientApplCompat. For more information, see V12R1Mnnn application compatibility levels for data server clients and drivers