Capturing database system snapshots by using snapshot administrative views and table functions
Before you begin
You must have SYSADM, SYSCTRL, SYSMAINT, or SYSMON authority to capture a database snapshot. To obtain a snapshot of a remote instance, you must first connect to a local database belonging to that instance.
About this task
While new snapshot table functions might be required in future releases if new monitor data is available, the set of snapshot administrative views will remain the same with new columns added to the view, making the administrative views a good choice for application maintenance over time.
Each snapshot view returns a table with one row per monitored object per database partition with each column representing a monitor element. Each table function returns a table with one row per monitored object for the specified partition. The column names of the returned table correlate with the monitor element names.
SELECT * FROM SYSIBMADM.SNAPAPPL
SELECT agent_id, db_name FROM SYSIBMADM.SNAPAPPL
Restrictions
- Monitor switches commands or APIs
- Monitor reset commands or APIs
- GET MONITOR SWITCHES
- UPDATE MONITOR SWITCHES
- RESET MONITOR