IBM Books

System CPU Time used by Statement


Snapshot Information Level
Application

API Structure(s)
sqlm_appl
sqlm_stmt

Monitor Group
Statement
Statement

Resettable

No

 

API Element Name
Element Type

stmt_sys_cpu_time
counter

 

Description:  The total system CPU time (in seconds and microseconds) used by the currently executing statement.

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

This element includes the CPU time for both SQL and non-SQL statements, as well as the 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 ]