Workload Manager
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.

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.
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?
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?
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?