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

book

Article ID: 33671

calendar_today

Updated On:

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

Attachments

1558535588877TEC1727424.zip get_app