Preparing to intercept the DSNUTILB program and Db2 utilities

The Db2® UET DSNUTILB intercept is a front end to the DSNUTILB program and the Db2 utilities. You must use the intercept to implement the Db2 UET enhancements specifically for the LOAD utility, the REORG TABLESPACE utility, and the CHECK DATA utility. You can also use the intercept to block and cancel threads on Db2 objects that are to be used in these and other Db2 utilities.

To use the Db2 UET DSNUTILB intercept, you must perform the following configuration tasks:
  • Create a DSNUTILB intercept policy in XML and specify the policy member in the started task PROC.

    The policy specifies the Db2 subsystem or subsystems for which to perform DSNUTILB interception and optionally specifies rules that control the blocking and canceling of threads on Db2 objects. For more information, see Defining and using a DSNUTILB intercept policy.

  • Make sure that the started task initialization options that pertain to mapping tables and the intercept worklist-error tables are set appropriately for your environment and intercept processing needs.

After you perform these configuration tasks, the DSNUTILB intercept component can intercept the DSNUTILB program and analyze the DSNUTILB SYSIN stream for a utility job. The intercept divides the original SYSIN stream into separate worklist steps, each including a single utility command (for example, LOAD) and any applicable set-up statements (for example, LISTDEF, TEMPLATE, or OPTIONS). Db2 UET examines the worklist steps and the DSNUTILB intercept policy that you created to implement the enhanced processing for the Db2 utilities.

From time to time, you might need to perform some intercept management tasks. For example, you might to need to terminate a utility for which interception has occurred in a manner that removes the associated worklist data.