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.

Example

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="'2012-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"/>
        </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="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>