Benefits of using Optim High Performance Unload

There are numerous benefits of using Optim™ High Performance Unload including fast performance and flexibility.

Fast performance

Optim High Performance Unload provides noticeable performance benefits under most circumstances. The degree of benefit will always depend on several factors, such as what other resources the system is using and to what extent it is using them. For example, if CPU, memory or input/output (I/O) are being consumed at an extraordinary rate, this will affect Optim High Performance Unload performance. Similarly, performance will depend on which Optim High Performance Unload function you are using and what other applications are running on your system, and on the features of the system, itself.

Additional performance benefits

In addition, Optim High Performance Unload can provide the following performance benefits:
  • Optim High Performance Unload is a highly-threaded application that can exploit all available system processors.
  • Optim High Performance Unload can perform a complete system migration from one Db2® instance to another by unloading, transferring, and loading the data on the target hosts.
  • Optim High Performance Unload has flexible database partition support. Optim High Performance Unload can improve performance by creating files on each remote host rather than one file on one system.
  • You can provide a list of directories for Optim High Performance Unload output. If the directories are defined across different physical devices, Optim High Performance Unload can unload and write to the files in parallel with no contention for disk, resulting in greatly reduced elapsed time.
  • Because Optim High Performance Unload reads the container files directly, it does not displace potentially reusable data in the buffer pool with data that is being exported and, therefore, less likely to be reused.

Multiple target file support

Optim High Performance Unload can unload data into multiple target files. This capability results in the following benefits:
  • You can specify the size and location of the target files, which gives you greater flexibility in managing your file system.
  • You can unload table data to multiple targets, even if the targets require different file formats, such as DEL and IXF.