Unloading data from a table, view, alias, or nickname

Use the Unload or Optim™ High Performance Unload task assistant to unload data into an object. The data is unloaded into a file on the DB2 server file system, which can be local or remote.

Before you begin

The Database Administration feature must be installed. To use Optim High Performance Unload commands to unload the data, Optim High Performance Unload must be installed.

About this task

You can use Import task assistant data unload data from a table, view, alias or nickname. You can use the Optim High Performance Unload task assistant to unload data from a table, and unloading large object (LOB) and XML data is not supported.

Procedure

  1. In the Object List, find the object with the data that you want to unload. You can use the Objects Name Search field to search for the object. Make sure that the Row Count column contains a positive value.
  2. Right-click the object, and click Unload > With Export Utility or Unload > With Optim High Performance Unload.

    The task assistant that you selected for Unload or Optim High Performance Unload opens.

  3. In the Settings section, click each of the tabs to specify the setting and options with which to run the command, including the name and location for the output file. If the data contains large object (LOB) or XML data, you can specify separate directories for location of the LOB data and of the XML data.
  4. Click Preview Command to expand the Command section, and then review the generated commands.
  5. Click Run to run the commands that are displayed in the Command section.
  6. In the Messages section, monitor the progress of the commands that are being run in the progress bar and review any messages that are issued. The results of running the commands are also displayed in the SQL Results view.

Results

The data is saved to the output files that you specified.

Feedback