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>