Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

Spotlight on DB2 6.9.3 - User Guide

Table of Contents

Spotlight on IBM DB2 LUW (Linux, Unix, and Windows)

New in This Release Getting started with Spotlight on IBM DB2 LUW

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

Buffer Pool Analysis drilldown Criteria Tab for Drilldowns Sub drilldown tabs

Details tab I/O Activity tab I/O Times tab Statistics tab Tables tab Tablespaces tab

Client Application Analysis drilldown

Client Application Analysis drilldown Criteria Tab Sub drilldown tabs

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

Forcing an application

Database Analysis drilldown

Database Analysis drilldown Criteria Tab Sub drilldown tabs

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

Database Manager Summary drilldown Sub drilldown tabs

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

Diagnostic Log drilldown Criteria Tab for Drilldowns

FCM Analysis drilldown

FCM Analysis drilldown

Tablespace Analysis drilldown

Tablespace Analysis drilldown Criteria Tab Sub drilldown tabs

Details tab Containers tab I/O Activity tab I/O Times tab Quiescers tab Ranges tab Statistics tab Tables tab

Top SQL drilldown

Top SQL drilldown Current SQL tab Dynamic SQL tab Static SQL tab Sub drilldown tabs

Dynamic SQL Details tab Unit of Work tab

Tasks specific to the Top SQL drilldown

Printing the Top SQL drilldown

Operating System drilldown

Operating System drilldown

Workload Management Analysis drilldown

Workload Management Analysis drilldown Service Classes tab Workloads tab Work Classes tab Work Actions tab Activities tab Threshold Queues tab

Spotlight on IBM DB2 LUW alarms

List of pre-defined alarms Database or database node home page 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

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 on IBM DB2 LUW Options

Acquisition Options DB2 Client Options

Tuning SQL statements in Spotlight on IBM DB2 LUW

Tuning an SQL statement...

...listed in the Top SQL drilldown ...listed in the Client Application Analysis drilldown

Spotlight Basics

Spotlight Connections

Spotlight Connection Manager Connection Properties

Connection Properties - General Page Connection Properties - Details Page Connection Properties - Overhead Page Custom Connection Performance

Migrate (Move And Share) Connections Connection Templates

Monitor Spotlight Connections

Spotlight Browser

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 And Actions

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

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

Play a sound Run a program Send e-mail to... Send network message to...

Alarm Metrics And Thresholds

About Alarms, Metrics, Thresholds And Severities Metrics Dialog Thresholds Dialog

Charts, Grids And Home Page Components

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

Home Page Components

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 Alarms and notifications

Alarm actions Alarm smoothing Balloon help E-mail server Taskbar

Chart configuration Color scheme Colors and flashing of alarms / Colors used in charts Slideshow

Data collection

Set the rate at which data is collected

Password storage

Navigation tree Initial view

Troubleshooting

Display performance

Troubleshooting

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

View | Options | Storage

Clear history History limits History location

Spotlight on Windows

Connect to Windows Systems Background Information

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 Drilldown

Processes Page Process Details

Process Details Page Process History Page Process Threads Page

Services Page System Drivers Page

CPUs Page Processing Page Multiprocessor Page

Memory Drilldown

Summary Page Paging Activity Page Cache Page

Disks Drilldown

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

Shares Page Open Connections

Open Connections Page Permissions Page

Open Ports Page cLAN Gigabit Page

Activity Summary Event Log Single Application

Summary Page CPUs Page Memory Page Disks Page

Spotlight on Windows - View | Options Appearance

Windows Disks Metrics Windows Network Card Display

Data collection

Windows Applications Metrics Windows Event Log Metrics Windows Files Metrics

Troubleshooting

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 on Unix

Spotlight Home Page Background Information

What is Spotlight on Unix Features of Spotlight on Unix

Connect to Unix Systems

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 and Services

Processes Page Process Details Page

Zombies Page Services page

Activity Summary

Activity Page Disk Page Memory Page CPU Page Network Page Logins Page

Filesystems And Disk Information Alarm Log

Spotlight on Unix - View | Options Appearance

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

Agents Pending Locks alarm

The Agents Pending Locks alarm becomes active when the number of agents waiting on a lock in comparison to the total number of registered agents for the DB2 instance reaches a threshold percentage. Lock waits occur for a number of reasons, including internal database contention.

This alarm has been predefined with a Low severity level. The underlying metric for this alarm can be adjusted to suit your environment by using the Metric Editor.

What you can do

The application agents could be experiencing concurrency problems. Try to identify the applications that are holding locks for long periods of time and determine the cause. One possible solution is to use small units of work (for example frequent COMMITs) to reduce concurrency issues.

Access the Client Application Analysis drilldown to identify the applications holding locks and review statistics about those locks.

Note: When you change the locking configuration parameters in one partition for a database, be sure that the changes are also made to all of the other partitions for the database.

Configuration parameter edits

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating

© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center