DB2 Version 10.1 for Linux, UNIX, and Windows

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


>>-MON_GET_GROUP_BUFFERPOOL--(--member--)----------------------><

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

Table 1. Information returned for MON_GET_GROUP_BUFFERPOOL
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.