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
The Utility Profile in use does not have a "Y" in the Rebuild column for Indexes on the ADD COLUMN line.
Release: R20
Component: RCM
In order to force the strategy to REBUILD the index after an ADD INCLUDE COLUMN statement a Utility Profile and Analysis profile must be prepared using the following steps:
From the main menu of RC/Migrator:
Create an Analysis Profile and link it to the new Utility Profile.
The strategy analysis will now contain the utility statements to rebuild the index after the alteration