Running DB2 scripts in a sharded deployment

You can run DB2® scripts in a sharded deployment by running specific scripts within each directory for each shard.

Procedure

  1. 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.

  2. 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.
  3. 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.