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

Table of Contents

Contents

Spotlight on IBM DB2 LUW (Linux, Unix, and Windows)
New in This Release
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
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
About Spotlight on IBM DB2 LUW drilldowns
Buffer Pool Analysis drilldown
Criteria Tab for Drilldowns
Details tab
I/O Activity tab
I/O Times tab
Statistics tab
Tables tab
Tablespaces tab
Client Application Analysis drilldown
Criteria Tab
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
Forcing an application
Database Analysis drilldown
Criteria Tab
Details tab
Caching tab
Sorting tab
I/O Activity tab
Locking tab
Log Status tab
Statistics tab
Tables tab
Memory Pools tab
Configuration tab
History tab
Utilities tab
Reorgs tab
Database Manager Summary drilldown
Agent Activity tab
Configuration tab
Contacts tab
Memory Pools tab
Paths tab
Registry tab
Sorting tab
Statistics tab
Database Manager Summary drilldown System Resource tab
Diagnostic Log drilldown
Criteria Tab for Drilldowns
FCM Analysis drilldown
Tablespace Analysis drilldown
Criteria Tab
Details tab
Containers tab
I/O Activity tab
I/O Times tab
Quiescers tab
Ranges tab
Statistics tab
Tables tab
Top SQL drilldown
Current SQL tab
Dynamic SQL tab
Static SQL tab
Dynamic SQL Details tab
Unit of Work tab
Printing the Top SQL drilldown
Operating System drilldown
Workload Management Analysis drilldown
Service Classes tab
Workloads tab
Work Classes tab
Work Actions tab
Activities tab
Threshold Queues tab
List of pre-defined alarms
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
Agents Pending Locks alarm
Agents Pending Token alarm
Agent Request Overflows 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
Acquisition Options
DB2 Client Options
...listed in the Top SQL drilldown
...listed in the Client Application Analysis drilldown
Spotlight Basics
Spotlight Connection Manager
Connection Properties - General Page
Connection Properties - Details Page
Connection Properties - Overhead Page
Custom Connection Performance
Migrate (Move And Share) Connections
Connection Templates
Spotlight Browser
Welcome to Spotlight
Live connections
All connections
History Browser
Spotlight Home Pages
Spotlight Drilldown Pages
Spotlight Navigation
Pause / Resume / Refresh
Spotlight Favorites
Spotlight Slideshow
Connection Status bar
Calibrate Connections
Spotlight Alarms
Spotlight Today
Alarms by Time
Alarm Log
Alarm Filters
Ignore (Snooze) Alarms
Custom Filter Rules Dialog
Custom Filter Rules - Alarm Log Filter Dialog
Alarm Actions - Alarm Log Filter Dialog
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...
Play a sound
Run a program
Send e-mail to...
Send network message to...
About Alarms, Metrics, Thresholds And Severities
Metrics Dialog
Thresholds Dialog
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
About Spotlight Grids
Find Text
Sort The Grid
Tree View
Show, Hide & Order Columns
Select Multiple Rows
Grid Properties - Options Page
Spotlight Home Page Components
Home Page Properties - Options Page
Restore Default Settings
Copy To Clipboard
Save To File
Print
Component Properties - Overhead Page
Configure Spotlight - View | Options
Alarm actions
Alarm smoothing
Balloon help
E-mail server
Taskbar
Chart configuration
Color scheme
Colors and flashing of alarms / Colors used in charts
Slideshow
Set the rate at which data is collected
Password storage
Navigation tree
Initial view
Display performance
About Troubleshooting
Product Authorization Errors
I Cannot Open a Migrated Connection
High Spotlight Load on Database Server
Main Window Hard To Read
No Change to Data Flows
Disabled Controls
Delay in Reporting Alarms
Alarm Help Is Displayed Instead of The Drilldown
Build the Support Bundle
Spotlight History
Clear history
History limits
History location
Spotlight on Windows
Connect to Windows Systems
What Is Spotlight?
Features of Spotlight on Windows
An Overview of The Windows Architecture
Spotlight Home Page
System Panel
Network Panel
Event Log Panel
CPU Panel
Memory Panel
Paging Files Panel
Disks Panel
Files Panel
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
Spotlight Drilldowns
Processes Page
Process Details Page
Process History Page
Process Threads Page
Services Page
System Drivers Page
CPUs Page
Processing Page
Multiprocessor Page
Summary Page
Paging Activity Page
Cache Page
Logical Disk Activity Page
Physical Disk Activity Page
Logical Disk Space Usage Page
Disk Summary Page
File Sizes Page
Network Page
TCPIP Page
NBT Page
SPX Page
Sessions Page
Shares Page
Open Connections Page
Permissions Page
Open Ports Page
cLAN Gigabit Page
Activity Summary
Event Log
Summary Page
CPUs Page
Memory Page
Disks Page
Alarm Log
Spotlight on Windows - View | Options
Windows Disks Metrics
Windows Network Card Display
Windows Applications Metrics
Windows Event Log Metrics
Windows Files Metrics
Troubleshooting Spotlight on Windows
The Registry ... is not accessible.
Network Name (Path) Not Found
Connecting As The Logged-in User
WMI Connection Problems
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 on Unix
Spotlight Home Page
What is Spotlight on Unix
Features of Spotlight on Unix
Configure the Unix System
Connect to Unix Systems
Spotlight Home Page
System Panel
CPU Panel
Memory Panel
Swap Space Panel
Network Panel
Disk Activity Panel
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
Spotlight Drilldowns
Processes Page
Process Details Page
Zombies Page
Services page
Activity Page
Disk Page
Memory Page
CPU Page
Network Page
Logins Page
Filesystems And Disk Information
Alarm Log
Spotlight on Unix - View | Options
Unix Filesystem Metric
Troubleshooting
Troubleshooting Spotlight on Unix
Use Tracing To Add Details To Support Bundle
iostat Not Installed
Issues With Data Availability
Authorize Spotlight
About us
Third-party contributions
Copyright
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating