Overview of Pool Advisor for DB2


Pool Advisor for DB2

 provides a fast, accurate means of monitoring DB2 storage resources to help you identify and resolve problems as they occur.

Pool Advisor enables you to monitor the performance of DB2 activities in real time and to display data about the performance of the system in a readable, usable format.

Pool Advisor uses an advisor-driven system for retrieving pool-related data from DB2, reporting that data, detecting potential performance-related problems, and recommending actions to prevent those problems. Pool Advisor can operate under native TSO and ISPF.

Pool Advisor for DB2 is also a component of the BMC System Performance for DB2 solution, which integrates the features and functions of Pool Advisor for DB2, OPERTUNE for DB2, and MainView for DB2 into a single product interface.

If you have the BMC System Performance for DB2 solution installed at your site, you do not need this book. All Pool Advisor information is included in the BMC-System-Performance-for-DB2-User-Guide.

This section discusses the following issues:



 

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