viewB2 as an instant dbanalys - Forum - OpenEdge RDBMS - Progress Community

viewB2 as an instant dbanalys

 Forum

viewB2 as an instant dbanalys

This question is not answered

At least since V11.6.3 the output of proutil -C viewB2 is changed:

11.5 and before:

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

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

11.6.3 and 11.7.2:

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

Object Enablement    Size     Type   Object Name
-----------------  -------- -------  ------------
Default                   7  Master   Area.Control-Object:0
Default                   8   Table   PUB.Customer:2
Default                  16   Table   PUB.Order:4
Default                  32   Table   PUB.Order-Line:5
Default                   8   Index   PUB.Customer.Sales-Rep:16
Default                   8   Index   PUB.Order.Cust-Order:21
                   --------
                         79


In other words, now viewB2 reports the number of blocks used by every object in type 2 storage areas. This information is stored in the object blocks and it can be used as quick way to estimate the size of the objects.

The change is not documented.
Is it available in 11.6 without service packs?

All Replies