IBM Books

User CPU Time used by Agent


Snapshot Information Level
Application

API Structure(s)
sqlm_appl

Monitor Group
Basic

Resettable

Yes

 

API Element Name
Element Type

agent_usr_cpu_time
counter

 

Description:  The total user CPU time (in seconds and microseconds) used by the database manager agent process.

Usage:  This element along with the other related CPU-time elements can help you understand the level of activity within an application, and may help you identify applications that could benefit from additional tuning.

It includes CPU time for both SQL and non-SQL statements, as well as CPU time for any fenced User Defined Functions (UDFs) and DARI functions executed by the application.
Note:If this information is not available for your operating system, this element will be set to 0. For example, it is not available for OS/2.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]