-d Display database level memory usage
-v verbose
-----------------------------------------------------
Tracking Memory on: 2013/12/28 at 00:47:52
Memory for database: ALLFILES(数据库名,当前连接的)
Backup/Restore/Util Heap is of size 65536 bytes 备份/恢复/工具集 64k的空间
Package Cache is of size 196608 bytes 包缓存 196k的空间
Other Memory is of size 131072 bytes 其他的内存空间大小130k
Catalog Cache Heap is of size 65536 bytes 编目缓存堆 64k
Buffer Pool Heap (1) is of size 4521984 bytes 缓冲池堆 4M
Buffer Pool Heap (System 32k buffer pool) is of size 851968 bytes 832k = 32k x 26
Buffer Pool Heap (System 16k buffer pool) is of size 589824 bytes 576k = 16k x 36
Buffer Pool Heap (System 8k buffer pool) is of size 458752 bytes 448k = 56 x 8
Buffer Pool Heap (System 4k buffer pool) is of size 393216 bytes 384k = 96 x 4
Shared Sort Heap is of size 0 bytes 共享排序堆
Lock Manager Heap is of size 26476544 bytes 管理器锁堆 2.5M
Database Heap is of size 14876672 bytes 数据库堆
Application Heap (58) is of size 65536 bytes
Application Heap (65587) is of size 65536 bytes
Application Heap (57) is of size 65536 bytes
Application Heap (56) is of size 65536 bytes
Application Heap (55) is of size 131072 bytes
Application Heap (54) is of size 65536 bytes
Application Heap (53) is of size 65536 bytes
Applications Shared Heap is of size 262144 bytes 256k
Total: 49414144 bytes 共 47M
获取db配置的值
select * from sysibmadm.dbcfg
打开快照开关
db2 update monitor switches using bufferpool on
获取buferpool的值
1) select substr(bp_name,1,25) as BP_name, BP_CUR_BUFFSZ as BP_Pages from sysibmadm.snapbp_part
2) b2 GET SNAPSHOT FOR BUFFERPOOLS ON allfiles
mempools的值
db2pd -db allfiles -mempools