DB2 High Performance Unload Tool

DB2 High Performance Unload gives customers a fast and efficient tool for unloading and extracting data for movement across enterprise systems, or for reorganization in place. The product delivers high levels of parallelism when either unloading or extracting in partitioned database environments, both for DB2 ESE v8 and DB2 EEE v7. It can process multiple select statements at the same time so that multiple requests of the DB2 UDB will be processed in a single scan of the table. DB2 High Performance Unload also has the capability to:

• Rapidly unload table spaces of all types supported by DB2.

• Make the output file-set a tape, disk, or named pipe, formatted suitably for optional reorganization or reload.

• Simultaneously execute several unloads accessing the same table space.

• Unload against a full backup to eliminate interference with DB2 production databases (the image copy can be the last or any full copy).

• Unload selected rows and columns via a SELECT.

• Unload every n rows (e.g., every fifth row).

• Generate load control statements for subsequent reload.

• Optionally unload data and move information from a partitioned table to a single file-set for use in another database environment.

• Unload DB2 UDB table data from multiple database partitions in a single request.