This site will undergo a maintenance outage on Saturday, 13 September beginning at 2:30 AM Central/1 PM IST for a platform upgrade. The downtime will be ~three hours.

Default language.

CPU usage monitors (area = WKLD)

The monitors listed in the following table measure the use of CPU time by a transaction.

Related topic

Db2-workload-monitors

Monitor

Title

View name

Description, Parameters, Warning

@CPU

Average CPU Used

D@CPU

Reports the average CPU time used by a transaction during the sampling period (QWACSPCP + QWACEJST - QWACBJST)

Parameter: User-defined identifier for the request or blank.

Warning

DW0180W (nn) hh:mm:ss AVERAGE CPU USED(parm) = v (>thrshld)

@CPUD

Average CPU in Db2

D@CPUD

Reports the average CPU time in Db2 used by a transaction during the sampling period (QWACAJST + QWACSPPT)

Parameter: User-defined identifier for the request or blank.

Warning

DW0190W (nn) hh:mm:ss AVG CPU IN DB2(hh:mm:ss) = v (>thrshld)

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*