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

Data collection

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

 

Windows Applications Metrics

Spotlight on Windows allows you to single out individual processes (or a group of processes) on a Windows system for particular analysis. The details of that analysis are displayed in the Single Application drilldown.

Use Windows Applications Metrics to choose one or more running processes for analysis.

To configure Windows Applications Metrics

  1. Click View | Options
  2. Click Data Collection | Windows Applications Metrics
  3. Configure the following options:

    Option Description

    Processes

    Select the processes on the Windows system that you want to analyze.

    CPU

    Select the CPUs on the Windows system whose processes you want to analyze.

    Disks

    Select the disks on the Windows system whose processes you want to analyze.

    NICs

    Select the NICs on the Windows system whose processes you want to analyze.

 

Related Topics

CPUs Page

Memory Page

Disks Page

Windows Event Log Metrics

The Windows Event Log Metrics dialog allows you to define and edit the logical rules that govern which Windows events are displayed in the Event Log drilldown, and allows you to configure a number of Event Log settings.

To configure Windows Event Log Metrics

  1. Click View | Options
  2. Click Data Collection | Windows Event Log Metrics
  3. The Global Rules tab is to the front. Configure this page.

Global Rules

Enable the keeping of event logs and specify the rules that govern the recording of event log data.

Option Description

Enable Event Logs

Select to permit the display of event log data in the Event Log drilldown. No event log data is displayed while this is deselected.

List of rules to apply to event log items

The list of event log rules defined for the current connection.

  • Click on a rule to highlight it.
  • Select the checkbox associated with the rule to enable it. Disabled rules have no effect on the data displayed in the Event Log drilldown.

Add

Click to create an event log rule. Event Log Rule Editor

Edit

Highlight a rule. Click to modify the highlighted rule. Event Log Rule Editor

Delete

Highlight a rule. Click to remove the highlighted rule from the list.

Rename

Highlight a rule. Click to change the display name of the highlighted rule.

Copy

Highlight a rule. Click to create a copy of the highlighted rule. Usually this is done as the basis for creating a rule that is similar to the copied rule.

Enable All

Click to enable (select) all the rules in the list.

Disable All

Click to disable (deselect) all the rules in the list.

Move Up

Rules are applied in the order in which they appear in the list. Click to move the highlighted rule higher in the list, and so be applied earlier.

Move Down

Rules are applied in the order in which they appear in the list. Click to move the highlighted rule lower down the list, and so be applied later.

Connection

Specify the details of what events are recorded for the current Spotlight connection and how long they are kept.

Option Description

Display events from the...

Select the logs to show in the Event Log drilldown. The options may include:

  • Application log
  • Directory Service log (Windows domain controllers)
  • DNS Server log (Windows DNS servers)
  • File Replication Service log (Windows domain controllers)
  • Security log
  • System log

The Directory Service and File Replication Service event logs are available only for Windows 2000 domain controllers. The DNS Server event log is available only for DNS servers. Under Windows 2000, the only logs available for view are the Application log, Security log, and System log.

Limit each event log to a maximum of...

Limit how long events are displayed in the Event Log drilldown before being deleted.

 

Related Topics

Event Log Alarm

Event Log Page

Windows Files Metrics

Track the growth of specified files (usually log files) in your Windows system. Spotlight reports an alarm when a page approaches the maximum file size you have set.

To open the Windows Files Metrics dialog

  1. Click View | Options
  2. Click Data Collection | Windows Files Metrics

About the dialog

Option Description

File list

The list of files whose size is monitored for the current connection. There are two columns in this table: the File name and the Maximum size you have specified for the file.

Note: The maximum file size listed on this page does NOT prevent the specified file from growing beyond that size. However, if the file exceeds that maximum size, Spotlight raises a critical alarm.

Add

Click to add a file to the list of those tracked by Spotlight. Define Files to Monitor in Windows Files Metrics

Edit

Highlight a file. Click to change the settings for the highlighted file. Define Files to Monitor in Windows Files Metrics

Delete

Highlight a file. Click to remove the highlighted file from the list.

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating