Chat now with support
Chat with Support

Spotlight on DB2 6.10 - 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

CPUs Drilldown

Spotlight is a powerful diagnostic and problem-resolution tool for Windows operating systems. Its unique user interface provides you with an intuitive, visual representation of the activity on the host machine.

For information on Spotlight on Windows, see these sections

Section

Description

Background Information

Introductory material to Spotlight on Windows.

Connect to a Windows System Create / Modify / Delete connections to Windows systems.
Home Page The Spotlight home page shows the flow of information and commands between various sub-components and the size and status of internal resources such as processes, disk files and memory structures.
Alarms

Spotlight alerts you to problems with your system by issuing an alarm. You can configure Spotlight in the level of severity that constitutes an alarm, to disable an alarm, and the actions Spotlight takes on raising the alarm.

Drilldowns When you have isolated a problem, you can display a drilldown page, whose charts and tables provide a detailed breakdown of the underlying statistics.
View | Options Customize Spotlight.
Troubleshooting Solve problems using Spotlight.

For information on using Spotlight applications See

Spotlight Basics

 

CPUs Page

The CPUs page shows performance details of all the CPUs on the current Windows system. The CPUs page contains several charts.

To open the CPUs page

  1. Select the Spotlight connection in the Spotlight Browser.
  2. Click CPUs.

Charts on the CPUs page

Notes:

  • Every chart has a legend (list of symbols) to its right that describes the various series (line graphs) on the chart.
  • Click an item in the legend to highlight its series (line) in the chart. Click a second time to return the series to its normal appearance.
  • Move the mouse pointer over an item in the legend to view the current value for that series within the chart.
Chart Description
CPU Utilization

Shows the CPU utilization for all the processors on the system. Each processor is represented by a single line on the chart, and by an item in the legend at the top right of the chart.

Note: To view CPU utilization analyzed according to processing mode, see the Processing page in the CPUs drilldown.

Server Work Queues Shows the number of threads (program execution units) that are waiting to run on each processor. A sustained queue length greater than four might indicate processor congestion.
Interrupts

The Interrupts chart shows the number of interrupts per second per CPU on the Windows system. Each CPU is represented by a single graph on the chart, and by an item in the legend at the top right of the chart.

The Interrupts chart is designed to show if any CPUs on the system are bearing a disproportionate level of the I/O load.

Kilobytes Transferred

The Kilobytes Transferred chart shows the rate of kilobytes transferred per CPU on the Windows system. Each CPU is represented by a single graph on the chart, and by an item in the legend at the top right of the chart.

 

Related Topics

Processing Page

The Processing page on the CPUs drilldown shows the overall performance details of CPUs on the current Windows system. To view performance details for individual CPUs in the system, see the CPUs Page and Multiprocessor Page. The Processing page contains several charts.

To open the CPUs page

  1. Select the Spotlight connection in the Spotlight Browser.
  2. Click CPUs | Processing.

Charts on the Processing page

Notes:

  • Every chart has a legend (list of symbols) to its right that describes the various series (line graphs) on the chart.
  • Click an item in the legend to highlight its series (line) in the chart. Click a second time to return the series to its normal appearance.
  • Move the mouse pointer over an item in the legend to view the current value for that series within the chart.
Chart Description
Total CPU Utilization

Shows the combined CPU utilization for all processors on the system. Two data series are displayed:

  • User — The percentage of CPU time that is being consumed in User mode. (User mode is a restricted processing mode designed for applications, environment subsystems, and integral subsystems.)
  • Kernel — The percentage of CPU time that is being consumed in privileged mode. (Privileged mode is designed for operating system components and allows direct access to hardware and all memory.)

Note: To view CPU utilization for the individual CPUs in the system, see the CPUs Page.

Total Processor Queue Length

Shows the total number of threads (program execution units) that are waiting to be run on ALL processors. A sustained processor queue length greater than three times the number of processors can indicate processor congestion.

Note: To view Server Work Queues for the individual CPUs in the system, see the CPUs Page.

Total Process & Thread Count

This chart displays the total number of Windows processes and threads that exist.

A process is one instance of an application program or system service that is currently executing on the server. Each process will have one or more threads which are the basic entity that can be scheduled. Sophisticated application processes such as SQL Server or Exchange can have dozens of threads running concurrently.

Context Switching

The Context Switching chart shows the rate at which Windows has been processing context switches.

A Context Switch occurs when a processor switches from one thread to another. Context switches occur when a running thread voluntarily relinquishes the processor, is preempted by a higher priority ready thread, or switches between user-mode and privileged (kernel) mode to use an Executive or subsystem service.

 

Related Topics

Multiprocessor Page

The Multiprocessor page in the CPUs drilldown displays in separate charts the total processor utilization for all CPUs on the Windows system.

To open the Multiprocessor page

  1. Select the Spotlight connection in the Spotlight Browser.
  2. Click CPUs | Multiprocessor.

 

Related Topics

Processing Page

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating