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

Data Dictionary interface to view / assign Alternate Buffer Pool Objects does not see objects in Areas already assigned to the Alternate Buffer Pool with PROUTIL enableB2

May 29, 2017
Knowledge

Title

URL Name

Alternate-Buffer-Pool-assignment-does-not-see-Objects-in-Areas-already-assigned-with-enableB2

Article Number

000179376

Environment

Product: OpenEdge Version: 10.2Bx, 11.x OS: All supported platforms Other: Alternate Buffer Pool, Data Dictionary

Question/Problem Description

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?

Steps to Reproduce

Clarifying Information

Error Message

Defect Number

Enhancement Number

Cause

Resolution

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:

List of object-level assignable objects that are assigned to the alternate buffer pool at the object level

If any Object Level assignments have already been committed, they will be reported under the following header:

List of object-level assignable objects that are assigned to the alternate buffer pool at the area level

The following example shows the sample 'sports' database where the Customer Table is assigned at both the Object and Area levels:

List of object-level assignable objects that are assigned to the alternate buffer pool at the object level
Object Area
Name Name
------------------------------------------- --------------------
Customer Customer/Order Area

List of object-level assignable objects that are assigned to the alternate buffer pool at the area level

Object Area
Name Name
------------------------------------------- --------------------
Customer Customer/Order Area
- Comments (Index) Customer Index Area
- Country-Post (Index) Customer Index Area
- Name (Index) Customer Index Area
- Sales-Rep (Index) Customer/Order Area
Order Customer/Order Area
- Cust-Order (Index) Customer/Order Area
Order-Line Customer/Order Area

Alternatively the commandline viewB2 can be used:

$ proutil dbname -C viewB2 | grep Alternate

Area "Schema Area":6 - Alternate Buffer Pool

Area "Customer/Order Area":8 - Alternate Buffer Pool

Alternate 8 Table PUB.Customer:2

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

Workaround

Notes

Keyword Phrase

Last Modified Date

5/29/2017 2:03 PM

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

Files(0)

Was this article helpful?

Was this article helpful?

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

Information

Related Articles