DB2 SQL performance that's optimized in real time
Diagnose performance problems on DB2 for Linux, Windows and Unix in real time with Spotlight™ on DB2, an easy-to-use DB2 to performance diagnostics tool. It simplifies DB2 performance management and tuning by enabling you to quickly pinpoint and respond to problems as they arise. An intuitive user interface displays all database activity, including an architecturally accurate representation of your DB2 environment. The overview screen on this DB2 performance tool reveals activity across the entire DB2 instance, making it easy to wait events and analyze connections, while also simplifying locking, memory and disk I/O.
Improved performance for DB2 for LUW connections – Experience minimal impact on performance when managing connections to multiple instances.
Full support of DB2 for LUW 10.5 metrics – Access statistics for workloads, RUNSTATS activities, and OLAP functions through Spotlight's database manager summary, client applications analysis, database analysis and top SQL drilldowns.
Workload management analysis drilldown – Review statistics captured for your DB2 for LUW 10.5 database, as well as DB2 workload management (WLM) information. The drilldown encompasses six key WLM areas (workloads, work classes, work actions, threshold queues, service classes and activities) that you can explore through sub-drilldowns and summary information.
Workload activities sub-drilldown – Learn activity for each application connection by accessing DB2 workload management statistics.
Import database catalog - Import a database catalog from another DB2 client easily.
Support for Windows 8 and Windows Server 2012 - Spotlight on DB2 supports all popular Windows platforms including Windows 8 and Windows Server 2012.
To install and run Spotlight™ on IBM® DB2® LUW, ensure your system meets the following minimum hardware and software requirements. Refer to the Spotlight™ on IBM® DB2® LUW Installation Guide for detailed system requirement information, including recommended DB2 maintenance levels.
Requirements for the client computer
512 MB RAM (minimum); 1 GB (recommended)
|Hard disk space||100 MB of free hard-disk space|
IBM DB2 for Linux, Unix, and Windows (LUW) Runtime Client 9.1 or later (32-bit or 64-bit), installed using the typical installation method.
Application Virtualization Limited testing has been performed for Citrix XenApp 6.5 on Windows Server 2008 R2.
Requirements for Servers with Monitored Databases
Database Server 9.0 or later
Requirements for Integration with Knowledge Xpert
To take advantage of links to Knowledge Xpert topics in Spotlight's What's This? help on the home pages, you must have Knowledge Xpert for DB2 10.1 or later installed. Additionally, you must uninstall any previous versions of Knowledge Xpert on your machine.
Spotlight on DB2 LUW - Home page
The home page displays a unique visual representation of activity on your database.
Spotlight on DB2 LUW - Database drilldown
The Database Drilldown page displays more granular monitoring details at the database\partition level.
Spotlight on DB2 LUW - Buffer pool drilldown
The Buffer Pool Drilldown allows you to drill down to view Buffer Pool specific activity and metrics.
Spotlight on DB2 LUW - Tablespace drilldown
The Tablespace Drilldown displays details for your tablespaces per partition.
Spotlight on DB2 LUW - Client application drilldown
You can use the Client Application Drilldown to view detailed activity for specific applications.
Spotlight on DB2 LUW - Top SQL drilldown
The Top SQL Drilldown displays the most resource-intensive SQL statements, which can be copied over to Quest SQL Optimizer for tuning.
Spotlight on DB2 LUW - Instance home page
The Instance Home page gives an overview of activity at the DB2 Instance level.
Spotlight on DB2 LUW - Workload management drilldown
The Workload Management Drilldown allows you to view WLM monitoring metrics.
Spotlight on DB2 LUW - Spotlight on Unix and Windows
You can monitor information on your database server’s operating system by using the Spotlight on Unix or Spotlight on Windows components that are included with Spotlight on DB2 LUW.
Spotlight on DB2 LUW - Overhead management
Spotlight on DB2 allows you to control and customize the amount of load Spotlight places upon the monitored DB2 system.
Spotlight on DB2 LUW - Customize threshold values
Spotlight on DB2 allows you to customize threshold values that are used in alarming.