Quest Central® for DB2 LUW

Comprehensive Object management, SQL Tuning, Space Management, and Performance Diagnostics

Manage all of your DBA tasks from a single integrated interface, regardless of platform.

Quest Central® combines all of the DB2 administration functionality DBAs need for DB2 on Linux, Unix, or Windows. With an easy-to-use graphical interface and integrated console, Quest Central LUW for DB2 reduces the learning curve for DBAs who need to manage more than one aspect of DB2 performance.

With powerful DB2 monitoring, database administration, SQL tuning, and comprehensive space management in a single place, Quest Central for DB2 improves database performance and DBA productivity.

Quest Central for DB2 components include:

• Complete Database Administration — Eases the burden of maintaining, migrating and comparing database objects by providing a comprehensive graphical object management solution. Quickly create, drop or alter database objects to accommodate your business and application needs.
• SQL Tuning — Makes SQL optimization easy with a complete SQL tuning lab — a robust environment that lets you work with multiple versions of a base SQL statement to easily improve queries.
• Quest SQL Optimizer for DB2 — Offers complete SQL performance optimization with proactive detection of inefficient SQL, automated SQL rewrite, and comprehensive virtual index advice and index impact analysis. Quest SQL Optimizer maximizes application performance and eliminates problematic SQL before users are affected.
• SQL Analysis – Provides you with extensive historical SQL collection capabilities to pinpoint the SQL statements in need of tuning on DB2 LUW. Easily identify your most costly SQL statement, transaction, application program or DB2 user.
• Comprehensive Space Management — Reorganize and restructure DB2 database growth with our space management capabilities. Avoid poor response time and eventually database failure that can be caused by unmanaged database growth.
• Spotlight on DB2 — Quickly identify and eliminate bottlenecks in your DB2 environment through an innovative graphical display that renders the DB2 process model. Detailed metrics available in the drilldown features provide you with the necessary information to resolve the problem.