Spotlight on DB2 LUW

Shop our wide range of secure and reliable desktops for your business. Plus, enjoy free delivery on select PCs. Go to Offers

Optimize DB2 SQL performance in real time.

Simplify DB2 performance management and tuning by quickly pinpointing and responding to problems as they arise.



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.
Benefit from these key features with Spotlight on DB2 LUW:

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.
  • 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 Vista (32-bit or 64-bit)
    Windows 7 (32-bit or 64-bit)
    Windows 8 (32-bit or 64-bit)
    Windows Server 2012

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

    Hard disk space
    100 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.
Documents Documents
Download printable materials to gain insight on how this product can help you simplify IT challenges.
Events Events
Peruse webcasts and in-person activities near you to explore the technology behind this product.
Community Community
Get the most from this product as you join your peers and Dell experts to access tools and learn best practices.
Dell KACE K1000 GO App - CRN - 2014 Enterprise App Award

Dell KACE K1000 GO

Winner: CRN 2014 Enterprise App Award

Learn More
Dell KACE K1000 GO App - CRN - 30 Coolest Android and iOS Apps of 2014

Dell KACE K1000 GO

One of CRN's "30 Coolest Android and iOS Apps of 2014"

Learn More
Chat online

Chat online. Ask us anything.

You've got questions, we've got experts who can help.

Chat Online
Dell Software | Contact Us

Contact a Dell Expert

Get help with all your business needs.

Learn More
Dell Software | Support

Software Product Support

Single location for all your product needs.

Learn More
 You can only compare up to 7 products. To compare this item, deselect one of the other 7 products.