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

Disks Drilldown

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

 

Logical Disk Activity Page

The Disks | Logical Disk Activity page shows information about the logical disks on this system. It includes I/O information, as well as disk space usage.

To open the Logical Disk Activity page

  1. Select the Spotlight connection in the Spotlight Browser.
  2. Click Disks | Logical Disk Activity.

To view charts on the Logical Disk Activity page

Right-click the Logical Disk Activity page and select View as Chart.

Notes:

  • Each disk is represented by a single line on the chart, and by an item in the legend at the right of the chart.
  • 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.
Chart Description
Disk Reads

Shows a recent summary of the rate at which read requests have been sent to each logical disk.

Disk Writes

Shows a recent summary of the rate at which write requests have been sent to each logical disk.

Disk I/O

Shows a recent summary of the rate at which read and write requests have been sent to each logical disk. This chart is the sum of the Disk Reads and Disk Writes.

Disk Queue

The Disk Queue chart shows the number of I/O requests that were queued for each logical disk.

Disk queue length indicates how heavily loaded a disk subsystem is. High queue lengths mean the disks are struggling to process the I/O load being put on them.

Transfer Time

The Transfer Time chart shows how long it is taking for data to be transferred between disk and memory, and includes both Disk Reads and Disk Writes.

If disk transfers are taking consistently longer than 50 ms, a disk bottleneck may be developing.

Disk Load

Shows how busy overall the individual logical disks are.

To view the Logical Disk Activity page as a table

Right-click the Logical Disk Activity page and select View as Grid.

In table (grid) mode, the page displays the information contained in the charts, plus additional information in the following columns:

Column Description
KBs Read/s The rate (in kilobytes/s) at which data is read from the specified logical disk.
KBs Written/s The rate (in kilobytes/s) at which data is written to the specified logical disk.

 

Related Topics

Physical Disk Activity Page

The Disks | Physical Disk Activity page shows information about the logical disks on this system. It includes I/O information, as well as disk space usage.

To open the Logical Disk Activity page

  1. Select the Spotlight connection in the Spotlight Browser.
  2. Click Disks | Physical Disk Activity.

To view charts on the Physical Disk Activity page

Right-click the Physical Disk Activity page and select View as Chart.

Notes:

  • Each disk is represented by a single line on the chart, and by an item in the legend at the right of the chart.
  • 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.
Chart Description
Disk Reads

Shows a recent summary of the rate at which read requests have been sent to each physical disk.

Disk Writes

Shows a recent summary of the rate at which write requests have been sent to each physical disk.

Disk I/O

Shows a recent summary of the rate at which read and write requests have been sent to each physical disk.

Disk Queue

The Disk Queue chart shows the number of I/O requests that were queued for each physical disk.

Disk queue length indicates how heavily loaded a disk subsystem is. High queue lengths mean the disks are struggling to process the I/O load being put on them.

Transfer Time

The Transfer Time chart shows how long it is taking for data to be transferred between disk and memory, and includes both Disk Reads and Disk Writes.

If disk transfers are taking consistently longer than 50 ms, a disk bottleneck may be developing.

Disk Load

Shows how busy overall the individual physical disks are.

To view the Physical Disk Activity page as a table

Right-click the Physical Disk Activity page and select View as Grid.

In table (grid) mode, the page displays the information contained in the charts, plus additional information in the following columns:

Column Description
KBs Read per sec The rate (in kilobytes/s) at which data is read from the specified physical disk.
KBs Written per sec The rate (in kilobytes/s) at which data is written to the specified physical disk.

 

Related Topics

Logical Disk Space Usage Page

The Disks | Logical Disk Space Usage displays a graphical view of used and available space on all logical drives.

To open the Logical Disk Space Usage page

  1. Select the Spotlight connection in the Spotlight Browser.
  2. Click Disks | Logical Disk Space Usage.

Note: Use the Disk Space By... control to switch between Disk Space (GB) and Disk Space (%).

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating