ExpeTune DB
Db2 performance management
-
OVERVIEW
OVERVIEW
OVERVIEW
-
KEY FEATURES
KEY FEATURES
KEY FEATURES
-
RESOURCES
RESOURCES
RESOURCES
OVERVIEW
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 MIPS-based license charges follow.
ExpeTune DB is designed to manage Db2 performance on z/OS platforms, and dynamic Db2 workload, in a more effective way. Database administrators and application developers can use ExpeTune DB to:
- Optimize business efficiency and promote MIPS recovery by identifying SQL and Db2 inefficiencies
- Improve application response times and service levels
- Identify the dynamic SQL responsible for peak MIPS usage, or high overall CPU usage
- Prevent problems due to application changes or Db2 upgrades by running a healthcheck or predictive analysis before you start
KEY FEATURES
- Smoother application rollouts
A Db2 healthcheck 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 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
