How to make an RC/Migrator Strategy Rebuild the Index when ALTER ADD INCLUDE COLUMN is specified in an alteration strategy for indexes

Document ID : KB000018742
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

Whenever RC/Migrator handles an alteration strategy on an index that includes the ALTER ADD INCLUDE COLUMN parameter, it does not rebuild the index after the alteration is completed, leaving the index in REBUILD PENDING status

Solution:

In order to force the strategy to REBUILD the index after an ADD INCLUDE COLUMN statement you need to set up a Utility
Profile and Analysis profile using the following steps:

From the main menu of RC/Migrator:

  1. Enter '0' for Profile
  2. Enter U for Utility Profile Management
  3. Enter C on the CMD Line to create a new PROFILE with the appropriate share option or template an existing profile
  4. Ensure there is a "Y" on the REBUILD column under "Add COLUMN" for Indexes
  5. PF3 to create the utility profile
  6. PF3 again to go back to the RC/Migrator Profile Menu
  7. Enter P for Analysis Profile Management
  8. Enter C on the CMD Line to create a new analysis PROFILE with the appropriate share option or template an existing profile
  9. Enter the analysis option values you wish to use, when you come to "Utility Options", change "Use Utility Profile" to "Y" and enter the Utility
    Profile name and creator to include the profile that was created in Step 3.
  10. PF3 to create the Analysis Profile
  11. Press PF3 twice to get back to the main menu of RC/Migrator
  12. Analyze your Alter Strategy in Strategy Services
  13. Under "Option Specifications" enter the Analysis Profile name and Creator for the profile you created in step 9

The strategy analysis will now contain the utility statements to rebuild the index after the alteration