Try OpenEdge Now
skip to main content
Database Administration
Maintaining and Monitoring Your Database : Managing Performance : Alternate Buffer Pool : Viewing Alternate Buffer Pool selections : Viewing Alternate Buffer Pool settings with PROUTIL
 
Viewing Alternate Buffer Pool settings with PROUTIL
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 10.2B1P as of Wed Oct 21 19:01:48 EDT 2009
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.