Spotlight on DB2 6.9.3

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

Spotlight Drilldowns

Memory Page

The Memory page contains several charts.

To open the network page

Select the Spotlight on Unix connection in the Spotlight Browser.
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

Spotlight Drilldowns

CPU Page

The CPU page contains several charts.

To open the network page

Select the Spotlight on Unix connection in the Spotlight Browser.
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

Spotlight Drilldowns

Network Page

The Network page contains several charts.

To open the network page

Select the Spotlight on Unix connection in the Spotlight Browser.
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

Spotlight Drilldowns

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Spotlight on DB2 6.9.3 - User Guide

Disk Page

Memory Page

CPU Page

Network Page