Key facts
- Brand
- IBM
- Model
- DB2 High Performance Unload for z
- Category
- Other software
- Documents
- 2
- Languages
- EN
- Last added
- 2023-11-30
Start here

IBM Db2 High Performance Unload for z/OS V5.1 User's Guide
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.
IBM DB2 High Performance Unload for z specifications
| 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 |
Source: IBM Db2 High Performance Unload for z/OS V5.1 User's Guide
All IBM DB2 High Performance Unload for z documents by type
Day-to-day operation, settings and troubleshooting. Start here if the product is already set up.
Questions answered in these manuals
What does DB2 HPU do?
DB2 HPU is a high-speed DB2 utility that unloads DB2 tables from either a table space or from an image copy.
What output formats can DB2 HPU create?
DB2 HPU can create DSNTIAUL compatible, VARIABLE, DELIMITED, and USER output formats.
What is IBM Db2 High Performance Unload for z/OS?
It is a high-speed Db2 utility that unloads Db2 tables from either a table space or from an image copy.
From: IBM Db2 High Performance Unload for z/OS V5.1 User's Guide
Can Db2 HPU unload against an image copy?
Yes. The guide lists unloading against any image copy to eliminate interference with Db2 production databases.
From: IBM Db2 High Performance Unload for z/OS V5.1 User's Guide
