Analyzing Db2 CPU Usage

This topic contains information about considerations for analyzing Db2® CPU usage.

Db2 CPU Usage
Db2 uses MVS cross memory services extensively in processing application requests. As a result, the majority of CPU time consumed in processing thread activity is attributed by MVS SRM to the thread-originating (user's) address space, not to one of the Db2 system address spaces (SSAS, DBAS, IRLM).
CICS Attachments
For threads that originate from the CICS/Db2 attachment, the reported thread CPU usage is entirely attributable to the CICS/Db2 thread. In other words, it is entirely attributable to the CICS/Db2 attachment TCB servicing the thread.
Non-CICS Attachments
Analysis of CPU use in non-CICS environments (IMS™, TSO, CAF, batch, and utilities) must take several factors into account, including the following:

Parent topic: Classic User Interface