Unloading data from a table, view, alias, or nickname with the Optim High Performance Unload task assistant in IBM Data Studio 3.1.1

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.

Attention: If you are running Optim High Performance Unload on a UNIX platform, you need to add the Optim High Performance Unload installation path to sqllib/userprofile:
1. Open the userprofile file from the DB2 installation under the sqllib directory.
2. Add the following line to the file:
export PATH=HPU_installation_path/bin:$PATH
Where HPU_installation_path is the Optim High Performance Unload installation path.

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.