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

Memory Page

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

To open the Memory page

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

Charts on the Memory 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
Memory Usage: Current OR Peak

If the Current option is chosen from the associated drop-down menu, the chart shows the current size of the working set of the selected process. The working set is the set of memory pages touched recently by the threads in the process.

If the Peak option is chosen from the associated drop-down menu, the chart shows the peak size of the working set of the selected process(es) since they were started.

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.
Virtual Address Space: Current OR Peak

If the Current option is chosen from the associated drop-down menu, the chart shows the current size of the total address space of the process. A process is limited to 2GB of address space no matter how much free RAM may be available.

If the Peak option is chosen from the drop-down menu, the chart shows the peak total address space of the selected process(es) since they were started.

Page Faults For the specified applications, this corresponds to the Page Faults chart in the Process History page of the Processes drilldown.

 

Related Topics

Disks Page

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

To open the Disks page

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

Charts on the Disks 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

Disk Reads

For the specified applications, this corresponds to the Disk Reads chart in the Logical Disk Activity page of the Disks drilldown.

Disk Writes

For the specified applications, this corresponds to the Disk Writes chart in the Logical Disk Activity page of the Disks drilldown.

Disk I/O

For the specified applications, this corresponds to the Disk I/O chart in the Logical Disk Activity page of the Disks drilldown.

Disk Queue

For the specified applications, this corresponds to the Disk Queue chart in the Logical Disk Activity page of the Disks drilldown.

Disk Transfer Time

For the specified applications, this corresponds to the Transfer Time chart in the Logical Disk Activity page of the Disks drilldown.

Disk Load

For the specified applications, this corresponds to the Disk Load chart in the Logical Disk Activity page of the Disks drilldown.

 

Related Topics

Alarm Log

The Alarm Log drilldown displays information on the alarms associated with the selected connection.

To open the alarm log

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

Notes:

  • The Alarm Log drilldown is common to all Spotlight applications. See Spotlight Alarms for more information.
  • The alarms are specific to the current Spotlight connection. Spotlight Alarms

 

Related Topics

View | Options

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

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating