Pool management
Problem
One of the critical administration tasks of the Db2 systems programming and database is to distribute storage resources among the various pools.
Many factors must be considered for each type of pool, but the product must examine and tune each pool without causing a negative impact on any other. This can be a very time-consuming and error-prone job.
Solution
BMC AMI Pool Advisor for Db2
provides you with expert assistance in performance tuning and problem resolution, as well as some automated resource management capabilities.
Pool Advisor performs the following tasks:
- Collects and analyzes Db2 data about buffer pool, EDM pool, dynamic statement caching, sort pool, RID pool, and group buffer pool use
- Makes recommendations concerning storage resource allocation, object configuration, and various Db2 parameter settings
- Automatically manages some of these resources on a real-time basis for best performance across workload fluctuations
Pool Advisor looks at storage requirements across the system and makes recommendations based on total storage resource requirements, so that an increase in one resource does not cause a shortage in another. When storage is constrained, Pool Advisor attempts to balance resource use and, under severe conditions, prevents increases to any storage resources.
This section contains the following topics:
Related topic