DB2 Version 9.7 for Linux, UNIX, and Windows

cpu_user - Non-kernel processing time monitor element

Time spent running user (non-kernel) code, expressed in processor ticks. Reported for Windows, AIX®, and Linux systems only. This measurement represents the aggregate for all processors on the system.

Table 1. Table Function Monitoring Information
Table Function	Monitor Element Collection Level
ENV_GET_SYSTEM_RESOURCES table function - Return system information	Always collected
ENV_GET_DB2_SYSTEM_RESOURCES table function - Return DB2(r) system information	Always collected

Usage

This measurement represents the aggregate for all processors on the system.
On AIX, this metric is reported for the workload partition (WPAR) and the logical partition (LPAR) on which the DB2® server is running.
You can use this monitor element along with the related processor timer elements to calculate processor utilization for a specific time interval on the host system. To calculate processor utilization as a percentage, perform the following steps:
1. Use the ENV_GET_SYSTEM_RESOURCES function at the beginning to the time interval to retrieve the values for the following metrics:
  - cpu_user_t1 = cpu_user
  - cpu_system_t1 = cpu_system
  - cpu_idle_t1 = cpu_idle
  - cpu_wait_t1 = cpu_wait
2. Repeat the preceding step to determine the timestamps for the same metrics at the end of the time interval for which you want to calculate processor utilization:
  - cpu_user_t2 = cpu_user
  - cpu_system_t2 = cpu_system
  - cpu_idle_t2 = cpu_idle
  - cpu_iowait_t2 = cpu_iowait
3. Calculate processor utilization using the following formula:
```
      (cpu_system_t2 - cpu_system_t1) + (cpu_user_t2 - cpu_user_t1)
100 × ----------------------------------------------------------
      (cpu_system_t2 - cpu_system_t1) + (cpu_user_t2 - cpu_user_t1) +
      (cpu_idle_t2 - cpu_idle_t1) + (cpu_iowait_t2 - cpu_iowait_t1)
```