What does Db2 HPU do?

Db2® HPU helps you manage and control the unload activity. Db2 HPU can retrieve the data to unload without heavy SQL processing by directly accessing the VSAM or from image copy data sets.

Db2 HPU also provides superior performance, especially in terms of CPU time and elapsed time. Unless you need to process a complex SQL statement, Db2 HPU typically maximizes performance by reducing processor usage and improves availability by keeping data unavailable for a shorter time. Db2 HPU also reduces the regular CPU time it consumes by offloading a significant part of its code to the zIIP processors.

Db2 HPU offer the following main features and capabilities:

• Unload selected rows and columns
• Unload against any image copy to eliminate interference with Db2 production databases
• Generation of load control statements for subsequent reload
• Processing of multiple Db2 objects defined by lists as a single step
• Wide range of very versatile and adjustable formatting capabilities
• Various capabilities to unload LOB and XML data
• Creation of output in multiple formats during a single unload
• Allocation of output dataset based on templates
• Extract samples without any WHERE clause by sampling rows and/or limiting the number of row
• Inspection, modification or discarding of unloaded rows by using the Db2 HPU user exit
• Fast unload of table spaces
• Parallel processing of several unloads involving the same table space
• Support of other unload tools controls cards (syntax compatibility).
• Options compatible with almost all of the features of other unload tools (feature compatibility)