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

Process History Page

The Process History subpage of the Processes drilldown opens when you click a process in the table (grid) in the Processes page, and then click the Process History tab.

This page shows the recent activity of the selected process in a series of related charts. By default, the charts in the Process History page now record data from the time that Spotlight on Windows was started.

To open the Process Details page

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

  3. Select a process to view its details.
  4. Click Process History

Charts on the Process History subpage

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
Processor

Shows the percentage of Privileged and User Time.

High Privileged time means that the program is predominantly busy accessing resources through operating system requests.

High User time means that the program is predominantly CPU-bound with the program code itself.

Read/Writes

Reads / Second — Shows the rate of IO reads (such as hard disk reads and memory reads) being performed by the process.

Writes / Second — Shows the rate of IO writes (such as hard disk writes and memory writes) being performed by the process.

Memory

Shows the current memory allocated to the selected process.

Memory Usage — Shows the current size of the working set of the selected process. The working set is the set of memory pages touched recently by the threads in the process.

Virtual Memory Size — Shows the current size of the memory allocated to this process that cannot be shared with other processes.

Page Faults Shows the number of page faults being generated by the program. A consistently high value may indicate a lack of memory. However, this metric includes both soft and hard page faults; as such, there may be no associated problems.

Note: The time frame displayed in the charts will depend on the historical settings you have chosen. See History Browser for more information.

 

Related Topics

Process Threads Page

The Process Threads sub-page of the Processes drilldown opens when you click a process in the table (grid) in the Processes page, and then click the Process Threads tab.

This page shows current information about the threads that execute the selected process, including:

To open the Process Details subpage

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

  3. Select a process to view its details.
  4. Click Process Threads.

You can view the information that follows:

Item Description

Instance

The instance name of the thread.

Thread ID

The unique identifier of the thread.

% CPU

The percentage of CPU elapsed time that the thread has used in order to execute instructions.

% User

The percentage of elapsed time that the thread has spent executing code in user mode.

% Kernel

The percentage of elapsed time that the thread has spent executing code in privileged mode.

Elapsed time

The total elapsed time the thread has been running.

Switches/sec

The rate of switches from one thread to another.

Thread state

The current state of the thread (Ready, Running or Waiting).

Thread Wait Reason

This is applicable only when the thread is in the Waiting state, and shows the reason why the thread is waiting.

 

Related Topics

Services Page

The Services page shows details of Windows services on the current system.

To open the Services page

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

The Services table contains the following information.

Notes:

  • Not all of these columns will be visible by default. To view hidden columns, right-click a column heading and choose Organize Columns... from the shortcut menu.
  • To hide or show the tree structure of the grid, right-click the grid and choose Hide Tree or Show Tree from the shortcut menu.
Column Description

Service

This shows the name of the service or driver as reported to the system. The "tree bar" to the left of the names is a dependency tree, showing all services or drivers that depend on the particular service.

Display name

The "friendly" name of the service or driver.

Start up

This shows how the service acts on Windows start:

  • Automatic — Starts every time the system starts, after the Boot and System devices start.
  • Manual — Requires manual startup or another service or device to request its startup.
  • Disabled — Does not start and cannot be started manually.
  • Boot — Starts every time the system starts, before any other devices start.
  • Demand — Starts when the device is detected or needed for a specific event.
  • System — Starts every time the system starts, after the Boot devices start.

Service type

Shows what type of program this is.

Current state

Shows what the current status is of the service or driver. The status can be Running, Not Running or Paused.

Controls accepted

Identifies what can be done with a service or driver. This information is only available for currently running or paused services.

Running PID

The ID of the process associated with the current service (if any).

Process path name

The location of the service executable file.

 

Related Topics

System Drivers Page

The System Drivers page shows details of the Windows kernel drivers and file system drivers on the current system.

To open the Services page

  1. Select the Spotlight connection in the Spotlight Browser.
  2. Click Processes | System Drivers.

The System Drivers table contains the following information for each device.

Note: Not all of these columns will be visible by default. To view hidden columns, right-click a column heading and choose Organize Columns... from the shortcut menu.

Column Description

Driver

The name of the driver as reported to the system. The "tree bar" to the left of the names is a dependency tree, showing all drivers that depend on the particular driver.

Description

The "friendly" name of the driver.

Type

Shows if the device is a Kernel or File System driver.

State

Shows if the driver is Running or Stopped.

Start Mode

This shows how the driver acts when Windows starts.

  • Automatic — Starts every time the system starts, after the Boot and System devices start.
  • Manual — Requires manual startup or another service or device to request its startup.
  • Disabled — Does not start and cannot be manually started.
  • Boot — Starts every time the system starts, before any other devices start.
  • Demand — Starts when the device is detected or needed for a specific event.
  • System — Starts every time the system starts, after the Boot devices start.

Accepts Stop

Identifies whether a driver can be stopped. This information is available only for currently running devices.

File

Shows the file location of the device. This cannot be retrieved for all devices.

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating