PROUTIL VIEWB2 provides a report on all area-level and object-level assignments to both the alternate and primary buffer pool.

To view the buffer pool report, enter the following command: 
proutil db-name -C viewB2

For each area, the area level assignment and each object in the area is displayed. For each object, Object Enablement contains either Default or Alternate. Default indicates that the object takes its buffer pool assignment from the area. Alternate indicates the object is assigned to the Alternate Buffer Pool, regardless of the area assignment. An object level assignment of Alternate is only available for objects in Type II storage areas.

Index and LOB objects are described by their object name followed by their associate object's name (table name.) For example, the cust-num index associated with the customer table in the PUB schema is described as cust-num (PUB.customer).

The following is an excerpt of VIEWB2 output:

OpenEdge Release 12
Buffer pool assignment for areas and objects:
.
.
.
Area  8: "Customer/Order Area" - Alternate Buffer Pool

Object Enablement   Type  Object Id: Name
-----------------  ------ ---------------
Alternate           Table       2:  PUB.Customer
Default             Table       4:  PUB.Order
Alternate           Table       5:  PUB.Order-Line
Alternate           Index      16:  Sales-Rep (PUB.Customer)
Default             Index      21:  Cust-Order (PUB.Order)

Area  9: "Primary Index Area" - Primary Buffer Pool

Object Enablement   Type  Object Id: Name
-----------------  ------ ---------------
Alternate           Index      12:  Cust-Num (PUB.Customer)
Default             Index      20:  Order-Num (PUB.Order)
Default             Index      24:  order-line (PUB.Order-Line)

Area  10: "Customer Index Area" - Primary Buffer Pool

Object Enablement   Type  Object Id: Name
-----------------  ------ ---------------
Alternate           Index      13:  Comments (PUB.Customer)
Alternate           Index      14:  Country-Post (PUB.Customer)
Alternate           Index      15:  Name (PUB.Customer)

In the excerpt, observe that:

  • Area 8 is assigned to the Alternate Buffer Pool at the area level. In addition, the Customer and Order-Line tables, and the Sales-Rep index, are explicitly assigned at the object level (via the Data Dictionary). In this example, all objects in Area 8 are assigned to the Alternate Buffer Pool due to the area level buffer pool assignment.
  • Area 9 is assigned to the primary buffer pool, but its index object Cust-Num is assigned to the Alternate pool.