DB2 High Performance Unload for z/OS

Version 4.1

IBM DB2 High Performance Unload reads table spaces sequentially and provides quick access to DB2 data.

DB2 High Performance Unload is a flexible, easy-to-use product that provides a fast and efficient tool to unload and extract data for movement across enterprise systems or for in-place reorganizations.

  • Creates multiple output files during a single unload at minimal cost.
  • Runs outside of DB2, so does not consume competing resources.
  • Supports efficient migration from non-IBM tools.
  • Can be launched from IBM DB2 Administration Tool for z/OS.
  • What’s new in Version 4.1? In addition to support for DB2 10 for z/OS, this release has many other enhancements such as support for a new INTERNAL output format, options to allow you to allocate output data sets on tape devices with stacking and native support for the WITH UR clause of the SELECT statement.
  • There is also support for native unloads of XML data into a LOB file.
  • This release provides support for options for the PATH keyword and support for the USS batch pipe data set type added to the TEMPLATE statement.
  • Program number: 5655-AA1
  • Operating system: z/OS

Learn more

IBM Software
See what smarter software can do for you

Buy DB2 High Performance Unload for z/OS

IBM Software Subscription and Support is included in the product price for the first year.

Download software online after purchase - no shipping costs.

Not available to purchase online. Other ways to purchase or learn more.

Contact IBM

MoreLess

Features and Benefits

IBM DB2 High Performance Unload for z/OS (also referred to as DB2 HPU) is a high-speed DB2 utility for unloading DB2 tables from either a table space or from an image copy. Tables are unloaded to one or more files based on a format that you specify. DB2 HPU helps you manage and control the unload activity. It works outside DB2, directly accessing the VSAM or sequential files that contain the table space or image copy data set. DB2 HPU also provides superior performance, especially in terms of CPU and elapsed time.

By using DB2 HPU, you can alleviate some of the problems that are associated with unloading large amounts of data. Large sequential reads of DB2 tables take a long time. Because of this, the large scans that are required for unload are hard to schedule in the ever-shrinking batch window at DB2 installations. Performance becomes critical when several unloads read the same table space concurrently. The associated DB2 buffer pool management can cause multiple programs to compete for the same data, resulting in:

  • Conflicts in the use of the DB2 buffer pool

  • Writing over buffers that might be serving several unloads

  • Multiple reads of the same DB2 pages

Potential channel conflicts DB2 HPU relieves these problems. It provides an extremely fast way to sequentially read and share a DB2 table space among multiple unloads. DB2 HPU scans a table space and creates the number of output files that you specify, in the format that you specify. The output format can be any one of the following types:

  • DSNTIAUL compatible

  • VARIABLE, which lets you quickly create variable-length records

  • DELIMITED, which lets you quickly create a delimited file that you can export to another platform

  • USER, which lets you specify virtually any type of conversion so that your output appears as you want it

  • EXTERNAL, which lets you quickly create fixed length human-readable formatted files

Whenever possible, DB2 HPU processes requests to unload data from the same table space in parallel. You can create different output files during the same unload process at almost no additional cost. For example, you can unload a list of customers who have payments due this week and another list of customers whose birthdays are on the first day of the week. You can create these lists in a single execution of DB2 HPU at a fraction of the cost that is required by traditional dual unload executions. You can also run DB2 HPU against image copies of the table space, thereby avoiding interference with DB2 production databases.

To maximize performance, DB2 HPU uses buffering, synchronization techniques, and parallel processing.

  • Buffering - When reading data rows, DB2 HPU directly accesses the VSAM clusters that contain the table space. This direct use of VSAM takes maximum advantage of the buffering capability that is provided by VSAM, which means that an entire cylinder can be read with a single I/O.

  • Synchronization - DB2 HPU permits the parallel execution of several unload jobs that access the same table space; it does this by synchronizing the unloads.

  • Parallel Processing - Unload requests that work on the same table space are processed in parallel whenever possible. Unload requests that work on different table spaces can be processed in parallel if they are specified in the global parallelism setting.

System requirements

IBM DB2 High Performance Unload for z/OS®, V4.1 is designed to operate with the following DB2 versions:

  • DB2 UDB for z/OS, V8.1 (5625-DB2)

  • DB2 UDB for z/OS Value Unit Edition, V8.1 (5697-N29)

  • DB2 9 for z/OS, V9.1 (5635-DB2)

  • DB2 9 for z/OS Value Unit Edition, V9.1 (5697-P12)

  • DB2 10 for z/OS, V10.1 (5605-DB2)

  • DB2 10 for z/OS Value Unit Edition, V10.1 (5697-P31)

For more information on the system requirements, see the Program Directory.

Considering a purchase?

Contact IBM

Considering a purchase?

DB2 High Performance Unload for z/OS

IBM Software