To configure your DB2® database for
your production environment, you must set up and run a series of scripts to create the tables,
indexes, sequences, and so forth for your schema.
About this task
You
must run these scripts only if you are manually creating the views
after installation (REINIT_DB=no). In the normal
installation mode (REINIT_DB=yes), the views will
be applied automatically.
These script files reside
in the <INSTALL_DIR>/database/db2/scripts/ directory.
This is the list of scripts to be edited using a SQL
tool:
- 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