The VPSIZE parameter determines buffer pool sizes. This parameter determines the number of pages to be used for the virtual pool. DB2 can handle large buffer pools as long as enough memory is available. If insufficient storage exists to back the buffer pool storage that is requested, paging can occur. Paging can occur when the buffer pool size exceeds the available memory on the z/OS image. DB2 limits the total amount of storage that is allocated for buffer pools to approximately twice the amount of storage. There is a maximum of 1-TB total for all buffer pools, provided the storage is available.
To size buffer pools, it is helpful to know the residency rate of the pages for the object in the buffer pool.
|
Copyright © 2013 CA Technologies.
All rights reserved.
|
|