DB2 快照表Snapshot

snapshot用于监视数据库对象活动快照信息。在命令中可以指明要扑捉快照的级别和数据库对象

一.Snapshot Monitor SQL Table Function
-- 查看DBM的监视器快照
SELECT * FROM TABLE( SNAPSHOT_DBM(-1)) as SNAPSHOT_DBM
--To capture a snapshot of database manager information specifically regarding the fast communication manager (FCM):
SELECT * FROM TABLE( SNAPSHOT_FCM(-1)) as SNAPSHOT_FCM
--To capture a snapshot of database manager information for a partition specifically regarding the fast communication manager(FCM):
SELECT * FROM TABLE( SNAPSHOT_FCMPARTITION(-1)) as SNAPSHOT_FCMPARTITION
--To capture the database manager's monitor switch settings:
SELECT * FROM TABLE( SNAPSHOT_SWITCHES(-1)) as SNAPSHOT_SWITCHES
--查看数据库的监视器快照(rows_read，total_log_used)
SELECT TOTAL_LOG_USED,TOTAL_LOG_AVAILABLE,ROWS_READ FROM TABLE( SNAPSHOT_DATABASE( 'ADB', -1 )) as SNAPSHOT_DATABASE ---TOTAL_LOG_USED,TOTAL_LOG_AVAILABLE,ROWS_READ
--查看数据库应用程序的监视器快照
SELECT * FROM TABLE( SNAPSHOT_APPL( 'SAMPLE', -1 )) as SNAPSHOT_APPL --ROWS_READ,ROWS_SELECTED
--查看数据库应用程序详细信息的监视器快照
SELECT * FROM TABLE( SNAPSHOT_APPL_INFO( 'SAMPLE', -1 )) as SNAPSHOT_APPL_INFO
--查询锁等待信息
SELECT * FROM TABLE( SNAPSHOT_LOCKWAIT('SAMPLE', -1 )) as SNAPSHOT_LOCKWAIT
--查询数据库执行的SQL语句
SELECT * FROM TABLE( SNAPSHOT_STATEMENT( 'SAMPLE', -1 )) as SNAPSHOT_STATEMENT
--查询数据库代理程序信息
SELECT * FROM TABLE( SNAPSHOT_AGENT( 'SAMPLE', -1 )) as SNAPSHOT_AGENT
--查询数据库子查询的快照
SELECT * FROM TABLE( SNAPSHOT_SUBSECT( 'SAMPLE', -1 )) as SNAPSHOT_SUBSECT
--查询缓冲池的监控快照
SELECT * FROM TABLE( SNAPSHOT_BP( 'SAMPLE', -1 )) as SNAPSHOT_BP
--查询表空间的监控快照
SELECT * FROM TABLE( SNAPSHOT_TBS( 'SAMPLE', -1 )) as SNAPSHOT_TBS
--查询