A typical export operation involves the outputting of selected data that is inserted or loaded into existing tables. However, it is also possible to export an entire table for subsequent re-creation using the import utility.
Index information
If the column names specified
in the index contain either - or + characters, the index
information is not collected, and warning SQL27984W is
returned. The export utility completes its processing, and the data
exported is unaffected. However, the index information is not saved
in the IXF file. As a result, you must create the indexes separately
using the db2look utility.
Space limitations
The export operation fails
if the data that you are exporting exceeds the space available on
the file system on which the exported file is created. In this case,
you should limit the amount of data selected by specifying conditions
on the WHERE clause so that the exported file fits on the target file
system. You can run the export utility multiple times to export all
of the data.
Tables with other file formats
If you do not
export using the IXF file format, the output files do not contain
descriptions of the target table, but they contain the record data.
To re-create a table and its data, create the target table, then use
the load or import utility to populate the table. You can use the db2look utility
to capture the original table definitions and to generate the corresponding
data definition language (DDL).