Viewing workload objective monitor charts
Workload objectives monitors charts show monitor data for all defined workloads for the previous four hours in 15 minute intervals. They show average response time, the percentage of threads that meet response goals per workload, and thread rate per second.
Under the Configurations node, right-click to fully expand the Monitor Workloads by Interval node.
Under the Values per Workload node, double-click the All 3 Values chart.
The container of charts shows all three monitor values per workload together for easy comparison. These charts help you see the bigger picture, for example, whether a response time spike in one workload could be related to an increased thread rate, either for that workload or another workload.
The charts show data from the individual workload objectives monitors that are automatically activated per defined workload. MainView for DB2 distributes definitions based on DB2 connect types for workloads that are mostly likely to have consistent processing characteristics, including the transaction type workloads that typically must meet service level agreements, such as CICS, IMS MPPS, and distributed DBAT workloads. Response time targets are set based on the In-DB2 elapsed time.
To make this information even more valuable for your systems, you can easily modify the default response times to use total elapsed time, or set different response time goals for these general workloads. You can also add new workloads for your site's critical applications, defined by various DB2 thread qualifiers. (For more information about workload setup, see the DWKLDDEF view.)
The three-chart layout is good for comparisons, but you might want to see one chart in a larger format.
- To maximize a chart, do one of the following actions:
- Click the standard maximize or minimize icons in the upper right corner of each chart.
- Use the cycling icons
at the top of the container tab. Click the forward or backward arrow icon to maximize a chart. To redisplay the three-chart layout, click the circle icon. Open the individual chart in the navigation tree.
Right-click any data point in the chart and select the Hyperlink option to see the 90-second monitor samples within the selected 15-minute interval in the related plot view.The view opens in a separate tab. Close this tab after you have viewed it.
- To show the same data across multiple DB2 subsystems, return to the context tree to set the context to a predefined SSI context.
- Right-click on any defined SSI context and select Set context.When you change the context, the product tree collapses.
Open the Configurations node, fully expand theMonitor Workloads node and scroll down to the SSI Context part of this node.
Under Grand Totals per DB2 (ALLWORK) select Thread Rate/Sec.
The resulting chart shows thread rate per second for each DB2 in the SSI context. In this example, the DJ context shown below includes two DB2 subsystems.
You could also view total thread rate, summarized for all DB2s, under Grand Totals SSI (ALLWORK). The ALLWORK monitor captures all thread activity.