Hi,

In Db2 12 for z/OS context, I need a sample JCL to integrate IBM High Perfomance Unload (HPU) with the utility REORG TABLESPACE using INZUTILB (HPU) in the UNLOAD phase of the REORG utility. I'm not able to find any example. Please, can anyone help me?

Thanks in advance!

John,

As far as I am aware, you cannot plug, HPU (High Performance Unload) into a Reorg.  It has a different design to reorg.  In Physical mode it is not using the DB2 Buffer Pools (in SQL mode it does do logical extract of data).  Can use QUIESCE YES to externalise all the data In BPs  first before unload starts.  Can also use a LOCK parameter to prevent changes while the Unload is running.  HPU does have very superior parallelism to enable fast run and low CPU.  

Now Reorg Parallelism is probably dependent on partitioning the table as PBR (Partition By Range). Reorg unloads only in internal format suited to only loading back to the same table. 

So the nearest you can get to using HPU as a Reorg, is combine with LOAD REPLACE. LOAD parallelism performance is much better with PBR spaces.  Possible reason to avoid very large PBGs.  

If go this route, you have outage of the table as no equivalent to SHRLEVEL CHANGE with a Log apply phase.

I would design for switching to a CLONE table and loading that instead to avoid outage of original table.  The problem is CLONE table approach disallows triggers to capture the changes during the HPU and LOAD. So for CLONE to work, would need to put table into read only mode during the process.

So we can see HPU is not an alternative to Reorg SHRLEVEL CHANGE. HPU and LOAD with HPU doing the sort, or using DFSORT, might be an alternative only if outage of table (for update) is allowed, or minimum putting table into Read Only mode for the duration.

HPU is a very good util for efficiency with parallelism, and Multi Row Fetch options, but its goal is extract data not same a Reorg goals.