Product Id: 30765120
Description: Spotlight on DB2 LUW - License + 1 Year 24x7 Maintenance - 1 monitored instance - Win
Mfr Part #: DBA-SPO-PB
Spotlight on DB2 diagnoses performance problems on DB2 for Linux, UNIX and Windows in real time by graphically displaying all database activity in an intuitive user interface, enabling you to respond quickly to issues that need attention.
With an architecturally accurate visual representation of your DB2 environment, Spotlight helps pinpoint the source of problems and enables you to rapidly resolve them.
From an overview screen, DBAs can view all activity across the entire DB2 instance - analyzing connections, wait events, locking, memory, and disk I/O - to pinpoint and remedy problems as they occur.
- Observe database activity in real time with a unique visual representation of process flows within DB2
- View all critical components of your DB2 database on one screen
- Receive problem reports automatically
- Save time having to write your own diagnostic SQL script
- Explore database activity
- Explore operating system activity
- Monitor the operating system through Spotlight on UNIX and Spotlight on Windows, which are bundled with Spotlight on DB2 for LUW
- Leverage support of features in DB2 for LUW, such as a HADR panel for high-availability disaster recovery management
- Your solution for quickly correcting database issues
Spotlight on DB2, features patent-pending technology that displays the processing architecture of DB2 and real-time activity of all database components in a single interface. It helps you pinpoint the source of problems as they occur and rapidly resolve them. Flow chart illustrations indicate the rate at which data is moving between database components. A map displays key statistics and metrics for your DB2 environment, including user activity, I/O activity and operational overhead.
- Automatic problem detection to prevent impact on end users
With Spotlight, you can drill down to details and locate in-depth information about the source of a problem. And because the run-time nature of each DB2 database is unique, Spotlight offers a calibration process that automatically sets a baseline of normal activity for each server and subsystem. This allows Spotlight to automatically set the speed of the internal flows and other activity indicators. When a threshold is met, Spotlight sends a warning of impending problems with a visual or audible alert. With these advanced warnings, you have the time to eliminate bottlenecks before they seriously impact end users.
- Real-time display of database activity
Unlike other diagnostic tools, Spotlight shows you activity occurring in real time between the fundamental components of the DB2 architecture. The main screen displays components such as memory, disk storage and SQL processes. Pulses traveling between these components represent the relative rate of data transfer and the level of activity within the database. These rates adjust to the performance characteristics of the server you specify.
- Historical record and playback
The record/playback capability allows you to easily retain all the performance metrics for a period of time via historical snapshots and then review them in full detail.
- EEE support
Similar to the data-sharing display, Spotlight provides a global visualization of EEE and ESE clustered environments including node summary and FCM detail reports.
- Database summary
This drill-down function provides summary reports on the health of the overall instance or subsystem.
- Client application detail
This drill-down function provides details on all active threads related to conditions such as locking and I/O.
- Top SQL
This data contains a collection of all SQL statements executed across all applications. It allows you to easily identify the most resource-intensive SQL statements across all applications.
- Tablespace detail
This drill-down function provides information about tablespaces running on DB2 for Linux, UNIX and Windows.