MON_GET_DATABASE table function - Get database metrics

Authorization

Default PUBLIC privilege

None

Syntax

The schema is SYSPROC.

Routine parameters

member

An input parameter of type INTEGER that specifies a valid database member from which the records should be fetched. Specify -1 or null for the current member, or -2 for information from all active database members. An active database member is a database that is available for connection and use by applications.

Information returned

Examples

1. Determine the activation time, activation state, total connections, and connection high water mark for the current database on all members:

   SELECT DB_CONN_TIME, DB_ACTIVATION_STATE, TOTAL_CONS, CONNECTIONS_TOP 
      FROM TABLE (MON_GET_DATABASE(-2));

   This query returns the following output:

   DB_CONN_TIME                DB_ACTIVATION_STATE  TOTAL_CONS  CONNECTIONS_TOP
   --------------------------  -------------------  ----------  ---------------
   2012-09-11-16.31.42.000000  NONE                         23               13
   

2. Get the explicit hierarchical locking state for the database from all database members.

   SELECT MEMBER,
          DATA_SHARING_REMOTE_LOCKWAIT_COUNT AS DSRL_COUNT,
          DATA_SHARING_REMOTE_LOCKWAIT_TIME AS DSRL_TIME
       FROM TABLE(MON_GET_DATABASE(-2))
   

   The query returns the following output, indicating that one table exited from a "NOT_SHARED" state, taking approximately 10 seconds to do so.

     MEMBER DSRL_COUNT           DSRL_TIME
     ------ -------------------- --------------------
          0                    0                    0
          1                    1                10042
          2                    0                    0