Chat now with support
Chat with Support

Spotlight on DB2 6.9.3 - User Guide

Spotlight on IBM DB2 LUW (Linux, Unix, and Windows)
New in This Release Getting started with Spotlight on IBM DB2 LUW Desktop features specific to Spotlight on IBM DB2 LUW Spotlight on IBM DB2 LUW drilldowns
About Spotlight on IBM DB2 LUW drilldowns Buffer Pool Analysis drilldown Client Application Analysis drilldown Database Analysis drilldown Database Manager Summary drilldown Diagnostic Log drilldown FCM Analysis drilldown Tablespace Analysis drilldown Top SQL drilldown Operating System drilldown Workload Management Analysis drilldown
Spotlight on IBM DB2 LUW alarms Spotlight on IBM DB2 LUW Options Tuning SQL statements in Spotlight on IBM DB2 LUW
Spotlight Basics
Spotlight Connections Monitor Spotlight Connections Alarms Charts, Grids And Home Page Components View | Options Troubleshooting
Spotlight History Spotlight on Windows
Connect to Windows Systems Background Information Home Page Alarms Drilldowns View | Options Troubleshooting
Spotlight on Unix About us Third-party contributions Copyright

Process CPU Utilization Alarm

This alarm becomes active when a process is sustaining a high CPU load.

When this alarm is active, you may need to:

  • Investigate what the application is doing: a high CPU load may be an expected activity.
  • Terminate the application if it is not responding. Some applications do not terminate through Windows Task Manager; if this does not work, use the KILL.EXE command from the Windows 2000 resource kit, or the TASKKILL.EXE command on Windows XP or Windows 2003 systems.
  • Consider upgrading the system's processor.


Processor Queue Length Alarm

This alarm becomes active when the length of the processor thread queue reaches a threshold for sustained activity.

A long sustained queue length indicates a processor bottleneck - leading to overall system degradation.

To rectify this, you should look at:

  • The Processes page of the Processes drilldown to see which Windows process is consuming the CPU.
  • Possibly moving some processing activities to another system.
  • Add an additional CPU to the system – the waiting threads will be load balanced between all available processors.
  • Upgrade to a faster CPU. This will allow the CPU to process threads faster, but may not reap the same rewards as adding an additional CPU.


Related Topics

Read Hit Alarm

This alarm is activated when the proportion of file read requests that can be sourced from memory cache rather than disk drops below a threshold.

When this alarm is current you should:

  • Look at the NBT page of the Network drilldown.

    If there is a large number of read requests coming from the network clients, the cache can be inundated and temporarily of little use.

  • Look at increasing the physical memory of the system.


Related Topics

System Up Time Alarm

This alarm is activated when the system up time exceeds the value specified in the related threshold.


Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating