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

Disk Page

The Disk page contains several charts.

To open the Disk page

  1. Select the Spotlight on Unix connection in the Spotlight Browser.
  2. Click Activity Summary | Disk.

To view charts on the Disk page

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

Notes:

  • Every chart has a legend (list of symbols) to its right that describes the various series (line graphs) on 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 The Disk Reads chart shows the rate at which data is being read off each disk.
Service Time The Service Time chart shows the sustained service time for all disks on the machine you are diagnosing. If the sustained service time of any of your disks exceeds 50 milliseconds, move your data onto the under-utilized disks.
Disk Writes The Disk Writes chart shows the rate at which data is being written to each disk.
Queue Length The Queue Length chart shows the average number of write operations waiting to be completed for each disk.
Wait Time The Wait Time chart shows the amount of time that the queue for each disk is not empty. The time is expressed as a percentage of total time.
Busy The Busy chart shows the amount of time each disk spends processing its transactions. The time is expressed as a percentage of total time.

To view the Disk page as a table

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

 

Related Topics

Memory Page

The Memory page contains several charts.

To open the network page

  1. Select the Spotlight on Unix connection in the Spotlight Browser.
  2. Click Activity Summary | Memory.

Charts on the Memory page

Notes:

  • Every chart has a legend (list of symbols) to its right that describes the various series (line graphs) on 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
Physical The Physical Memory chart shows the total physical memory (RAM) on the Unix host, and the amount of physical memory that is currently free.
Virtual The Virtual Memory chart shows the total amount of memory in use on the Unix host. This includes physical memory plus space in the paging files. A steady increase in virtual memory usage can indicate that a process on the system has a memory leak.
Paging

The Paging chart shows the rate at which pages are being swapped in and out of memory. The chart displays three data series:

  • Page In - The rate at which read requests are made to the swap device.
  • Page Out - The rate at which write requests are made to the swap device.
  • Scan rate - The rate at which the memory manager scans for a free page in swap. If this rate is rising, it indicates that system memory is under pressure.

A sustained high rate of paging can cause problems with overall system degradation due to disk thrashing and CPU load.

Note: Scan rate is not available for Linux.

Cache The Cache chart shows the percentage of recent file requests (read and write) that are satisfied by the memory cache, and that do not require a request to the paging areas on disk.

 

Related Topics

CPU Page

The CPU page contains several charts.

To open the network page

  1. Select the Spotlight on Unix connection in the Spotlight Browser.
  2. Click Activity Summary | CPU.

Charts on the CPU page

Notes:

  • Every chart has a legend (list of symbols) to its right that describes the various series (line graphs) on 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
Total CPU Usage The total CPU utilization for all processors on the Unix host.
CPU Usage by Processor The CPU utilization for each processor on the Unix host. Each processor is represented by a single line on the chart, and by an item in the legend at the top right of the chart.
Run Queues The number of threads (program execution units) that are waiting to run on the Unix host.
Context Switching

The rate at which the Unix host has been processing context switches.

A context switch occurs when a processor switches from one thread to another. Context switches occur when a running thread voluntarily relinquishes the processor, is pre-empted by a higher priority ready thread, or switches between user-mode and privileged (kernel) mode to invoke a system service.

 

Related Topics

Network Page

The Network page contains several charts.

To open the network page

  1. Select the Spotlight on Unix connection in the Spotlight Browser.
  2. Click Activity Summary | Network.

Charts on the Network page

Notes:

  • Every chart has a legend (list of symbols) to its right that describes the various series (line graphs) on 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
Network Utilization

The total rate of data traffic across all network cards (NICs) for the Unix host, measured in packets/second.

Separate graphs on the chart indicate the rates at which data packets are being:

  • Received by the Unix host from the network (Packets In).
  • Transmitted by the Unix host to the network (Packets Out).
Connections

The number of external services with which the Unix host is communicating. The graphs on this chart represent three types of connections:

  • Established - The total number of TCP/IP connections to this machine in the ESTABLISHED state.
  • TIME_WAIT - The total number of TCP/IP connections to this machine in the TIME_WAIT state, where the local socket has closed, and it is waiting for the remote end to signal that it has done the same.
  • CLOSE_WAIT - The total number of TCP/IP connections to this machine in the CLOSE_WAIT state, where the remote end of the connection has shut down, and it is waiting for the local end to do the same.
Network Utilization by Kilobytes

The total rate of data traffic across all network cards (NICs) for the Unix host, measured in kilobytes/second.

Separate graphs on the chart indicate the rates at which data is being:

  • Received by the Unix host from the network (KB In).
  • Transmitted by the Unix host to the network (KB Out).
Packets by Network Card

This chart shows the rate of data traffic for every network card (NIC) in the Unix host, measured in packets/second. For every NIC, a separate graph represents the data packets:

  • Received by the NIC from the network (Packets In).
  • Transmitted by the NIC to the network (Packets Out).
Error Rates by Network Card

This chart shows error rates for the data transferred by every network card (NIC) in the Unix host, measured in errors/second. For every NIC, a separate graph represents the errors in data:

  • Received by the NIC from the network (Errors In).
  • Transmitted by the NIC to the network (Errors Out).
Collisions by Network Card

A collision is the result of two devices trying to transmit data packets across the network at the same time. The network detects the collision of the two transmitted packets as an error, and discards them both. Both devices then need to re-send the data.

This chart shows the rate at which collisions occur for every network card (NIC) in the Unix host.

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating