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.
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.
To install and run Spotlight on DB2 for LUW, ensure your system meets the following minimum hardware and software requirements. Refer to the Spotlight on DB2 for LUW Installation Guide for detailed system requirement information, including recommended DB2 maintenance levels.
Requirements for the client computer
|Memory||512 MB RAM (minimum); 1 GB (recommended)|
For multi-partitioned environments, upgrade memory as needed.
|Hard disk space||60 MB of free hard-disk space|
|DB2 client||IBM DB2 for Linux, Unix, and Windows (LUW) Runtime Client 8.1 or later, installed using the typical installation method|
Requirements for servers with monitored databases
|DB2 data server|
• IBM DB2 for Linux, Unix, or Windows (LUW) Enterprise Server Edition (ESE) 8.1 (with FixPak 1 applied) or later (64-bit); 9.1 or later (64-bit)
• For a DB2 for LUW 8 server on which you want to monitor SMS space, Toad for DB2 Agent 5.1 or later (or Quest Central for DB2 Agent 4.5 or later)
Requirements for the Toad for DB2 Agent or Quest Central for DB2 Agent
To enable Spotlight to monitor SMS tablespaces in a DB2 for LUW 8 environment, you must install either the Toad for DB2 Agent or the Quest Central for DB2 Agent 4.5 or later on each DB2 for LUW 8 server whose databases you are monitoring.
Note: Spotlight does not require the agent to monitor SMS tablespaces in a DB2 for LUW 9.1 or later environment. Additionally, agent installation is not required when the Spotlight client and the DB2 for LUW 8 server are installed on the same machine or when a 4.5 or later version of the Quest Central for DB2 Agent already exists on the server.
Both agents run on any of these platforms:
Note: For Sun Solaris 7 servers, you must apply Sun Solaris 7 patch 106327. If this patch is not already applied, you can apply it as part of the agent installation and configuration process, as described in Spotlight on DB2 for LUW Installation Guide.
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.
Required authority or privileges
- To install Spotlight
- To install Spotlight on a Windows 2003 machine, the installer must be either a Standard user (belonging to the Power Users Group) or an Administrator.
- To install the Quest Central for DB2 Agent
To install the Toad for DB2 Agent or the Quest Central for DB2 Agent on a Windows machine, the installer must have administrative privileges on that machine.
- To run Spotlight
Spotlight either calls DB2 snapshot APIs (for DB2 for LUW 8) or invokes IBM table functions (for DB2 for LUW 9.1 or later) to collect the raw processing data that it then translates into meaningful performance information. To run Spotlight, you need any one of the following authorities on each DB2 instance you are monitoring:
- SYSMON (or privileges equivalent to SYSMON authority)
Additionally, to monitor a DB2 for LUW 9.5 or later database, Spotlight requires that the user ID connected to the database must have EXECUTE privilege on the following table functions:
Note: Spotlight on DB2 installation does not create any database objects. Therefore, aside from the required user authority, Spotlight does not grant or require any additional privileges on objects.
- US English
Spotlight on DB2 LUW videos
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.