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 |
