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:
    <import_set_path>/<table_name>
    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.
  • Use the HDFS directory where data files are located, for example:
    <import_set_path>/<table_name>/table
    In this case, the table must exist in Db2 Warehouse.
    Note: