Once you have identified objects or areas for the Alternate Buffer Pool, you must allocate shared memory for the pool. Alternate Buffer Pool memory is identified by the
-B2 startup parameter. Shared memory maximums apply to the sum of your
-B2 and
-B values. The optimum value depends on your application. You cannot specify blocks in Alternate Buffer Pool for a Replication target database. See
Blocks in Alternate Buffer Pool (-B2) for details on specifying
-B2.
You can monitor the Alternate Buffer Pool with PROMON or through VSTs. You can modify the amount of memory allocated to the Alternate Buffer Pool online with PROUTIL INCREASETO. See the Database Administration online help or
PROUTILINCREASETO qualifier for details on using PROUTIL INCREASETO.