查看當(dāng)前系統(tǒng)資源快照的DB2命令行
作者:佚名 
  如果想查看當(dāng)前系統(tǒng)資源快照,應(yīng)該如何實(shí)現(xiàn)呢?下文就教您一個(gè)使用DB2命令行實(shí)現(xiàn)該功能的方法,供您參考借鑒。
 下面為您介紹的DB2命令行用于實(shí)現(xiàn)查看當(dāng)前系統(tǒng)資源快照,該DB2命令行供您參考,希望可以讓您對(duì)DB2命令行有更深的認(rèn)識(shí)。
- db2 get monitor switches
 - db2 update monitor switches using lock on
 - db2 update monitor switches using statement on
 - db2 update monitor switches using table on
 - db2 update monitor switches using bufferpool on
 - db2 update monitor switches using sort on
 - db2 update monitor switches using uow on
 - db2 update monitor switches using TIMESTAMP on
 - db2 connect to dbname user username using password
 - db2 -v get snapshot for locks on dbname >lock.out
 - db2 -v get snapshot for dynamic sql on dbname >dynamicsql.out
 - db2 -v get snapshot for tables on dbname >tables.out
 - db2 -v get snapshot for Applications on dbname >app.out
 - db2 -v get snapshot for database on dbname
 - db2 -v get snapshot for all on dbname >snapshot.out
 
【編輯推薦】
aix環(huán)境下創(chuàng)建DB2表空間的實(shí)現(xiàn)方法
責(zé)任編輯:段燃 
                    來(lái)源:
                    互聯(lián)網(wǎng)
 














 
 
 
 
 
 
 