Viewing Pool Advisor reports

BMC AMI Pool Advisor for Db2 provides a compact, comprehensive set of reports that you can use to monitor all storage resources. You can quickly link from that report to reports about specific storage pools if an anomalous value is highlighted.

The Pool Advisor report set consists of one primary report and one or more history reports for each of the following storage resources:

  • Overall status monitor
  • Total DBM1 virtual storage
  • Total DBM1 real storage 
  • Buffer pools
  • Dynamic statement cache
  • EDM pool
  • RID pool
  • Sort pool
  • Group buffer pool

Related topics

Using

The primary reports display key values about storage use in real time for the corresponding topic. Some history reports display similar data from previous intervals and others display a daily history.

Other reports to examine all page sets in a selected buffer pool and all objects in a selected page set.

Another report lists all of the commands issued on behalf of advisor recommendations, including details about the recommendation, the rule that triggered it, and the command response.

The color of the values on reports alerts you to any potential problems. A yellow value indicates a potential problem that needs investigation. A red value indicates a serious problem that requires immediate attention.

The following figure shows the Pool Advisor report set, including all history reports. 

image2022-4-19_11-57-39.png

This section describes how to view the following Pool Advisor reports:

 

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