db2pd与db2top管理

最新推荐文章于 2023-12-21 04:55:24 发布

转载最新推荐文章于 2023-12-21 04:55:24 发布 · 354 阅读

1 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/atwanli/articles/4962638.html

文章标签：

#数据库

本文详细介绍了DB2数据库的管理和优化技巧，包括如何使用db2describetables、db2listapplications、db2listdbdirectory等命令进行数据库表、应用及目录的查看，以及如何通过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