Skip to Content

Default language.

Defining Db2 workloads

This section discusses how to define a Db2 workload.

A workload groups Db2 threads for performance reporting and analysis. You build a Db2 workload by using a workload definition dialog called DWKLDDEF, which allows you to:

  • Establish a service-level objective for expected workload performance

    Performance is measured by the service-level objective set for a workload. The service-level objective comprises:

    • Response time limit set as a maximum threshold for acceptable performance
    • Percentage of completed transactions within the specified response time limit
  • Assign a composite name to that workload grouping

Related topic

Managing-views

Your defined service-level objectives and composite workloads are reported by MainView VistaPoint.  also reports your defined workloads in response-time views.

This section contains the following topics:


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Ops Monitor for Db2 13.1