IBM data server driver configuration file example
When you specify the IBM® data server driver configuration keywords, update the appropriate section of the IBM data server driver configuration file.
Examples
What follows is a sample IBM data server driver
configuration file with <dsncollection>, <database>, <parameters>
,and
<ldapserver>
sections:
<configuration>
<dsncollection>
<dsn alias="alias1" name="name1" host="server1.net1.com" port="50001">
<sessionglobalvariables>
<parameter name="GV_MYJOB " value="'Engineer'"/>
<parameter name="GV_MYDATE" value="'2022-12-12'"/>
<parameter name="GV_EMPNO" value="07089"/>
</sessionglobalvariables>
</dsn>
<!-- Long aliases are supported -->
<dsn alias="longaliasname2" name="name2" host="server2.net1.com" port="55551">
<specialregisters>
<parameter name="CURRENT DEFAULT TRANSFORM GROUP" value="MYSTRUCT"/>
<parameter name="CURRENT EXPLAIN SNAPSHOT" value="YES"/>
<parameter name="CURRENT MDC ROLLOUTMODE" value="IMMEDIATE"/>
</specialregisters>
<parameter name="Authentication" value="Server"/>
<parameter name="APPTOKENGEN" value="ON"/>
</dsn>
</dsncollection>
<databases>
<database name="name1" host="server1.net1.com" port="50001">
<parameter name="CurrentSchema" value="OWNER1"/>
<wlb>
<parameter name="enableWLB" value="true"/>
<parameter name="maxTransports" value="50"/>
</wlb>
<acr>
<parameter name="enableACR" value="true"/>
</acr>
</database>
<!-- Local IPC connection -->
<database name="name3" host="localhost" port="0">
<specialregisters>
<parameter name="CURRENT DEFAULT TRANSFORM GROUP" value="MYSTRUCT1"/>
<parameter name="CURRENT EXPLAIN SNAPSHOT" value="YES"/>
<parameter name="CURRENT FEDERATED ASYNCHRONY" value="5"/>
</specialregisters>
<parameter name="IPCInstance" value="DB2"/>
<parameter name="CommProtocol" value="IPC"/>
</database>
</databases>
<parameters>
<specialregisters>
<parameter name="CURRENT DEFAULT TRANSFORM GROUP"
value="MYSTRUCT2"/>
<parameter name="CURRENT EXPLAIN SNAPSHOT" value="NO"/>
<parameter name="CURRENT LOCALE LC_MESSAGES" value="en_CA"/>
</specialregisters>
<sessionglobalvariables>
<parameter name="GV_MYJOB " value="'Scientist'"/>
<parameter name="GV_MYDATE" value="CURRENT DATE"/>
</sessionglobalvariables>
<parameter name="APPTOKENGEN" value="OFF"/>
<parameter name="GlobalParam" value="Value"/>
</parameters>
<ldapserver>
<parameter name="EnableLDAP" value="YES"/>
<parameter name="LDAPServerHost" value="myhost.lab.ibm.com"/>
<parameter name="ClientProvider" value=”IBM”/>
<parameter name="BaseDN" value="O=IBM"/>
<parameter name="UserID" value="root"/>
<parameter name="Password" value="itv23"/>
</ldapserver>
</configuration>