db2mtrk -d -v output

 -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

 

转载于:https://www.cnblogs.com/kwingmei/p/3494987.html