DB2 Snapshot用于监视数据库对象活动快照信息。在命令中可以指明要扑捉快照的级别和数据库对象
The Snapshot Monitor
GET SNAPSHOT FOR DBM
GET SNAPSHOT FOR DB ON SAMPLEDB
db2 get snapshot for application agentid 12345
db2 get snapshot for locks for application agentid 12345
GET SNAPSHOT FOR BUFFERPOOLS ON SAMPLEDB
GET SNAPSHOT FOR TABLES ON SAMPLEDB
GET SNAPSHOT FOR LOCKS ON SAMPLEDB
GET SNAPSHOT FOR DYNAMIC SQL ON SAMPLEDB
GET SNAPSHOT FOR ALL ON SAMPLEDB
三.The Snapshot VIEWS
SELECT * FROM SYSIBMADM.APPLICATIONS
SELECT * FROM SYSIBMADM.APPL_PERFORMANCE
select * from SYSIBMADM.BP_HITRATIO
--buffer pool read performance information
select * from SYSIBMADM.BP_READ_IO
--contains buffer pool write performance information
select * from SYSIBMADM.BP_WRITE_IO
--information about table space containers and utilization rates
select * from SYSIBMADM.CONTAINER_UTILIZATION
--information on locks that are waiting to granted
select * from SYSIBMADM.LOCKWAITS
--The LOG_UTILIZATION administrative view returns information about log utilization for the currently connected database
db2 => select * from SYSIBMADM.LOG_UTILIZATION
DB_NAME LOG_UTILIZATION_PERCENT TOTAL_LOG_USED_KB TOTAL_LOG_AVAILABLE_KB TOTAL_LOG_USED_TOP_KB DBPARTITIONNUM
--------- ----------------------- -------------------- ----------------------