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

Used Percentage Alarm

The Least Space / Disk Space container in the Disk Activity panel displays the percentage of used disk space for the specified filesystem.

The Used Percentage alarm indicates that the filesystem is full or filling up. If the filesystem fills up completely, no more data can be written to it. For example:

  • If the /var filesystem fills, you may have problems with system activities such as e-mail or printing.
  • If the /home filesystem fills, user applications may be affected.
  • If the /tmp filesystem fills, any applications that use temporary files may be affected.


  • The data displayed in the Least Space / Disk Space container is collected from:
  • The filesystem that has the least amount of free space, OR
  • A user-specified filesystem on the Unix host.
  • To choose the filesystem whose details are displayed in the container, right-click the container and select Disk Options.


Related Topics

Zombie Processes Alarm

The Zombie button in the CPU panel shows the number of terminated child processes that have not been acknowledged by their parent process.

A high level of zombie processes is indicative of the presence of an inferior program, or an entry in /etc/inittab (or equivalent) preventing init from completing its startup sequence.

The type of alarm that is activated is determined by the number of zombie processes waiting to be exited.


Related Topics


Spotlight is powerful diagnostic and problem-resolution tool for Unix and Linux operating systems. Its unique user interface provides you with an intuitive, visual representation of the activity on your host machine.

For information on Spotlight on Unix, see these sections



Background Information

Introductory material to Spotlight on Unix.

Connect to a Unix System Create / Modify / Delete connections to Unix 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.

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


Spotlight 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.

Following are Spotlight drilldowns.

Drilldown Click to open Keyboard Shortcut Description
Processes and Services CTRL+P

The pages in the Processes and Services drilldown list all the processes running on the Unix machine (including "zombie" processes), and all the services found in the /etc/services file (running or not). Useful features in this drilldown include:

  • Processes Page: View processes in a standard table or tree structure. In the tree structure secondary processes are shown as "children" of the processes that run them. Click on a process for more detailed information on that process including CPU and Memory utilization. From the Memory Usage chart it is possible to detect memory leaks of the process over the display period.
  • Zombies Page: View child processes whose termination has not been acknowledged by their parent process.
  • Services Page: Use a shortcut menu option to test whether a specified service is available.
Activity Summary CTRL+A

The pages in the Activity Summary drilldown —

— show details of the different types of activity on the Unix system.

Filesystems CTRL+S The Filesystems And Disk Information drilldown displays detailed information about the filesystems on the Unix machine. This information can be viewed in chart or table form: right click over the drilldown page.
Alarm Log CTRL+L The Alarm Log drilldown displays information on the alarms associated with the Unix machine.


Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating