How to add an Index Include column in a RC/Migrator alter strategy
search cancel

How to add an Index Include column in a RC/Migrator alter strategy

book

Article ID: 33671

calendar_today

Updated On:

Products

RC/Migrator for DB2 for z/OS RC Compare for DB2 for z/OS

Issue/Introduction

 In RC/Migrator for Db2 for z/OS (RCM) how can INCLUDE columns be added to an Index.

Resolution

In RC/Migrator an ALTER strategy can be used to add Include columns to an existing index.

For more detail see the RC/Migrator Guide:    Unique Index INCLUDE column support

The above documentation mentions the use of profiles, below is some additional information.

When analyzing strategies in RC/Migrator, an existing Analysis Profile can be used by entering the profile name and creator on the analysis screen.  This profile contains the analysis option values.  

In addition, within an Analysis Profile a Utility Profile can be specified (optional)  to use also when analyzing Alter, Migrate or Compare Strategies. There is no limit to the number of Analysis and Utility profiles you can have. 

The Schema Change Profile (RCM Option 0 then U-Utility Profile)  lets you specify a sequence for invoking utilities that is based on the object attribute change. The utility profiles are integrated with the analysis profile options and give you more ease of use.

See: Create and Use Utility Profiles for detail on creating Analysis and Utility profiles.