You can run DB2® scripts in a sharded deployment by
running specific scripts within each directory for each shard.
Procedure
- Run all of the scripts within each directory
for each shard: <INSTALL_DIR>/database/db2/scripts/CustomDBViews/<tabletype>
where <tabletype> is configuration, transaction,
and master.
- Run the configuration table
type scripts for the Configuration shard, the transaction table
type scripts for the Transaction shard, and the master table
type scripts for the Master shard.
- Additionally, for a sharded deployment, run yfs_addnl_index.sql in
<INSTALL_DIR>/database/db2/scripts/CustomDBIndexes/<tabletype>
where <tabletype> is configuration and transaction.
Note: When
running the custom view scripts manually, ignore the wms_master_db_script.sql
script.