CM Batch September 2019 enhancements: reduce contention and run utilities inline
jthyssen 50A79HCRE7 Visits (299)
CM Batch September 2019 Enhancements: Reduce contention and Run utilities inline
By Jørn Thyssen and Tom Ulveman Jensen
Some users of CM BATCH experienced deadlocks or timeouts when running multiple long-running CM BATCH jobs at the same time. The reasons were:
PH10086 / PTF UI65544 and PH16550 / UI65545 introduce two enhancements to address the issues:
Run utilities inline in CM BATCH execution
CM BATCH invokes utilities such as COPY, REORG, RUNSTATS, CHECK DATA, and others during WSL execution. The utilities where executed through the Db2 supplied stored procedure DSNUTILU.
In some circumstances, error messages appear in the WLM application environment in which the stored procedure runs. On high volume systems, it is difficult to find the right WLM application environment for a failed utility run. Also, running utilities through the stored procedure makes it more difficult to use DD SYSTEMPL as it needs to be allocated in the WLM application environment JCL procedure. In addition, DSNUTILU had a limit of 32KB for the length of the utility statement.
PH10086 / PTF UI65544 and PH16550 / UI65545 introduce two enhancements for CM BATCH: