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

Logins Page

The Logins page displays the users currently logged in to the selected connection.

To open the logins page

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

Data in the Logins page

For each login, you can view the information that follows.

Note: Not all of the columns in the Logins table may be visible by default. To view hidden columns, right-click the grid heading and select Organize columns....

Column Description
UserName The name of a user logged in to the Unix host.
Line The terminal device associated with this connection.
LoginTime The date and time when the user logged in for this session.
Idle The time elapsed since the user's last activity (if available).
PID The Process ID of the connection or login.
Comments Additional information about the connection, including the address from which the connection was made (if available).

 

Related Topics

Filesystems And Disk Information

The Filesystems drilldown displays information on the disk usage for each filesystem on the Unix system, and the proportion of disk space that has been used for each filesystem.

Note: Refer to man df(1) for further details on the values shown in the Filesystems page.

To open the Filesystems and Disk Information drilldown

  1. Select the Spotlight on Unix connection in the Spotlight Browser.
  2. Click Filesystems.

To view disk usage in a chart

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

The information is displayed on a set of bar graphs that represent used and free disk space. Use the drop-down By Megabyte / By Percentage control to specify how to view disk usage.

To view disk usage in a table

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

Column Description
Filesystem The Unix device that holds a filesystem.
Used Space The amount of used space on the filesystem.
Free Space The amount of free space on the filesystem.
Mounted On The mount point for the filesystem.

To view disk usage for NFS mounted disks

NFS (Network File System) was developed by Sun Microsystems to allow a Unix host to use disk space on a remote machine as if it were local storage. Spotlight provides a shortcut option to allow you to show or hide disk usage for NFS mounted disks.

Right-click the Filesystems page and select Show NFS mounted Filesystems.

 

Related Topics

Alarm Log

The Alarm Log drilldown displays information on the alarms associated with the selected connection.

To open the alarm log

  1. Select the Spotlight on Unix connection in the Spotlight Browser.
  2. Click Alarm Log.

Notes:

  • The Alarm Log drilldown is common to all Spotlight applications. See Spotlight Alarms for more information.
  • The alarms are specific to the current Spotlight connection. Spotlight Alarms

 

Related Topics

View | Options

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

Section

Description

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

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating