Monitoring zIIP and zAAP specialty engine use for Db2
You can use various facilities to monitor how Db2 uses IBM® z Integrated Information Processor (zIIP) and IBM zEnterprise® Application Assist Processor (zAAP) specialty engines.
Before you begin
Ensure that sufficient zIIP resources are configured for Db2, as described in Configuring zIIP capacity for Db2 workloads.
About this task
The Db2 accounting trace records provide information related to application programs including processor resources consumed by the application. Accumulated specialty engine CPU time is not accumulated in the existing class 1, class 2, and class 7 accounting fields. Separate accounting fields are defined to indicate how much time is spent on specialty engines.
Also, the z/OS® Resource Measurement Facility (RMF) provides information on specialty engine usage to help you identify when to consider purchasing a specialty engine or adding more specialty engines.
Procedure
To monitor zIIP and zAAP specialty engine use for Db2 Db2 for z/OS:
- Monitor the Db2 accounting reports for growth in the following time statistics, which might result from zIIP constraints:
- Class 3 suspension time (Log write I/O and other read I/O)
Class 2 not accounted time. This time includes elapsed time for zHyperlink I/O, even if zHyperlink I/O processing is suspended.