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

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

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.