The SNAPDBM administrative view and the SNAP_GET_DBM table function return the snapshot monitor DB2® database manager (dbm) logical grouping information.
Used with the SNAPSWITCHES administrative view and the MON_GET_FCM, MON_GET_MEMORY_SET, MON_GET_MEMORY_POOL table functions, the SNAPDBM administrative view provides the data equivalent to the GET SNAPSHOT FOR DBM command.
The schema is SYSIBMADM.
Refer to Table 1 for a complete list of information that can be returned.
In a non-restrictive database, SELECT privilege is granted to PUBLIC when the view is automatically created.
SELECT DB2_STATUS, DB2START_TIME, LAST_RESET, LOCAL_CONS, REM_CONS_IN,
(AGENTS_CREATED_EMPTY_POOL/AGENTS_FROM_POOL) AS AGENT_USAGE,
DBPARTITIONNUM FROM SYSIBMADM.SNAPDBM ORDER BY DBPARTITIONNUM
DB2_STATUS DB2START_TIME LAST_RESET ...
------------ -------------------------- ----------...- ...
ACTIVE 2006-01-06-14.59.59.059879 - ...
ACTIVE 2006-01-06-14.59.59.097605 - ...
ACTIVE 2006-01-06-14.59.59.062798 - ...
3 record(s) selected. ...
... LOCAL_CONS REM_CONS_IN AGENT_USAGE DBPARTITIONNUM
... ----------...- -----------...- -----------...- --------------
... 1 1 0 0
... 0 0 0 1
... 0 0 0 2
The SNAP_GET_DBM table function returns the same information as the SNAPDBM administrative view, but allows you to retrieve the information for a specific database member, aggregate of all database members or all database members.
Used with the SNAP_GET_DBM_MEMORY_POOL, SNAP_GET_FCM, SNAP_GET_FCM_PART and SNAP_GET_SWITCHES table functions, the SNAP_GET_DBM table function provides the data equivalent to the GET SNAPSHOT FOR DBM command.
Refer to Table 1 for a complete list of information that can be returned.
>>-SNAP_GET_DBM--(--+--------+--)------------------------------>< '-member-'
The schema is SYSPROC.
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 table function calls the snapshot from memory.
In a non-restrictive database, EXECUTE privilege is granted to PUBLIC when the function is automatically created.
SELECT DB2START_TIME, DB2_STATUS FROM TABLE(SNAP_GET_DBM(2)) AS T
DB2START_TIME DB2_STATUS
-------------------------- ------------
2006-01-06-14.59.59.062798 ACTIVE