How the REBUILD INDEX utility statement is generated in a RC/Migrator Move strategy?.

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

A REBUILD INDEX utility statement in a RC/Migrator Move strategy is not generated so the index is left in Rebuild Pending RBDP status after the DDL CREATE INDEX statement is executed in the target DB2 Subsystem.

Instructions:

Note the following from RC/Migrator User Guide manual:
>>>
Rebuild Index

Specifies whether to include Rebuild Index utilities in the analysis. This option is in effect only if the index was created using the DEFER YES clause. Valid values are as follows:

Y
Includes Rebuild Index utilities in the analysis. The DEFER YES option is overridden for indexes that are created on empty tables.

N
Does not include Rebuild Index utilities in the analysis.
<<<
 
Value for DEFER clause is not stored in the DB2 Catalog so it has to be generated in the CREATE INDEX statement. To generate the DEFER YES clause in the CREATE INDEX statement you have to work with Global Changes and set YES to IXDR Code. 
 
CODE            CHANGE DESCRIPTION     FROM                   TO
IXDR             DEFER                               *                      YES 
 
Then in the Analysis Options you have to select this Global Changes and be sure there is REBUILD INDEX  ==> Y in the Analysis Options.
 
Now in the Analysis Report strategy you will get a CREATE INDEX ... DEFER YES statement followed by a REBUILD INDEX utility statement.