Is there a way to eliminate the ORDER BY when doing an IBM unload in a migration strategy?

book

Article ID: 49998

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

Description:

A migration strategy is doing an IBM unload at the database level. Due to the amount of data that is being unloaded, it would be best if the ORDER BY in the unload is suppressed.

Solution:

To eliminate the ORDER BY in the Unload you will want to eliminate the indexes in the strategy. That way RC/Migrator doesn't know if the table has a clustered index or not.

If the index DDL is needed then two migration strategies will be necessary.

Create one strategy without the indexes where a DATA-ONLY analysis is done and then create the second strategy with all objects analyzed with the ALL ROWS analysis option Set to "N" to include .SYNCs or set the DDL-ONLY analysis option which would exclude .SYNCs.

Environment

Release:
Component: RCM