Spotlight on IBM DB2 LUW (Linux, Unix, and Windows)
New in This Release
Getting started with Spotlight on IBM DB2 LUW
Spotlight Basics
Required authority or privileges to run Spotlight
Setting up a connection profile
Calibrating your database
Archiving SQL statement data
Navigating between database, node, and instance home pages
Desktop features specific to Spotlight on IBM DB2 LUW
Understanding the home page
Database or database node home page
Instance home page
Spotlight on IBM DB2 LUW menus
Spotlight on IBM DB2 LUW toolbar
Spotlight on IBM DB2 LUW drilldowns
About Spotlight on IBM DB2 LUW drilldowns
Buffer Pool Analysis drilldown
Client Application Analysis drilldown
Spotlight on IBM DB2 LUW alarms
Client Application Analysis drilldown
Criteria Tab
Sub drilldown tabs
Database Analysis drilldown
Database Manager Summary drilldown
Diagnostic Log drilldown
FCM Analysis drilldown
Tablespace Analysis drilldown
Top SQL drilldown
Details tab
Caching tab
Sorting tab
I/O Activity tab
Locks tab
Lock Chains tab
Unit of Work tab
Authorities tab
Memory Pools tab
Statistics tab
WL Activities
Tasks specific to the Client Applications Analysis drilldown
Top SQL drilldown
Current SQL tab
Dynamic SQL tab
Static SQL tab
Sub drilldown tabs
Tasks specific to the Top SQL drilldown
Operating System drilldown
Workload Management Analysis drilldown
List of pre-defined alarms
Database or database node home page alarms
Spotlight on IBM DB2 LUW Options
Tuning SQL statements in Spotlight on IBM DB2 LUW
Database or database node home page alarms
Buffer Pool Index Hit Rate alarm
Buffer Pool Overall Hit Rate alarm
Catalog Cache Hit Rate alarm
Catalog Cache Overflows alarm
DMS Container Percentage alarm
DMS Utilization alarm
Log Container Percentage alarm
Log Utilization alarm
Package Cache Hit Rate alarm
Package Cache Overflows alarm
Lock List Utilization alarm
Percent of Sort Heap Threshold alarm
SMS Container Percentage alarm
SMS Utilization alarm
Sort Overflows alarm
Instance home page alarms
Instance home page alarms
Agents Pending Locks alarm
Agents Pending Token alarm
Agent Request Overflows alarm
HADR Missed Beats alarm
Hash Join Overflows alarm
Hash Join Small Overflows alarm
Hash Loops alarm
Piped Sort Rejects alarm
Post Threshold Hash Joins alarm
Post Threshold Sorts alarm
Sort Overflows alarm
Spotlight Connections
Spotlight History
Spotlight on Windows
Spotlight Connection Manager
Connection Properties
Monitor Spotlight Connections
Connection Properties - General Page
Connection Properties - Details Page
Connection Properties - Overhead Page
Custom Connection Performance
Migrate (Move And Share) Connections
Connection Templates
Spotlight Browser
Spotlight Home Pages
Spotlight Drilldown Pages
Spotlight Navigation
Pause / Resume / Refresh
Spotlight Favorites
Spotlight Slideshow
Connection Status bar
Calibrate Connections
Alarms
Spotlight Alarms
Spotlight Today
Alarms by Time
Alarm Log
Alarm Filters And Actions
Charts, Grids And Home Page Components
Alarm Filters
Ignore (Snooze) Alarms
Custom Filter Rules Dialog
Custom Filter Rules - Alarm Log Filter Dialog
Alarm Actions - Alarm Log Filter Dialog
Select the conditions for the alarm log rule
Alarm Metrics And Thresholds
Where the action is...
Where the alarm has (not) been active in the last n minutes
Where the alarm has (not) been snoozed
Where the alarm severity is...
Where the connection is...
Where the connection type is...
Where the control is...
Where the details contain...
Where the highest alarm for the connection is...
Where the value is...
Select the actions to perform
Charts
View | Options
About Spotlight Charts
Zoom in on Charts
Pan Over Zoomed Charts
Set the Chart View
Filter on the Data Series
Maximize and Restore Charts
Chart Properties - Chart Page
Chart Properties - Filtering Page
Grids
About Spotlight Grids
Find Text
Sort The Grid
Tree View
Show, Hide & Order Columns
Select Multiple Rows
Grid Properties - Options Page
Home Page Components
Restore Default Settings
Copy To Clipboard
Save To File
Print
Component Properties - Overhead Page
Configure Spotlight - View | Options
Alarms and notifications
Appearance
Data collection
Security
Start-up
Troubleshooting
Troubleshooting
Connect to Windows Systems
Background Information
Home Page
Spotlight on Unix
Spotlight Home Page
System Panel
Network Panel
Event Log Panel
CPU Panel
Memory Panel
Paging Files Panel
Disks Panel
Files Panel
Alarms
Spotlight Alarms
Cache Reads Alarm
Cache Writes Alarm
Current Users Nearing Limit Alarm
Diagnose Single Application Alarm
Disk Alarm
Disk Reads Alarm
Disk Writes Alarm
Event Log Alarm
Logical Disk Statistics Alarm
Low Memory Alarm
Missing Performance Counters Alarm
Network Failure Alarm
Page Faults Alarm
Page File Location Alarm
Page Hits Alarm
Page Outs Alarm
Page Reads Alarm
Page Writes Alarm
Paging File Alarm
Paging File Disk Location Alarm
Percentage Bandwidth Alarm
Physical Memory Usage Alarm
Process CPU Utilization Alarm
Processor Queue Length Alarm
Read Hit Alarm
System Up Time Alarm
Total CPU Usage Alarm
Virtual Address Space Alarm
Virtual Memory Alarm
Windows CPU Alarm
WMI Statistics Alarm
Drilldowns
Spotlight Drilldowns
Processes Drilldown
CPUs Drilldown
Memory Drilldown
Disks Drilldown
View | Options
Troubleshooting
Logical Disk Activity Page
Physical Disk Activity Page
Logical Disk Space Usage Page
Disk Summary Page
File Sizes Page
Network Drilldown
Network Page
TCPIP Page
NBT Page
SPX Page
Sessions Page
Shares Page
Open Ports Page
cLAN Gigabit Page
Activity Summary
Event Log
Single Application
Alarm Log
Troubleshooting Spotlight on Windows
Issues Connecting
The Registry ... is not accessible.
Network Name (Path) Not Found
Connecting As The Logged-in User
WMI Connection Problems
Issues Monitoring A Windows Machine
Display Problems on The Home Page Disks Panel And Disk Drilldown
Display Problems on The Home Page Network Panel, Flows And Network Drilldown
The Processes Page And Process Affinity
Installing The SNMP Protocol
Spotlight on Windows License
Spotlight Home Page
Background Information
Connect to Unix Systems
Home Page
About us
Third-party contributions
Copyright
Spotlight Home Page
System Panel
CPU Panel
Memory Panel
Swap Space Panel
Network Panel
Disk Activity Panel
Alarms
Spotlight Alarms
Blocked Process Alarm
Input Error Packets Flow Alarm
Output Error Packets Flow Alarm
Page In Alarm
Page Out Alarm
Percentage Busy Alarm (Most Active Disk)
Swap Space Alarm
Swap In Flow Alarm
Swap Out Flow Alarm
Used Percentage Alarm
Zombie Processes Alarm
Drilldowns
Spotlight Drilldowns
Processes and Services
Activity Summary
Filesystems And Disk Information
Alarm Log
View | Options
Troubleshooting
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
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
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
- Select the Spotlight on Unix connection in the Spotlight Browser.
-
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:
| |||||||||||||||||||||||||||||||||||||||
| 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.
| |||||||||||||||||||||||||||||||||||||||
| 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. |
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
- Select the Spotlight on Unix connection in the Spotlight Browser.
-
Click Processes | Processes.
- 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.
| |||||||||||||||||||||||||||||||||||||||
| 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. |