db2pd与db2top管理

db2 describe table sysibmadm.admintabinfo   

db2 list applications 查看使用

db2 list db directory  查看所有数据库

db2 list tables for schema syscat

db2 describe table syscat.INDEXES  

db2 get db cfg for cmbcepay

db2 list utilities show detail
db2 list history backup all for cmbcepay

 

db2 "select substr(tabschema,1,20) as tabschema, substr(tabname,1,20) as tabname, data_object_p_size/1024 as datasize,index_object_p_size/1024 as index_size,long_object_p_size as long_size,lob_object_p_size as lob_size from sysibmadm.admintabinfo where tabschema in ('EPAY','GATEWAY') order by data_object_p_size,index_object_p_size with ur"

 

 

 

db2pd -h

db2pd -d cmbcepay
db2pd -d cmbcepay -tables

db2pd -d cmbcepay -buff

db2pd -d cmbcepay -locks

db2pd -d cmbcepay -wlocks
db2pd -d cmbcepay -lock showlocks wait
db2pd -d cmbcepay -lock showlocks|more
db2pd -d cmbcepay -lock|more
db2pd -d cmbcepay -lock|wc -l
db2pd -d cmbcepay -logs

 

db2top -d cmbcepay  交互平台获取动态系统

db2top -d cmbcepay -i 5

 

 

 

  496  db2 force application all
  497  db2 list applications
  498  db2 connect to cmbcepay
  506  db2 alter bufferpool IBMDEFAULTBP immediate size 10000
  507  db2 list applications
  508  db2 alter bufferpool IBMDEFAULTBP immediate size 10000
  509  db2 force applications
  510  db2 force applcations
  511  db2 force application all
db2 alter bufferpool IBMDEFAULTBP immediate size 10000
db2stop
db2 list applications
db2stop force 
db2start
db2 alter bufferpool CMBCEPAYPOOL immediate size 15000
db2 alter bufferpool GWBP immediate size 10000
db2 alter bufferpool TMP01_BUF immediate size 5000
db2 alter bufferpool IBMDEFAULTBP immediate size 30000
db2pd -d cmbcepay -buff
db2 connect to cmbcepay
db2 list applications
db2 get db cfg
db2 update db cfg using maxlocks 20
db2 get db cfg show detail
db2pd -d cmbcepay -wlocks

 

db2diag -f

 

转载于:https://www.cnblogs.com/atwanli/articles/4962638.html