Db2 High Performance Unload for z/OS is a high-performance data unloading tool that helps you quickly and easily unload data from Db2 databases to a variety of target systems.
IBM Db2 High Performance Unload for z/OS (Db2 HPU) is a high-speed Db2 utility that unloads Db2 tables from either a table space or from an image copy. This User's Guide for Version 5 Release 1 (product number 5655-HP5) describes customization, input and output, batch and interactive operation, the user exit, troubleshooting, and reference information.
The guide explains how Db2 HPU can retrieve data without heavy SQL processing by directly accessing VSAM or sequential files that contain the table space, or from image copy data sets. It also covers tasks such as unloading selected rows and columns, parallel processing of several unloads that access the same table space, and generating load control statements for subsequent reload.
| Version | Version 5 Release 1 |
|---|---|
| Product number | 5655-HP5 |
| Data sources | Table space or image copy |
| Output files | One or more files in a user-specified format |
| Parallel processing | Several unloads can access the same table space |
| Row and column selection | Selected rows and columns can be unloaded |
It is a high-speed Db2 utility that unloads Db2 tables from either a table space or from an image copy.
Yes. The guide lists unloading against any image copy to eliminate interference with Db2 production databases.
Yes. The guide describes customizing and using Db2 HPU in batch and interactively.
It unloads tables to one or more files based on a format that you specify.