Running Db2 CustomDBViews in a non-sharded deployment
Procedure
Run the following scripts in the
<INSTALL_DIR>/database/db2/scripts directory
individually: - CustomDBViews/transaction/ImportExport_View.sql
- CustomDBViews/transaction/Interop_Views.sql
- CustomDBViews/transaction/InvSnapshot_vw.sql
- CustomDBViews/transaction/yfs_cross_reference_vw.sql
- CustomDBViews/transaction/yfs_iba_ord_demand_vw.sql
- CustomDBViews/transaction/yfs_iba_resv_demand_vw.sql
- CustomDBViews/transaction/yfs_invtdmddtl_vw.sql
- CustomDBViews/transaction/yfs_noPendMove_nodeInventoryDtl_vw.sql
- CustomDBViews/transaction/yfs_onlyLPN_nodeInventoryDtl_vw.sql
- CustomDBViews/transaction/yfs_onlyLPN_NoPendMove_nodeInventoryDtl_vw.sql
- CustomDBViews/transaction/yfs_order_release_line.sql
- CustomDBViews/transaction/yfs_order_release_line_vw.sql
- CustomDBViews/transaction/yfs_nodeInventoryDtl_vw.sql
- CustomDBViews/configuration/yfs_wave_item_vol_config_vw.sql
- CustomDBViews/master/ycm_pricelist_vw.sql
- CustomDBViews/master/ypm_category_item_vw.sql
- CustomDBViews/master/ypm_item_vw.sql
Note: When running the custom view scripts manually, ignore
the wms_master_db_script.sql script.