DB2 performance optimization that is workload-centric, repository-based, and accessible by all DB2 personnel including Application Developers and DBAs.

Now you can easily perform daily tasks such as:

• Pinpointing Top 20 Performance Optimization Candidates
• Choosing to global Rebind, partial Rebind, or not to Rebind at all
• Determining Access Path changes and the performance impact of moving from Test to QA to Production
• Optimizing your index configuration
• Alerting Application Developers to inefficient Access Paths

The leading-edge EZ-DB2 suite is made up of Workload Detective - consisting of EZ-Tracer, EZ-SQL Alerts! and EZ-Impact Analyzer - and Index Optimizer - consisting of EZ-XOP.

EZ-Tracer - Multi-dimensional view of DB2 performance data by DBNAME, Table, Index, Plan, Collection, and Package/Program for both Static and Dynamic SQL statements. For each SQL Statement, results include Frequencies, Costs, Full Access Path and Row-level Statistics.

EZ-SQL Alerts! - Automatically highlights SQL Statements that breach pre-set and user-specified criteria.

EZ-Impact Analyzer - Determines the impact of changes such as Reorg, Runstats, Rebind, APARs, Buffer Pool, DB2 Versions, etc. on Access Paths and Costs. Highlights performance changes at the Plan, Package/Program, Table and SQL Statement levels.

EZ-XOP - Automatically optimizes DB2 indexes, which provides a dramatic improvement in system performance and resource utilization.

Please read more about EZ-DB2 and TACT's SMART Approach to DB2 Optimization in our DB2 Info Sheet.

Our EZ-DB2 special offer is time-limited. To arrange for a demo and trial, please call us at (800) 433-8228, email us at software@tact.com or visit www.tactsoftware.com and www.ez-db2.com.

Developed by

for TACT software