This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.
Next Generation Technology Reorg for DB2 for z/OS
Next Generation Technology
What options are available to tune and optimize the NGT Reorg drain processing ?
Using the +DRAIN_DLOCKS parameter, you can control when to display claims and locks that are preventing a drain from being obtained.
The +DRAIN_DLOCKS parameter determines whether to display the claims and locks that are preventing the drain from being obtained. You can choose to display the claims and locks after each attempt, after the last attempt, or not at all. The +DRAIN_DLOCKS is available to NGT products via the application of PTF BQU2620.
The values are defined as follows:
The utility does not display claims and locks.
The utility displays claims and locks after each failed attempt to obtain the drain.
(default) The utility displays claims and locks only after all attempts to obtain the drain have failed.
+CATCHUP_CYCLES was introduced with PTF BQU1698. While not directly controlling drain processing, it does control the number of iterations of Change Apply cycles NGT Reorg will go through prior to either going into the switch phase or terminating the utility. It is similar to LONG LOG, with the default being 100 and the maximum 1000.
The +DRAIN_RDELAY parameter specifies the number of seconds an NGT utility process waits between attempts to acquire a failed drain. The feature was made available with PTF BQU2520.
The last piece of the equation was added with PTF BQU2907. This PTF added the +QTIMEOUT parameter. This parameter specifies the maximum number of seconds to wait for a drain. The difference between +QRETRY and +QTIMEOUT is that the +QRETRY duration covers both the time to wait for a drain and the time to hold a drain, while the +QTIMEOUT portion covers only the wait time.
Using all of these parameters together provides the most flexibility and complete control over drain processing while running an NGT Reorg.
For a complete description of these parameters, default values, permissible settings and usage recommendations please refer to the
Next Generation Technology Reorg for DB2 for z/OS 12.1 guide on the BMC support documentation page.