RC/Migrator: How to add an Index Include column in an Alter Strategy

Products

• CA RC/Migrator
• CA Endevor SCM Interface
• DB2 Administration
• CA RC Compare for DB2 for z/OS
• CA RC Extract for DB2 for z/OS
• CA RC/Query
• CA RC Secure for DB2 for z/OS
• CA RC Update for DB2 for z/OS

Issue/Introduction

Question:

In RC/Migrator how do I add Include columns to an Index?

Answer:

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

Please see the following step by step document detailing how to ALTER an existing index to add INCLUDE columns:

 

Steps to add an Include Column

 

For more detail see the RC/Migrator Guide:   Include Column Support

 

In addition TEC1007091 provides steps on creating UTILITY and ANALYSIS profiles.  A UTILITY profile is included within an ANALYSIS profile.

Environment

Release:
Component: RCM