Skip to content

Workload Manager

Ensure safe, efficient high utilisation with the Db2 for z/OS Workload Manager ZMARS module by optimising WLM policy design and performance.

Workload Manager

The Db2 for z/OS Workload Manager ZMARS module will examine your Workload Manager (WLM) policy design and setup to evaluate whether it is designed defensively to enable you to run safely and efficiently at very high server utilisation.

This is to protect the performance of the Db2 for z/OS server, and to enable critical business applications running against Db2 for z/OS to meet their performance objectives.

The study team will produce an easily consumable report with prioritised findings and recommendations that, if implemented, will enhance your ability to run Db2 for z/OS defensively and efficiently at high server utilisation whilst meeting performance and cost objectives of business-critical applications.

Workload Manager module ZMARS

Why It Matters

Workload Manager is a critical component of the technical infrastructure supporting Db2 for z/OS. If the policy is not designed and setup correctly then during peak periods:

  • Critical business transactions may not meet performance objectives during peak periods
  • Db2 application threads may suffer CPU starvation, causing sympathy sickness across the data sharing group
  • Performance of Db2 for z/OS server address spaces may be degraded
  • A performance issue can escalate into an availability issue

Key Action Areas

The Triton study team will evaluate the following:

  • Is the use of CPU by Db2 system address spaces protected from being pre-empted
  • Is there protection to avoid thread CPU starvation
  • Is there sufficient low priority non-Db2 work that can be sacrificed to allow high priority Db2 application work to meet performance objectives at high server utilisation
  • Are the performance goals for the Db2 work set realistically and are they being achieved;
  • Is there sufficient zIIP capacity to avoid spilling over to general purpose processing capacity with associated latency and implied extra software cost,
  • Is there intelligent use of reporting classes.
The ZMARS Modular Approach
ZMARS consists of multiple modules, giving you the flexibility to choose which ones to include or prioritise based on your specific needs. Each ZMARS study is fully customised for you, based on the modules you select. See a selection of modules below.
Read more

System and Application Performance Monitoring

Do your real-time monitoring and historical performance reporting practices help you proactively identify and prevent service disruptions caused by performance and workload deviations from the normal?

Read more

Distributed Application Connectivity to Db2 for z/OS

Have you configured your distributed environment optimally, focussing on client configuration, workload balancing, resilience, and efficient resource utilisation?

Read more

Application Design and Quality Assurance

Have you set up robust SQL DML and DDL standards which are policed and enforced, to prevent poor database design and badly behaved applications from being promoted to production where they can compromise service availability?