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

Event Log

The Windows Event Log is where application or operating system information is written and can be accessed by system administrators. Spotlight on Windows allows you to analyze event data from your Windows system's various logs, and to display the relevant data in the Event Log drilldown.

Note: If the content of this page is disabled then Event Logs are disabled. You can enable them. Windows Event Log Metrics

To open the Event Log page

  1. Select the Spotlight connection in the Spotlight Browser.
  2. Click Event Log.

Page Control Description
Event Log

Select an event log to show in the Event Grid. Depending on the monitored system, the logs to select from may include:

  • Any — Combine all event logs.
  • Application log — General application events and some system service messages.
  • Directory Service log — Directory service events (only for Windows domain controllers).
  • DNS Server log — DNS server events (only for Windows DNS servers).
  • File Replication Service log — File replication service events (only for Windows domain controllers).
  • Security log — Operating system audit events. Logged according to the audit settings that have been configured on the system.
  • System log — Operating System and most system service messages.
Event Grid A display of the selected event log.
Total The number of entries in the selected log.
Days The period of time for which the oldest entries in the log have been kept.

About the Event Grid

Notes:

  • Not all of these columns will be visible by default. To view hidden columns, right-click the grid heading and choose Organize Columns... from the shortcut menu.
  • Click an event to display the Event Log Details page.
  • Right click the body of the grid and select Event Log Options to configure the Event Log. You can filter, alarm or expand the list of Event Log items. Windows Event Log Metrics.
Column Description

Date/Time

The time when the entry was entered into the Windows event log, not when it was brought into Spotlight on Windows.

Event ID

A code that identifies the event.

Message

A description of the event.

Source

The software that logged the event.

Type

The type of event:

  • Warning — There is something out of the ordinary but not an outright failure.
  • Error — Something has failed.
  • Information — General information on what is happening on the system.
  • Security — There are numerous security based message types. These come from the security log and the system auditing that has been configured on the system.

Category

The category of the event. This is used in auditing, and is primarily used by the security log.

Log

Where the error message was generated:

  • Application log — General application events and some system service messages.
  • Directory Service log — Directory service events (only for Windows domain controllers).
  • DNS Server log — DNS server events (only for Windows DNS servers).
  • File Replication Service log — File replication service events (only for Windows domain controllers).
  • Security log — Operating system audit events. Logged according to the audit settings that have been configured on the system.
  • System log — Operating System and most system service messages.

Note: The Directory Service and File Replication Service event logs are available only for Windows domain controllers. The DNS Server event log is available only for DNS servers.

Severity

Shows information on alarms associated with the event log item. This is assigned by the Spotlight on Windows event log rules (available through the Windows Event Log Metrics in Spotlight on Windows Options).

Clear

Select to acknowledge the event and return its status to Normal.

Computer

The name of the machine where the event occurred.

User

The user account which instigated the event log item. This is particularly pertinent to security items.

 

Related Topics

Single Application

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

 

Summary Page

The Summary Page of the Single Application drilldown provides an overview of the Windows performance for the one or more applications chosen in the Windows Applications Metrics options of the Spotlight on Windows Options window.

To open the Summary page

  1. Select the Spotlight connection in the Spotlight Browser.
  2. Click Single Application | Summary.

Charts on the Summary page

Notes:

  • 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.
  • To choose applications to measure the performance of, right click the page and select Select Application. This opens the Windows Applications Metrics dialog. Windows Files Metrics
Chart Description
Processors For the specified applications, this corresponds to the CPU Utilization chart chart in the CPUs page of the CPU drilldown.
Paging For the specified applications, this corresponds to the Paging chart in the Summary page of the Memory drilldown.
Virtual Memory Size For the specified applications, this corresponds to the Virtual Memory Size graph on the Memory chart in the Process History page of the Processes drilldown.
Processor Queue Length For the specified applications, this corresponds to the Processor Queue Length chart in the Activity Summary drilldown.
Disk Queue Length For the specified applications, this corresponds to the Disk Queue Length chart in the Activity Summary drilldown.
Network Packets For the specified applications, this corresponds to the Network Packets chart in the Activity Summary drilldown.

 

Related Topics

CPUs Page

The CPUs Page of the Single Application drilldown provides an overview of the CPU performance for the one or more applications chosen in the Windows Applications Metrics options of the Spotlight on Windows Options window.

To open the CPUs page

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

Charts on the CPUs page

Notes:

  • 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.
  • To choose applications to measure the performance of, right click the page and select Select Application. This opens the Windows Applications Metrics dialog. Windows Files Metrics
Chart Description
CPUs For the specified applications, this corresponds to the sum of all graphs on the Processor chart in the Process History page of the Processes drilldown.
CPU per Process This displays the CPU resources consumed by each application chosen for analysis in the Single Application drilldown. For the specified applications, this corresponds to the %CPU column in the Processes grid in the Processes drilldown.
Queue Length For the specified applications, this corresponds to the Server Work Queues chart on the CPUs page of the CPU drilldown.
IO Operations For the specified applications, this corresponds to the IO per second column in the Processes grid on the Processes drilldown.

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating