Skip to Content
Information
Space announcement This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

Managing performance with Performance Advisor

Using the Performance Advisor component, you can create and maintain a Performance Advisor Database (PADB) in Db2.

PADB tables contain the following types of data:

  • Statement and object performance data that BMC AMI Apptune for Db2 collects
  • Errors, exceptions, SQL text, and index usage patterns that Apptune identifies
  • Daily snapshots of real-time statistics (RTS) that Db2 collects
  • Recommendations for improving system and application performance

With this data, you can

  • Identify performance trends
  • Compare recent performance against a baseline
  • Identify usage patterns
  • Implement performance improvements

You can maintain one central PADB (centralized configuration), or a PADB at each Db2 subsystem or data sharing group where data is collected (localized configuration).

GUID-47E5A770-A760-442A-9F5A-06872981813D-low.png

For more information, view the Quick Course SQL Performance for DB2—Performance Advisor Database.

This section contains the following topics:



 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

SQL Performance for DB2 13.1