Overview of the Exception Advisor

The Performance Advisor component of SQL Performance for DB2 maintains a Db2 Performance Advisor Database (PADB).

Using the PADB, the Exception Advisor identifies the root causes of previously triggered elapsed time and CPU time exception executions and makes recommendations.

The Exception Advisor examines the data accompanying the exception and compares that data to past execution statistics for the same statement in baseline or aggregated tables. You can adjust the analysis without changing code. The Exception Advisor bases its recommendations on observed conditions.

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

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

Note

The Performance Advisor component is available only as part of the BMC Performance for DB2 SQL solution or the SQL Performance for DB2 solution (not as a stand-alone component).

Related topic

Exception-Advisor-component

 

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