SNAP_GET_DBM_V95 table function - Retrieve the dbm logical grouping snapshot information
The SNAP_GET_DBM_V95 table function returns the snapshot monitor database manager (dbm) logical grouping information.
Important: The SNAP_GET_DBM_V95
table function is deprecated and have been replaced by the MON_GET_INSTANCE table function - Get instance level information.
Refer to Table 1 for a complete list of information that can be returned.
Syntax
The schema is SYSPROC.
Table function parameter
- member
- An optional input argument of type INTEGER that specifies a valid database member number. Specify -1 for the current database member, or -2 for an aggregate of all active database members. If this input option is not used, data will be returned from all active database members. An active database member is a member where the database is available for connection and use by applications.
If member is set to NULL, an attempt is made to read data from the file created by SNAP_WRITE_FILE procedure. Note that this file could have been created at any time, which means that the data might not be current. If a file with the corresponding snapshot API request type does not exist, then the SNAP_GET_DBM_V95 table function calls the snapshot from memory.
Authorization
One of the
following authorizations is required:
- EXECUTE privilege on the SNAP_GET_DBM_V95 table function
- DATAACCESS authority
In addition, to access snapshot monitor data, one of
the following authorities is also required:
- SYSMON
- SYSCTRL
- SYSMAINT
- SYSADM
Default PUBLIC privilege
In a non-restrictive database, EXECUTE privilege is granted to PUBLIC when the function is automatically created.
Example
Retrieve the start time and current
status of database member number 2.
SELECT DB2START_TIME, DB2_STATUS FROM TABLE(SNAP_GET_DBM_V95(2)) AS T
The
following is an example of output from this query.
DB2START_TIME DB2_STATUS
-------------------------- ------------
2006-01-06-14.59.59.062798 ACTIVE