Exporting previously imported files
Follow these guidelines for exporting files that were previously imported from Db2® Warehouse.
About this task
Note that any restrictions that were applicable for import (for example, using remote import mode) are also applicable when exporting the same files.
If you want to export files that were previously imported using IBM® Fast Data Movement, you can do it in two ways:- Use the HDFS directory of a table as fq.input.path, for
example:
In this case, IBM Fast Data Movement will use the metadata created during import. This metadata contains the table definition and allows recreating the table if it does not exist.<import_set_path>/<table_name>
- Use the HDFS directory where data files are located, for
example:
In this case, the table must exist in Db2 Warehouse.<import_set_path>/<table_name>/table
Note:- This procedure does not work for Hadoop formats. If you are exporting data in Hadoop formats see Exporting data stored in Hadoop formats.