The MON_GET_GROUP_BUFFERPOOL table function returns statistics about the group buffer pool (GBP).
The schema is SYSPROC.
None
If the group buffer pool (GBP) does not have sufficient space when attempting to register a page or write a page to the GBP, a GBP_FULL error occurs.
The following example returns the number of times the GBP_FULL error is encountered from all members.
SELECT SUM(T.NUM_GBP_FULL) AS NUM_GBP_FULL
FROM TABLE(MON_GET_GROUP_BUFFERPOOL(-2)) AS T
The following is an example of output from this query.
NUM_GBP_FULL
------------
123
1 record(s) selected.
UPDATE DB CFG USING CF_GBP_SIZE <new_size>
For this command, the value of <new_size> grows
the group buffer pool to a size sufficient to slow or stop the increasing
number of GBP_FULL errors.Column name | Data type | Description or corresponding monitor element |
---|---|---|
MEMBER | SMALLINT | member- Database member |
NUM_GBP_FULL | BIGINT | Number of times the GBP_FULL error occurs. |