Try OpenEdge Now
skip to main content
Database Administration
Reference : PROUTIL Utility : PROUTIL VIEWB2 qualifier
 

PROUTIL VIEWB2 qualifier

Lists the assignment of areas and objects with respect to alternate buffer pool processing.

Syntax

proutil db-name -C viewB2 [ tenant tenant-name| group group-name| shared ]

Parameters

db-name
Name of the database where you are viewing alternate buffer pool assignments.
tenant tenant-name
Specifies that the only the area and object assignments owned by tenant-name are to be viewed. If tenant-name is not valid, VIEWB2 exits with an error. Specifying tenant is only allowed on databases enabled for multi-tenancy.
group group-name
Specifies that the only the area and object assignments owned by group-name are to be viewed. If group-name is not valid, VIEWB2 exits with an error. Specifying group is only allowed on databases enabled for multi-tenancy.
shared
Specifies that the only the area and object assignments of shared tables and objects are to be viewed. Specifying shared is only allowed on databases enabled for multi-tenancy.
VIEWB2 displays the alternate buffer pool assignments for objects of all schemas as well as area level assignments. Since objects in a Type II area can be assigned to an alternate buffer pool independently of their area assignment, each object in a Type II area is displayed regardless of the area status. Although objects in a Type I area cannot be explicitly assigned to the alternate buffer pool, they are individually listed to clearly identify the objects associated with a storage area when a storage area is assigned to the alternate buffer pool.

Sample PROUTIL VIEWB2 output

A sample of the output from PROUTIL VIEWB2, follows:
Area "Customer/Order Area":8 - Primary Buffer Pool
Object Enablement Type Object Name                    Partition/Tenant/Group
----------------- ------ -----------                    --------------------
Alternate Table PUB.Customer:2 <none>
Default Table PUB.Order:4 <none>
Default Table PUB.Order-Line:5 <none>
Alternate Index PUB.Customer.Sales-Rep:16 <none>
Default Index PUB.Order.Cust-Order:21 <none>
Area "Primary Index Area":9 - Primary Buffer Pool

Object Enablement Type Object Name                    Partition/Tenant/Group
----------------- ------ -----------                    --------------------
Alternate Index PUB.Customer.Cust-Num:12 <none>
Default Index PUB.Order.Order-Num:20 <none>
Default Index PUB.Order-Line.order-line:24 <none>
Area "Customer Index Area":10 - Primary Buffer Pool

Object Enablement Type Object Name                    Partition/Tenant/Group
----------------- ------ -----------                    --------------------
Alternate Index PUB.Customer.Comments:13 <none>
Alternate Index PUB.Customer.Country-Post:14 <none>
Alternate Index PUB.Customer.Name:15 <none>
Area "Order Index Area":11 - Primary Buffer Pool

Object Enablement Type Object Name                    Partition/Tenant/Group
----------------- ------ -----------                    --------------------
Default Index PUB.Order.Order-Date:22 <none>
Default Index PUB.Order.Sales-Rep:23 <none>
Default Index PUB.Order-Line.item-num:25 <none>

Notes

*VIEWB2 maybe run online or offline.
*For the Partition/Tenant/Group column:
*Entries preceded by P: indicate a table partitioned object.
*Entries preceded by T: indicate an object associated with a multi-tenant tenant.
*Entries preceded by G: indicate an object associated with a multi-tenant group.
*Index Objects with the form P:Global:0 are global indexes.
*Index or Table entries with the form P:Transitional:0 indicate the composite initial partition.
*Alternate buffer pool assignments for objects visible through ABL (in the PUB schema) can be updated and viewed through the Data Dictionary.
*For more information on assigning objects to the alternate buffer pool, see PROUTILENABLEB2 qualifier or the Data Dictionary.
*For more information on removing objects from the alternate buffer pool, see PROUTILDISABLEB2 qualifier or the Data Dictionary.