Pool Advisor reports

BMC AMI Pool Advisor for Db2 comes with a compact, comprehensive set of reports that lets you monitor all storage resources from one central report. You can quickly hyperlink 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

2024-07-17_02-50-17_Intervals

BMC System Performance for DB2 report set

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.

There are also reports to examine all page sets in a selected buffer pool and all objects in a selected page set.

An additional 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 contains the following topics:

 



 

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