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

Features of Spotlight on Windows

  • Spotlight presents a visual representation of process flows within a Windows operating system, allowing you to observe actual system activity in real time.
  • It visually identifies system bottlenecks and provides extensive drilldown capabilities.
  • It displays the details of problem areas, including CPU resources, paging activity, and memory use, for rapid problem resolution.
  • It uses visual and audible warnings to alert you when performance metrics exceed acceptable thresholds.
  • Its drilldowns provide detailed information about a specific component allowing you to pinpoint the source of problems.
  • Spotlight learns the normal range of values for your system.
  • Spotlight assesses the normal rate of process flows via a calibration process and sets the display speed of the visual indicators accordingly.
  • It can simultaneously observe multiple systems.
  • It is easy to install.

An Overview of The Windows Architecture

This diagram summarizes the architecture of Windows. This architecture is the basis for the design of the Spotlight home page. Spotlight Home Page

  1. The Process Manager keeps track of processes and their threads. It is responsible for passing the threads to run on the CPU, although this is done through the Kernel.

    The Process Manager has access to the low level subsystems through the Kernel. It has no direct access to any hardware.

  2. The Kernel is responsible for talking directly to hardware components such as Physical Memory and the CPU. (It actually talks through the Hardware Abstraction Layer (HAL); this can be thought of as transparent for architectural purposes however).
  3. The Virtual Memory Manager is responsible for managing the physical memory. This is done through the Kernel.

    The Virtual Memory Manager is also responsible for Application Virtual Memory Address space. Applications cannot talk directly to underlying systems such as Physical Memory or CPU. Applications use the Virtual Memory Manager to talk to underlying systems.

  4. The Virtual Memory Manager is responsible for managing the physical memory. This is done through the Kernel.
  5. The Virtual Memory Manager maps part of its Virtual Address space addresses to space in a disk page file. The Virtual Memory Manager has no direct access to hardware however, and must therefore pass its request through the I/O Manager.

    The I/O Manager is responsible for talking directly to hardware components such network and disk.

    The Virtual Memory Manager is responsible for keeping track of the Virtual Address Space, and what addresses are allocated. The Virtual Memory Manager is also responsible for managing system virtual memory on disk. It does this by calling various I/O Manager functions.

  6. Applications must call the I/O Manager to access disk and network resources.

Home Page

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

 

Spotlight 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.

Related operating system statistics are grouped together on panels that are connected by a series of graphical flows and icons. Spotlight updates these flows in real time so you can see how quickly data is moving through the system. The icons change color as Spotlight alarms are raised, upgraded, downgraded and canceled.

The display is based on the Windows architecture diagram. Windows Architecture Overview

To see the Spotlight on Windows Home Page

  1. Select the Spotlight on Windows connection from the Spotlight browser.
  2. Click .

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating