Pool Advisor components

Pool Advisor provides a number of functions and components to help you monitor Db2 storage resources to help you identify and resolve problems as they occur. The following figure illustrates the major components of Pool Advisor. 

This section contains the following topics:

• • Data Collector
  • Advisors
  • Report Manager
  • Sysplex support

Data Collector

A Data Collector provides common access to Db2 performance data for all Pool Advisor users.

Each Data Collector can monitor all Db2 subsystems on the same z/OS image and can support up to 999 concurrent users. In a sysplex environment, Data Collectors can communicate across the sysplex and users can access data from any Db2 being monitored by those Data Collectors. In addition, the Data Collector retrieves data from Db2 control blocks.

Advisors

Background advisors are the Data Collector components that watch over resource use in Db2 and warn you when they detect potential problems. You can access the advisors from Pool Advisor reports.

When the Data Collector is initialized, the product issues parameter messages to the SYSTSPRT DD of the DOMPROC. Parameters are used to modify resources when the advisors recommend changes.

For more information, see Using-advisors.

Report Manager

The Report Manager is your interface to BMC System Performance for Db2.

The Report Manager’s main function is to take the records collected by the Data Collector and generate reports. All Pool Advisor reports use the Report Manager for display.

Foreground advisors are a Report Manager mechanism for displaying a text-based explanation of the values found on these reports.

Sysplex support

Pool Advisor is designed to run in a sysplex environment.

One Data Collector from each z/OS image in the sysplex can be defined in a DOMPLEX group. Each Data Collector can monitor all Db2s on its same z/OS image and all Data Collectors in the DOMPLEX can communicate with each other. As a result, all data from all Db2s across the DOMPLEX is available to all DOMPLEX users. All users can view online reports that contain data from any or all Db2s in the DOMPLEX and commands can be issued to any Db2 in the DOMPLEX.

The following figure illustrates Sysplex communication in a Pool Advisor DOMPLEX. 

For a complete explanation of DOMPLEX option sets, see the System and SQL Performance for Db2 administration.