Chat now with support
Chat mit 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

Processes and Services

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

 

Processes

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

 

Processes Page

The Processes page lists the processes currently running on the Unix system.

Note: The Processes page shows the output from the Unix ps command.

To open the Processes page

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

For each process, you can view the information that follows:

Notes: 

  • Some columns in the table are hidden by default. To view hidden columns, right-click a column heading and choose Organize Columns... from the shortcut menu.
  • Refer to man ps(1) for further details on the values shown in the Processes grid.
  • When the table is displayed as a flat grid (not a tree), right click any value in the table and select Show processes where... or Hide processes where... to filter the table by that value.
Column Description
Process

The name of the process.

Notes:  

  • Click on a process to display more information on that process. Process Details Page
  • Right click on the process and select Kill Process (if enabled) to end any processes currently running on the Unix machine.
  • Some of the processes may be running other, secondary, processes. Right click the grid and select Show as Tree to display the secondary processes as branches of the initial process.

Nice The Nice value describes the relative priority of the specified process. A process with a low Nice value is running at a higher priority than a process with a high Nice value.
PID The process identifier for the specified process.
PPID The process identifier for the process that is the parent of the specified process.
% CPU The percentage of CPU time used by the process in the last sample interval.
State

The state of the process. Process states are platform dependent.

Platform Value Description
AIX A Active
W Swapped
I Idle
HP-UX W Waiting
I Intermediate
X Growing
Linux D Uninterruptible Sleep
W Has no resident pages
< High priority process
N Low priority tasks
L Has pages locked into memory
Solaris O Process is running on a processor
S Sleeping. That is, the process is waiting for an event to complete.
R Runnable. That is, the process is on the run queue.
Z Zombie state. That is, the process has been terminated and the parent process is no longer waiting.
T The process has been stopped by a job control signal, or because it is being traced.
Terminal The Unix terminal session where a user started the specified process. If the process was not started by an interactive user, the Terminal value is set to "?".
User The name of the user to whom the process belongs.
Time The amount of CPU time the process has consumed.
Virt Mem (MB) The amount of virtual memory in use by the process, measured in megabytes.

 

Related Topics

Process Details Page

The Process Details page contains a detailed list of properties for the process selected on the Processes page.

To open the Process Details page

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

  3. Select a process to view its details

For the selected process

The Memory Usage chart displays data series for the virtual memory and physical memory used by the selected process.

The CPU Usage chart displays CPU usage for the selected process.

The information grid is as follows.

Item Description
Process The name of the process.
Process ID The process identifier for the specified process.
User The name of the user to whom the process belongs.
Parent PID The process identifier for the process that is the parent of the specified process.
Group ID The group identifier for the user that owns the specified process.
Processor % The percentage of CPU time used by the process in the last sample interval.
Elapsed Time How long the process has been running.
Cumulative Time The amount of CPU time the process has consumed.
State

The state of the process. Process states are platform dependent.

Platform Value Description
AIX A Active
W Swapped
I Idle
HP-UX W Waiting
I Intermediate
X Growing
Linux D Uninterruptible Sleep
W Has no resident pages
< High priority process
N Low priority tasks
L Has pages locked into memory
Solaris O Process is running on a processor
S Sleeping. That is, the process is waiting for an event to complete.
R Runnable. That is, the process is on the run queue.
Z Zombie state. That is, the process has been terminated and the parent process is no longer waiting.
T The process has been stopped by a job control signal, or because it is being traced.
Terminal The Unix terminal session where a user started the specified process. If the process was not started by an interactive user, the Terminal value is set to "?".
Priority The basic priority assigned to the process – the lower the number, the higher the priority. Unix can modify this priority by means of the renice command.
Nice The Nice value describes the relative priority of the specified process. A process with a low Nice value is running at a higher priority than a process with a high Nice value.
Virt Mem (MB) The amount of virtual memory in use by the process, measured in megabytes.
Physical Mem (MB) The amount of physical memory in use by the process, measured in megabytes.
Command The command executed by the process.

 

Related Topics

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen