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

History Browser

An important feature within Spotlight is the ability to display, collect and replay the behavior of a Spotlight connection at a specified point in time such as when an important alarm was raised.

The details shown via the History browser are identical in format to those displayed by Spotlight in its "live" state, so you can view historical data in the same way as you would view a live connection.

To view Spotlight history

  1. Right click the connection in the Spotlight Browser Live connections or All connections.
  2. Select Browse History.

Select an event in the snapshot list.

The Spotlight browser displays a tree of alarms and snapshots in chronological order, together with some basic navigation controls.

Action

Description

Click Last week, Today etc.

Spotlight maintains a list of snapshots that have been raised for each day in the specified historical period. Click a day to have Spotlight display a list of all snapshots that were recorded for that day.

Click a snapshot or alarm

View the status of the connection at the time of the snapshot or alarm.

Right click | Live view Return the view of this connection to the present time. Live connections
Right click | History Interval Define the interval between snapshots displayed in the History browser. From the drop-down list, choose the frequency with which you want to display a snapshot.

History browser toolbar

Control

Description

Previous alarm. Show the snapshot corresponding to the alarm before the one currently displayed.

Previous snapshot. Show the snapshot immediately before the one currently displayed.

Play (plus Playback speed). Activate playback mode. This automatically steps through the snapshots in sequence.

Note: Click the down arrow to select a playback speed. Select Custom to define a playback speed.

Next snapshot. Show the snapshot immediately after the one currently displayed.

Next alarm. Show the snapshot corresponding to the next alarm after the one currently displayed.

Select date/time. Click to nominate the date and time to display. Spotlight will find the snapshot closest to this time to display.

Notes:

  • While you are viewing historical data the connection identifier at the top right of the window indicates the date and time of the snapshot. On the Spotlight home page the console status bar indicates "History Browser".
  • An easy way to view the history for a particular alarm is through the Alarm Log. Right-click the alarm and select Show Selected Entry In | History Browser. Alarm log
  • To view the recent history of a Spotlight home page component, right click the component and select Show History. Spotlight Home Page Components
  • Spotlight History is installed if you click Help | About Spotlight | Spotlight Modules and under the heading Spotlight Console see Light-weight XML repository. You can customize the storage of history data. Configure Spotlight - View | Options

 

Related Topics

Welcome to Spotlight

History Browser

Spotlight Home Pages

The Spotlight Home Page is the main page for the monitored system. It highlights obvious bottlenecks and problem areas. Statistics and flows are updated in real time.

To see the Spotlight Home Page

  1. Select a connection from the Spotlight Browser.
  2. Click Home.

About the Spotlight home page

  • The connection identifier in the upper right corner of the Spotlight console identifies the system being monitored. Alongside the connection identifier there may be additional icons. The following activity icon indicates whether Spotlight is collecting data from the connected system.

  • The home page can show real (live) data or a historical snapshot. When the home page is showing a historical snapshot the words History Browser are written in the bottom left corner of the console and the recorded date and time are shown in the top right corner. History Browser
  • A panel is a visual feature that groups related components on the Spotlight home page. Panels may be connected by data flows that illustrate the rate at which the system is performing. The groupings reflect how your system works. Components change color as alarms are raised for the metrics they contain. Spotlight Home Page Components

 

Related Topics

Calibrate Spotlight Connections

Spotlight Drilldown Pages

A drilldown contains one or more pages that display a detailed breakdown of the monitored system's performance.

To open a drilldown

  1. Select a connection from the Spotlight Browser Live connections or History Browser.
  2. Click the relevant drilldown button on the Spotlight toolbar. Drilldown buttons are dependent on the Spotlight application. For help, click Help | Contents | Connection type | Drilldown.

About Spotlight drilldowns

Drilldowns mainly use two different types of displays – tables and charts.

About Spotlight Grids

About Spotlight Charts

Drilldowns have the following features:

  • They can be configured to show all or some of the metrics associated with components.
  • You can access further information about displays in drilldowns by moving the mouse over the displays, or by clicking or right-clicking on them.
  • You can copy the data shown in drilldowns to other applications or save it to a file.

 

Related Topics

About Spotlight Charts

Spotlight Navigation

Return to the previous page or drilldown in the browse sequence

Click the down arrow to select the page to return to.

Note: Back is disabled at the start of the browse sequence.

Toolbar Menu Shortcut
Click

Click View | Back.

Press ALT+LEFT

View the next page or drilldown in the browse sequence

Click the down arrow to select the page to go to.

Note: Forward is disabled at the end of the browse sequence.

Toolbar Menu Shortcut
Click

Click View | Forward.

Press Alt+Right

Return to the Spotlight home page

Toolbar Menu Shortcut
Click

Click View | Close Drilldown.

N/A
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating