Spotlight on DB2 LUW

DB2 SQL performance that's optimized in real time

Diagnose performance problems on DB2 for Linux, Unix, and Windows in real time, then rapidly pinpoint the source of problems and quickly respond to issues that need attention.

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.

Features

Improved performance for DB2 for LUW connections – Experience minimal impact on performance when managing connections to multiple instances.

Full support of DB2 for LUW 9.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 9.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.

Specifications

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

Operating system
  • Windows Server 2003 (32-bit or 64-bit)
    Note: Recommended for monitoring local databases only.
  • Windows Server 2008 (32-bit or 64-bit)
    Note: Recommended for monitoring local databases only.
  • Windows XP (32-bit or 64-bit)
  • Windows Vista (32-bit or 64-bit)
  • Windows 7 (32-bit or 64-bit)
  • Windows 8 (32-bit or 64-bit)
  • Windows Server 2012
Memory

512 MB RAM (minimum); 1 GB (recommended)
For multi-partitioned environments, upgrade memory as needed.

Hard disk space100 MB of free hard-disk space
DB2 client

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.

Virtualization Support

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.

Screenshots

loading

Spotlight on DB2 LUW

Take a tour of key functionality in Spotlight on DB2 LUW interface to experience its capabilities and ease of use.


Take a Screenshot Tour

 

Spotlight on DB2 LUW - Home page

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

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

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

Spotlight on DB2 LUW Tablespace Drilldown

The Tablespace Drilldown displays details for your tablespaces per partition.

Spotlight on DB2 LUW - Client application drilldown

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

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

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

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

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 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 LUW Customize Threshold Values

Spotlight on DB2 allows you to customize threshold values that are used in alarming.