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.
About this task
You can create a monitor profile and then use it to capture
the normal or exception SQL statements as a workload:
- Use a normal monitor profile to capture the information about
the normal processing of all statements of the workload.
- Use an exception monitor profile to detect poorly and abnormally
performing SQL statements.
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.