ExpeTune DB is designed to manage Db2 performance on z/OS platforms, and dynamic Db2 workload, in a more effective way.
The performance of core business applications and websites will suffer if the Db2 databases that underpin them are not working efficiently. Slow database accesses can ultimately lead to poor response times, which adversely affect staff productivity and customer service. At the same time, inefficient database performance burns more CPU, and higher consumption-based license charges follow.
Database administrators and application developers can use ExpeTune DB to:
Smoother application rollouts
A Db2 health check feature allows you to determine the effect on database performance of any application changes before they go live.
Trouble-free Db2 upgrades
A predictive comparison facility alerts you to any slow-running queries caused by rebinding SQL to work with a new version of Db2.
Identification of SQL and Db2 inefficiencies
A single ISPF interface provides a 'one stop' set of data that can be used by Db2 performance analysts to diagnose and correct performance problems quickly.
Dynamic SQL workload management
Dynamic SQL run from non-z/OS platforms has a major impact on Db2 workload but is hard to track; ExpeTune DB lets you monitor, manage and minimize this workload.
Identification of obsolete tables
Static SQL can be extracted from the Db2 Catalog and listed in a readable format for investigating table usage and identifying obsolete tables.
Easier interpretation of SQL
ExpeTune DB lists and explains SQL from different sources, providing a succinct text summary, which can be restricted to a range of conditions, such as exceeding specific CPU consumption thresholds.