Skip to Content
Information
Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Pool Advisor for Db2 13.1.

Need for storage management

Tuning the performance of storage resources in Db2 is critical.

Db2 storage pools reside in the DBM1 address space, which, in earlier releases of Db2 (version 7 and earlier) was limited to 2 GB in size. On most z/OS systems, system and common storage areas reduce the available private area to less than 1.6 GB. This is the area that is available for virtual buffer pools, EDM, RID, and sort pools.

In Db2 version 8 and later, 64-bit memory architecture has eliminated the 2-GB virtual storage address space limit, but it has increased the need for monitoring real storage use. The maximum buffer pool sizes that are now allowed in Db2 can cause a greater demand on real storage requirements, and could introduce system paging, which can affect overall performance.

Related topic

Key-concepts



 

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

BMC AMI Pool Advisor for Db2 12.1