IBM Books

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. The export utility 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.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]