Data Movement Utilities Guide and Reference

Recreating an Exported Table

A table can be saved by using the export utility and specifying the IXF file format. The saved table (including its indexes) can then be recreated using the import utility (see Recreating an Exported Table for more information, including a list of the attributes that the IXF file format carries about a table).

The export operation will fail if the data you want to export exceeds the space available on the file system on which the exported file will be created. In this case, you should limit the amount of data selected by specifying conditions on the WHERE clause, so that the export file will fit on the target file system. You can invoke the export utility multiple times to export all of the data.

The DEL and ASC file formats do not contain descriptions of the target table, but they do contain the record data. To recreate a table with data stored in these file formats, create the target table, and then use the load, AutoLoader, or import utility to populate the table from these files. db2look (DB2 Statistics and DDL Extraction Tool; see the Command Reference) can be used to capture the original table definitions, and to generate the corresponding data definition language (DDL).


[ Top of Page | Previous Page | Next Page ]