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 |
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 |
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center