This screen displays the utilization of each page in a global
buffer. Because there can be many times more buffers and pages
than displayable geography, this screen contains multiple pages.
Use the left angle bracket (<) key to go to the previous page
and the right angle bracket (>) key to go to the next page of the
screen.
This screen is organized in units of buffers. Each "|" delineates
a buffer. Each character between "|"s represents a single page.
A buffer can contain fewer than the maximum number of pages,
depending on the various storage area page sizes. Inadmissible
pages are marked using underscore ("_") and can be ignored.
The number of users sharing a particular page is known as the
share-count. This screen is based on a display-threshold that
is compared against the number of users sharing a particular
page. Initially, the display threshold value is 1. The display
threshold can be configured, as described below.
Page share-counts are identified as follows:
o Space (" ")- A page with a share-count less than the display-
threshold
o Dot (".")- A page with a share-count identical to the display-
threshold
o Digit from 2 through 9- A page with share-count that exceeds
the display-threshold but is less than ten, identified by the
respective digit
o Asterisk ("*")- A page with share-count that exceeds the
display-threshold by 10 or more
A row of "X"s delineates the end of the global buffer pool. All
blank lines following the row of "X"s can be ignored.
As a general measure of global buffer pool utilization when using
the default display-threshold, a display containing a lot of
blanks is not good; this probably indicates that the global
buffer pool is sized too large for the current number of users
accessing the database. A display containing a lot of dots (".")
is not good since this indicates non-sharing of pages; this
probably indicates that local buffers might be a better choice.
A display containing a lot of numeric digits is good, since
this indicates good page sharing. A display containing a lot
of asterisks ("*") is very good, since this indicates tremendous
page sharing.
You can use the "Config" menu option to filter the "GB
Utilization" display. Select this option, by typing the letter
C, to display the configuration submenu.
The configuration submenu contains a single option: "Filter
Utilization Display". Selecting this option will display the
prompt "Enter global buffer threshold (1+) [current=1]: ". The
threshold indicates the number of users sharing a page to be
displayed; for instance, if you entered "5" then only those pages
being accessed by 5 or more users will be displayed. Also, those
pages shared by exactly 5 users would be identified using a dot
(".") and those more than 5 would be identified using the digits
6 through 9 or the asterisk ("*") if more than nine users are
sharing a page.
This screen is not saved in the binary output file and cannot be
selected during binary file replay.