With Spotlight, DBAs 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, DBAs have the time to eliminate bottlenecks before they seriously impact end users.
From an overview screen, DBAs can view the most active user sessions, SQL statements, locks, waits, and database activity to pinpoint and alleviate problem areas as they occur.
- Vendor:
- Dell Software
- Posted:
- Feb 8, 2021
- Published:
- Jun 1, 2006
- Format:
- PDF
- Type:
- Data Sheet