Did a migrate for a table. The script that was generated unloaded data, dropped the table, created the table, created the indexes, then loaded the data.
With a large table it would be better to load the data and then build the indexes. That is what Quest Central does.
WORKAROUND
Move indexes creation to after data load in script. (It may be necessary to also set the following option Tools -> Options->Database->DB2->LUW->Load and check non-recoverable. )
STATUS
Enhancement request ST79326 has been submitted to Development for consideration in a future release of Toad for DB2
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center