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

Percentage Busy Alarm (Most Active Disk)

The Most Active Disk gauge in the Disk Activity panel shows the disk with the highest read/write rates.

The Percentage Busy alarm is triggered when the read/write rate of the most active disk exceeds a specified threshold.

A disk that is more than 20% busy (according to Sun Performance and Tuning by A. Cockroft) should be investigated, and possibly have data on it split up and moved to different disks.

The type of alarm that is activated is determined by the percentage of read/write activity experienced by the disk.

 

Related Topics

Swap Space Alarm

The Swap Space panel on the main Spotlight on Unix window shows the total amount of swap space allocated to the machine you are diagnosing, and the amount of swap space currently in use.

If the total amount of swap space allocated to a Unix host becomes full, the machine may halt all processes, or critical actions may be prevented from occurring. Running out of swap space may indicate a runaway process or an under-configured machine.

The type of alarm that is activated is determined by the percentage of swap space currently in use.

 

Related Topics

Swap In Flow Alarm

The Swap In Flow represents the number of processes swapped from disk per second.

A machine that is swapping processes to or from disk is usually under-configured for its workload.

The type of alarm that is activated is determined by the number of processes swapped from disk every second.

 

Swap Out Flow Alarm

The Swap Out Flow represents the number of processes swapped to disk per second.

A machine that is swapping processes to or from disk is usually under-configured for its workload.

The type of alarm that is activated is determined by the number of processes swapped to disk every second.

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating