When attempting to migrate a table from one environment to another AND having selected to copy the data as well, the product creates two files - one for the export functions, and one for the build and import functions. The problem is the name of the files are different for the export and import functions.
The export may be ...\customer_1234567.ixf
The import may be ...\customer_55555.ixf
When the export is run, the file is created as . When the import section runs, the error 'file not found' is given because it is looking for customer_55555.ixf, instead of the created customer_1234567.ixf.
Prior to 5.5, these names were automatically synchronized.
WORKAROUND:
Go into and edit both files to synch the export and import file names.
STATUS:
Waiting for fix in a future version of Toad for DB2.
