Data movement utilities

Db2 provides various data movement utilities to transfer data between databases and external files and are as listed below:

• The Db2 Export utility
• The Db2 Import utility
• The Db2 Load utility
• The Db2 Ingest utility

The Db2 Export utility

The Export utility extracts data from a Db2 database table or view and externalizes it to a file, using the DEL format or the PC/IXF format. Such files can then be used to load data into other databases or can be used by other software applications such as spreadsheets and word processors to analyze the exported data.

The basic syntax for the EXPORT command is as shown:

EXPORT TO [FileName] OF [DEL | WSF | IXF] 
<LOBS TO [LOBPath]> 
<LOBFILE [LOBFileName]...