Sample sharded file for updating parameters in Upgrade_V2

You can review the sample XML for a sharded file updating parameters in Upgrade_V2.


?xml version="1.0" encoding="UTF-8"?>
<colonyconfig>
    <pools>
        <pool id="DEFAULT_METADATA">
          <jdbc>
            <param name="url" value="<url to connect to database>"/>
            <param name="user" value= "<Upgrade_V1_METADATA>"/>
            <param name="password" value="<Upgrade_V1_METADATA>"/>
            <param name="dbvendor" value="<database vendor name - either db2 or oracle>"/>
            <param name="driver" value="<class name of your database driver>"/
            <param name="schema" value="<Upgrade_V1_METADATA>"/>
          </jdbc>
        </pool>
        <pool id="DEFAULT_STATISTICS">
          <jdbc>
            <param name="url" value="<url to connect to database>"/>
            <param name="user" value= "<Upgrade_V1_STATISTIC>"/>
            <param name="password" value="<Upgrade_V1_STATISTICS>"/>
            <param name="dbvendor" value="<database vendor name - either db2 or oracle>"/>
            <param name="driver" value="<class name of your database driver>"/
            <param name="schema" value="<Upgrade_V1_STATISTICS>"/>
          </jdbc>
        </pool>
        <pool id="DEFAULT_CONFIGURATION">
          <jdbc>
            <param name="url" value="<url to connect to database>"/>
            <param name="user" value="<Upgrade_V1_CONFIGURATION>"/>
            <param name="password" value="<Upgrade_V1_CONFIGURATION>"/>
            <param name="dbvendor" value="<database vendor name - either db2 or oracle>"/>
            <param name="driver" value="<class name of your database driver>"/>
            <param name="schema" value="<Upgrade_V1_CONFIGURATION>"/>
          </jdbc>
        </pool>
        <pool id="DEFAULT_TRANSACTION">
          <jdbc>
            <param name="url" value="<url to connect to database>"/>
            <param name="user" value="<Upgrade_V1_DEFAULT_TRANSACTION>"/>
            <param name="password" value="<Upgrade_V1_DEFAULT_TRANSACTION>"/>
            <param name="dbvendor" value="<database vendor name - either db2 or oracle>"/>
            <param name="driver" value="<class name of your database driver>"/>
            <param name="schema" value="<Upgrade_V1_DEFAULT_TRANSACTION>"/> 
          </jdbc>
        </pool>
        <pool id="TRANSACTION-01">
          <jdbc>
            <param name="url" value="<url to connect to database>"/>
            <param name="user" value="<Colony_01_TRANSACTION>"/>
            <param name="password" value="<Colony_01_TRANSACTION>"/>
            <param name="dbvendor" value="<database vendor name - either db2 or oracle>"/>
            <param name="driver" value="<class name of your database driver>"/>
            <param name="schema" value="<Colony_01_TRANSACTION>"/>
          </jdbc>
        </pool>
    </pools>
    <colonies>
        <colony name="Colony-01" version="9.4" status="" pkprefix="11">
            <schema poolid="DEFAULT_METADATA" tabletype="METADATA"/>
            <schema poolid="DEFAULT_CONFIGURATION" tabletype= "CONFIGURATION"/>
            <schema poolid="DEFAULT_STATISTICS" tabletype="STATISTICS"/>
            <schema poolid="TRANSACTION-01" tabletype="TRANSACTION"/>
            <schema poolid="TRANSACTION-01" tabletype="MASTER"/>
        </colony>
        <colony name="DEFAULT" version="9.4" pkprefix="20">
            <schema poolid="DEFAULT_METADATA" tabletype="METADATA"/>
            <schema poolid="DEFAULT_CONFIGURATION" tabletype="CONFIGURATION"/>
            <schema poolid="DEFAULT_STATISTICS" tabletype="STATISTICS"/>
            <schema poolid=" DEFAULT_TRANSACTION" tabletype="TRANSACTION"/>
            <schema poolid=" DEFAULT_TRANSACTION" tabletype="MASTER"/>
        </colony>
    </colonies>
</colonyconfig>