ExpeTune DB

Db2 performance management

  • OVERVIEW
    OVERVIEW
    OVERVIEW
    OVERVIEW
    OVERVIEW
    OVERVIEW
  • KEY FEATURES
    KEY FEATURES
    KEY FEATURES
    KEY FEATURES
    KEY FEATURES
    KEY FEATURES
  • RESOURCES
    RESOURCES
    RESOURCES
    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

RESOURCES

Learn about our other performance management solutions:
  • ExpeTune – z/OS application performance management
  • FreezeFrame – z/OS application performance analysis
  • SUPERMON® for Java – cross-platform Java application performance management

Have a question?

Please get in touch. We'd love to help.

CONTACT US

Get In Touch

For details on how your data is stored and used, please visit our Privacy Notice.