viewB2 as an instant dbanalys

Posted by George Potemkin on 03-Feb-2018 04:45

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

Posted by Ruanne Cluer on 16-Apr-2018 08:49
This thread is closed