Data Movement Utilities Guide and Reference

Chapter 1. Export

This section describes the DB2 UDB export utility, which is used to write data from a DB2 database to one or more files stored outside of the database. The exported data can then be imported or loaded into another DB2 database, using the DB2 import or the DB2 load utility, respectively, or it can be imported into another application (for example, a spreadsheet).

The following topics are covered:

• Export Overview
• Privileges, Authorities, and Authorization Required to Use Export
• Using Export
• Using Export with Identity Columns
• Recreating an Exported Table
• Exporting Large Objects (LOBs)
• Exporting Data in Parallel
• EXPORT Command
• Export API
• SQLUEXPT-OUT Data Structure
• File Type Modifiers (Export)
• Example Export Sessions
• Restrictions
• Troubleshooting.

For information about exporting DB2 Data Links Manager data, see Using Export to Move DB2 Data Links Manager Data. For information about exporting data out of typed tables, see Moving Data Between Typed Tables. For information about exporting data from a DRDA server database to a file on the DB2 Connect workstation, and the reverse, see Moving Data With DB2 Connect.