Sample sharded file for moving colonies to Production_V2
You can review the sample sharded file XML for moving colonies to the Production_V2 environment.
?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=”<Production_V1_METADATA> "/>
<param name="password" value=”<Production_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="<Production_V1_METADATA> "/>
</jdbc>
</pool>
<pool id="DEFAULT_STATISTICS_10">
<jdbc>
<param name="url" value="<
url to connect to database>
"/>
<param name="user" value="<Production_V2_STATISTICS> "/>
<param name="password" value="<Production_V2_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="<Production_V2_STATITICS> "/>
</jdbc>
</pool>
<pool id="DEFAULT_CONFIGURATION_10">
<jdbc>
<param name="url" value="<
url to connect to database>
"/>
<param name="user" value="<Production_V2_CONFIGURATION>"/>
<param name="password" value="<Production_V2_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="<Production_V2_CONFIGURATION> "/>
</jdbc>
</pool>
<pool id="DEFAULT_TRANSACTION_10">
<jdbc>
<param name="url" value="<
url to connect to database>
"/>
<param name="user" value="<Production_V2_DEFAULT_TRANSACTION>">/>
<param name="password" value="<Production_V2_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="<Production_V2_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.5
" newversion="10.0"
status="" pkprefix="11">
<schema poolid="DEFAULT_METADATA" tabletype="METADATA"/>
<schema poolid="DEFAULT_CONFIGURATION_94" tabletype="CONFIGURATION"/>
<schema poolid="DEFAULT_STATISTICS_94" tabletype="STATISTICS"/>
<schema poolid="TRANSACTION-01" tabletype="TRANSACTION"/>
<schema poolid="TRANSACTION-01" tabletype="MASTER"/>
</colony>
<colony name="DEFAULT" version="10.0" pkprefix="20">
<schema poolid="DEFAULT_METADATA" tabletype="METADATA"/>
<schema poolid="DEFAULT_CONFIGURATION_94" tabletype="CONFIGURATION"/>
<schema poolid="DEFAULT_STATISTICS_94" tabletype="STATISTICS"/>
<schema poolid="DEFAULT_TRANSACTION_94" tabletype="TRANSACTION"/>
<schema poolid="DEFAULT_TRANSACTION_94" tabletype="MASTER"/>
</colony>
</colonies>
</colonyconfig>