Quest Central® for DB2

Spotlight on DB2

Spotlight on DB2 displays real-time, graphical illustrations of all DB2 activity in a simple and intuitive interface. With its architecturally accurate visual representation of your DB2 environment, Spotlight helps you pinpoint the source of problems and rapidly resolve them. From an overview screen, you can view the activity and health of your DB2 environment to analyze connections, SQL, wait events, locking, memory and disk I/O to pinpoint and alleviate problem areas as they occur.

Key Benefits:

• Simplifies the DBA's job by providing one solution for both mainframe and distributed environments
  
• Alerts you when key metric thresholds are triggered before it impacts end users
  
• Reveals essential details of problem areas for quick diagnosis
  

Key Features:

• Shows a visual representation of either DB2 distributed , or mainframe process flows, allowing you to observe actual activity in real time
  
• Identifies bottlenecks and problem areas using flows , graphs and visual icons
  
• Displays the details of problem areas, including most active applications , inefficient SQL , locks/wait events , and disk I/O
  
• Drills down on operating system metrics* like CPU, I/O, memory and processes.
  
• Alerts DBAs with an audio or visual alarm if any DB2 component has exceeded a critical threshold
  
• Record and Playback feature allows you to capture a problem 'live' and play it back later to carefully diagnose the problem
  
• Extensive support for EEE, ESE, and SYSPLEX partitioned environments.
  

Spotlight on DB2 functionality is integrated with other Quest Central components to facilitate quick problem resolution. SQL Tuning, Space Management and Database Administration, the resolution modules, are only a mouse click away.

*only available for DB2 distributed platforms