DB2 10.5 for Linux, UNIX, and Windows

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>, and <parameters> 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="Client"/>
        </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>
</configuration>