UNLOAD utility

The UNLOAD utility unloads data from one or more source objects to one or more sequential data sets in external format. It is the preferred method for unloading or transferring large amounts of data.

You can specify the Db2® templates that identify the data set to receive the LOAD utility control statements (PUNCHDDN clause) and the data sets into which the data is unloaded (UNLDDN clause).

To select the UNLOAD utility, enter 7 in the Db2® utility input field on the Db2® Utilities panel.

If you selected Tables in the Object Type section of the Db2® Utilities panel, the UNLOAD Utility (Tables) panel is displayed.

If you selected Table spaces in the Object Type section of the Db2® Utilities panel, the UNLOAD Utility (Table Spaces) panel is displayed.

Related tasks

• UNLOAD (tables)
• UNLOAD (table spaces)
• Setting options for Db2 utilities

Related references

• Db2 Utilities panel
• TEMPLATE Options (2 of 2) panel
• UNLOAD Utility (Tables) "From" panel
• UNLOAD Utility (Tables) "To" panel
• UNLOAD Utility (Tables) with LISTDEF panel
• UNLOAD Utility (Table Spaces) panel
• UNLOAD Utility (Table Spaces) with LISTDEF panel