Monitoring query workloads that run on DB2 for z/OS

You can use the to define monitor profiles for monitoring the performance of SQL statements that run on DB2® for z/OS® Version 9 new-function mode subsystems and data sharing groups.

Before you begin

About this task

You can create a monitor profile and then use it to capture the normal or exception SQL statements as a workload:

After you capture the workload, you can run advisors to tune the performance of the SQL statements in the workload as a group, or select individual SQL statements for detailed analysis and tuning. You can also capture a snapshot of the monitored SQL statements at a later time to verify performance improvements.

Procedure

To create a monitor profile and start monitoring:

  1. Create a monitor profile:
    1. Open the Monitor List view by clicking the Monitor List tab. If the tab is not visible, click Window > Show View > Monitor List.
    2. In the Monitor List view, select the subsystem that runs the SQL statements that you want to monitor from the list, and connect the client to this subsystem if the connection is not opened.
    3. Create a monitor profile:
      1. In the Monitor List view, click Monitor profile > New.
      2. Follow the instructions in the Monitor wizard to define the attributes of the monitor profile.
      3. Click Finish. A monitor profile is created. You can find it in the Monitor Profile list.
  2. When you are ready to start monitoring, click Monitoring > Start Monitoring to start monitoring. When you start monitoring, all enabled monitor profiles are started.

What to do next


Feedback