Data Dictionary Alternate Buffer Pool does not see Objects in Areas already assigned with enableB2

Data Dictionary interface to view Alternate Buffer Pool objects does not see Objects in areas already enabled for Alternate Buffer Pool with PROUTIL enableB2

When assigning Alternate Buffer Pool Objects through the Data Dictionary:

• Objects in Areas already assigned with enableB2 are shown as Primary not Alternate
• Objects in Areas already assigned with enableB2 can be assigned to Alternate without error

Can Objects be assigned to the Alternate Buffer Pool at both the Object and Area Level?
 

The Data Dictionary Tool works only at the Object Level not the Area Level, therefore all objects that are part of an Area which has been enabled for Alternate Buffer pool by the proutil enableB2 command cannot be identified.

When an Object is assigned to the Alternate Buffer Pool at both the Object and Area level:

• The Area level assignment will take presidence
• When the Object is unassigned, it will remain assigned at the Area level
• When an Area is unassigned, the Object level will remain assigned.

Before making Object Level Assignments, run the Quick Alternate Buffer Pool Report :

Database > Reports > Alternate Buffer Pool

If any Object Level assignments have already been committed, they will be reported under the following header:
If any Object Level assignments have already been committed, they will be reported under the following header:
The following example shows the sample 'sports' database where the Customer Table is assigned at both the Object and Area levels:
 
Alternatively the commandline viewB2 can be used:

$   proutil dbname -C viewB2 | grep Alternate