Designates an area for alternate buffer pool processing.
Syntax
proutil db-name -C enableB2 area-name
Parameters
db-name
Name of the database where you are specifying an area for the alternate buffer pool.
area-name
Name of the area (Type I or Type II) you are designating for the alternate buffer pool.
The Alternate buffer pool is a pool of buffers maintained independently from the primary buffer pool. Before the pool is filled, the buffers are maintained in a first-in-first-out (FIFO) queue. Once the alternate buffer pool is filled, an LRU chain replacement maintains the buffers, however the alternate buffer pool LRU chain is separate from the primary buffer pool LRU chain. Designating "hot" tables or areas to the alternate buffer pool, may increase buffer hit ratios.
Designating an area to participate in the alternate buffer pool requires that an alternate buffer pool is created with the -B2 startup parameter. If there is no alternate buffer pool, the area consumes buffers from the primary buffer pool.
Notes
ENABLEB2 must be run offline.
ENABLEB2 and alternate buffer pool support, are only supported with an Enterprise database license.
For Type II areas, you can refine your alternate buffer pool designation to the object (table, index, LOB) level through the Data Dictionary and Data Administration. Object-level designations for the alternate buffer pool can be made online.
ENABLEB2 must be run offline.