Optim High Performance Unload overview

Optim™ High Performance Unload performs high-speed, bulk data unloads for Db2 databases.

Optim High Performance Unload is a standalone utility program. It can run while the Db2® database manager is running and accesses the same physical files as the Db2 database manager. It can also run in a standalone mode and as a Db2 stored procedure.

You can run Optim High Performance Unload exclusively from the command line, or you can specify a control file for more complex unloads with the -f command-line option.

Optim High Performance Unload features

Optim High Performance Unload enables you to:

Unload Db2 data to flat files, tape devices, or named pipes.
Create files for multiple targets, even if the target files require different import or load file formats, because Optim High Performance Unload supports multiple formats for output files.
Unload Db2 summary tables.
Perform complete system migration from one Db2 instance to another one.
Eliminate the need for special applications to convert data, because Optim High Performance Unload column function supports conversion to a wide range of data types by using SELECT statement.
Use powerful, easy-to-use, and familiar SELECT syntax to specify the columns and rows to unload.
Unload a sample of Db2 rows by using the MAXROWS, SKIP, and INTERVAL keywords. You can use this feature to quickly check your control file syntax.

Additionally, Optim High Performance Unload provides parallel processing to maximize performance and creates messages that contain detailed summaries of unload operations, including unload process statistics, results, and error descriptions.