MON_GET_GROUP_BUFFERPOOL table function - Get group buffer pool metrics
The MON_GET_GROUP_BUFFERPOOL table function returns statistics about the group buffer pool (GBP).
Syntax
Table function parameters
The schema is SYSPROC.
- member
- An input argument of type INTEGER that specifies a valid member in the same instance as the currently connected database. Specify -1 for the current database member, or -2 for all active members. If the NULL value is specified, -1 is set implicitly.
Authorization
One of the following authorities is required to execute the routine:
- EXECUTE privilege on the routine
- DATAACCESS authority
- DBADM authority
- SQLADM authority
Default PUBLIC privilege
None
Example
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.
If the value of NUM_GBP_FULL
increases by more than one per minute, then the current size of the
GBP likely does not meet your needs. In this case, increase the size
of the GBP with the command:
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.Information Returned
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. |