Using Db2 High Performance Unload in a work statement list that is not created by Db2 Object Comparison Tool, ALTER, or ALT

If Db2 High Performance Unload is enabled, all work statement lists that contain an UNLOAD or REORG UNLOAD EXTERNAL statement display the HPU Unload Prompt pop-up panel (ADB2WHPU) at run time.

The Db2 High Performance Unload support in Db2 Admin Tool is primarily intended to be used for a work statement list that is created by one of the Db2 Admin Tool or DB2® Object Comparison Tool functions. However, if Db2 HPU is selected at run time, any eligible unload is converted to run as a Db2 High Performance Unload unload. To be considered as an eligible unload, all of the following statements must be true:

  • The UNLOAD statement, whether it be UNLOAD or REORG UNLOAD EXTERNAL, must have exactly one FROM TABLE clause, with no other keywords from the utilities FROM-TABLE-spec.
  • The UNLOAD data set name must not exceed 38 characters. This restriction enables a suffix to be appended to the data set name that indicates the partition number.
  • The DDNAME that is associated with the UNLOAD data set must be SYSREC.
Restriction: Do not code Db2 High Performance Unload syntax directly in a work statement list. Use only the Db2 utility format. When the ADBTEP2 program runs Db2 High Performance Unload on a partitioned table space, it always unloads each partition into a separate data set. For a work statement list that is not created using ALTER or Db2 Object Comparison Tool, you must ensure that subsequent handling of the output from the unload operation is managed appropriately.