DB2监控系统关键表函数与视图详解

常用的监控系统的表函数和视图

视图, 监控系统, 函数
一.监控表函数
-- 查看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 
--查看数据库的监视器快照
SELECT * FROM TABLE( SNAPSHOT_DATABASE( 'SAMPLE', -1 )) as SNAPSHOT_DATABASE 
--查看数据库应用程序的监视器快照
SELECT * FROM TABLE( SNAPSHOT_APPL( 'SAMPLE', -1 )) as SNAPSHOT_APPL 
--查看数据库应用程序详细信息的监视器快照
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