Running Db2 CustomDBViews in a sharded deployment

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.