Preparing your Db2 environment

Prior to preparing your Db2 environment, ensure that your database has been upgraded to the version of Db2 supported for your environment.

For information about system requirements, see IBM Support Portal. If you are upgrading to Db2 10.5.5, refer to the Db2 documentation for instructions.

Note: If you are upgrading in sharded mode, the instructions described in this section must be followed for all shards in all colonies.
The following table provides instructions for preparing your Db2 environment during data migration:
When upgrading from 9.3 When upgrading from 9.4 When upgrading from 9.5
  1. DROP INDEX H_H_PROMO_AWD_I1;
  2. DROP INDEX PROMO_AWD_I1;
  3. DROP INDEX H_H_PROMO_I1;
  4. CREATE UNIQUE INDEX H_PROMO_AWD_I1_94 ON YFS_PROMOTION_AWARD_H ( ORDER_HEADER_KEY,ORDER_LINE_KEY, AWARD_ID );
  5. CREATE UNIQUE INDEX PROMO_AWD_I1_94 ON YFS_PROMOTION_AWARD ( ORDER_HEADER_KEY,ORDER_LINE_KEY,AWARD_ID );
  6. CREATE UNIQUE INDEX H_PROMO_I1 ON YFS_PROMOTION_H ( ORDER_HEADER_KEY,ORDER_LINE_KEY, PROMOTION_GROUP, PROMOTION_ID );
  7. Update the file <93_YFS_RT>/repository/entity/omp_tables.xml, and add the attribute Version="9.4" to <Index> for the index with DB2Name="PROMO_AWD_I1"
  1. DROP INDEX INV_ALERTS_I4;
  2. DROP INDEX H_PROMO_AWD_I1;
  3. CREATE UNIQUE INDEX INV_ALERTS_I4_950 ON YFS_INVENTORY_ALERTS (INVENTORY_ITEM_KEY ASC, SHIP_NODE ASC, ALERT_TYPE ASC, ALERT_LEVEL ASC, ORGANIZATION_CODE ASC);
  4. CREATE UNIQUE INDEX H_PROMO_AWD_I1_94 ON YFS_PROMOTION_AWARD_H (ORDER_HEADER_KEY ASC, ORDER_LINE_KEY ASC, AWARD_ID ASC, ADDNL_LINE_PRICE_KEY ASC);
  5. Update the file <94_YFS_RT>/repository/entity/inv_tables.xml, and add the attribute Version="9.5.0" to <Index> for the index with DB2Name="INV_ALERTS_I4"
  6. Update the file <94_YFS_RT>/repository/entity/omp_tables.xml, and add the attribute Version="9.4" to <Index> for the index with DB2Name="PROMO_AWD_I1"
  1. DROP INDEX INV_INVENTORY_ITEM_LOCK_I1;
  2. CREATE UNIQUE INDEX INV_INVENTORY_ITEM_LOCK_I1_9418 ON INV_INVENTORY_ITEM_LOCK (INVENTORY_ITEM_KEY ASC, DEMAND_TYPE ASC);
  3. Update the file <95_YFS_RT>/repository/entities/inv_tables.xml, and add the attribute Version="9.4.18" to <Index> for the index with DB2Name="INV_INVENTORY_ITEM_LOCK_I1"