DB2 Snapshot 大全

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    
--------- ----------------------- -------------------- ----------------------