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
- 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.
- Right-click the object, and click or .
The task assistant
that you selected for Unload or Optim High
Performance Unload opens.
- 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.
- Click Preview Command to expand
the Command section, and then review the generated
commands.
- Click Run to run the commands that
are displayed in the Command section.
- 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.