By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,291 Members | 3,120 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,291 IT Pros & Developers. It's quick & easy.

memory question

P: n/a
hi, we are using db2 udb v8.1 for windows, i have changed the buffer
pool size to accommadate better performance, say size 200000, if i
have multiple connection to the same database from application
server, will each connection take the memory 800M (200000 x 4k = 800
M), so the memory took will be 800M times number of connections, or
the total memory get from bufferpool will be 800M?
Nov 12 '05 #1
Share this Question
Share on Google+
22 Replies


P: n/a
"xixi" <da****@yahoo.com> wrote in message
news:c0**************************@posting.google.c om...
hi, we are using db2 udb v8.1 for windows, i have changed the buffer
pool size to accommadate better performance, say size 200000, if i
have multiple connection to the same database from application
server, will each connection take the memory 800M (200000 x 4k = 800
M), so the memory took will be 800M times number of connections, or
the total memory get from bufferpool will be 800M?


DB2 Buffer pools are shared memory used by all connections to the database.
Data pages and index pages are fetched from disk and buffered in the DB2
buffer pools. Data stays in the buffer pool until a new page needs to be
loaded and the there is no empty space. Then, existing pages in the buffer
pool are over-written based on a least recently used algorithm (and other
more complex considerations).

Buffer pool memory is allocated when the first user connects to a database
or the database is activated.
Nov 12 '05 #2

P: n/a
"xixi" <da****@yahoo.com> wrote in message
news:c0**************************@posting.google.c om...
hi, we are using db2 udb v8.1 for windows, i have changed the buffer
pool size to accommadate better performance, say size 200000, if i
have multiple connection to the same database from application
server, will each connection take the memory 800M (200000 x 4k = 800
M), so the memory took will be 800M times number of connections, or
the total memory get from bufferpool will be 800M?


DB2 Buffer pools are shared memory used by all connections to the database.
Data pages and index pages are fetched from disk and buffered in the DB2
buffer pools. Data stays in the buffer pool until a new page needs to be
loaded and the there is no empty space. Then, existing pages in the buffer
pool are over-written based on a least recently used algorithm (and other
more complex considerations).

Buffer pool memory is allocated when the first user connects to a database
or the database is activated.
Nov 12 '05 #3

P: n/a
the db2mtrk system command can help you see how much memory is used by
bufferpools and other db2 components.

PM

"xixi" <da****@yahoo.com> a écrit dans le message de
news:c0**************************@posting.google.c om...
hi, we are using db2 udb v8.1 for windows, i have changed the buffer
pool size to accommadate better performance, say size 200000, if i
have multiple connection to the same database from application
server, will each connection take the memory 800M (200000 x 4k = 800
M), so the memory took will be 800M times number of connections, or
the total memory get from bufferpool will be 800M?

Nov 12 '05 #4

P: n/a
the db2mtrk system command can help you see how much memory is used by
bufferpools and other db2 components.

PM

"xixi" <da****@yahoo.com> a écrit dans le message de
news:c0**************************@posting.google.c om...
hi, we are using db2 udb v8.1 for windows, i have changed the buffer
pool size to accommadate better performance, say size 200000, if i
have multiple connection to the same database from application
server, will each connection take the memory 800M (200000 x 4k = 800
M), so the memory took will be 800M times number of connections, or
the total memory get from bufferpool will be 800M?

Nov 12 '05 #5

P: n/a
i use db2mtrk and get this , i notice that all total memory bytes add
togeter not over 1g, but our server under db2sysc.exe has over 2g mem
used, why is that?

Memory for instance

Backup/Restore/Util Heap is of size 16384 bytes
Package Cache is of size 327680 bytes
Catalog Cache Heap is of size 163840 bytes
Buffer Pool Heap is of size 8339456 bytes
Buffer Pool Heap is of size 1179648 bytes
Buffer Pool Heap is of size 655360 bytes
Buffer Pool Heap is of size 393216 bytes
Buffer Pool Heap is of size 262144 bytes
Buffer Pool Heap is of size 196608 bytes
Lock Manager Heap is of size 278528 bytes
Database Heap is of size 3342336 bytes
Database Monitor Heap is of size 180224 bytes
Other Memory is of size 7700480 bytes
Total: 23035904 bytes

Memory for agent 2208

Other Memory is of size 16384 bytes
Application Heap is of size 491520 bytes
Application Control Heap is of size 16384 bytes
Total: 524288 bytes

Memory for agent 2252

Other Memory is of size 32768 bytes
Application Heap is of size 278528 bytes
Application Control Heap is of size 16384 bytes
Total: 327680 bytes

Memory for agent 2172

Other Memory is of size 16384 bytes
Application Heap is of size 212992 bytes
Application Control Heap is of size 16384 bytes
Total: 245760 bytes
Nov 12 '05 #6

P: n/a
i use db2mtrk and get this , i notice that all total memory bytes add
togeter not over 1g, but our server under db2sysc.exe has over 2g mem
used, why is that?

Memory for instance

Backup/Restore/Util Heap is of size 16384 bytes
Package Cache is of size 327680 bytes
Catalog Cache Heap is of size 163840 bytes
Buffer Pool Heap is of size 8339456 bytes
Buffer Pool Heap is of size 1179648 bytes
Buffer Pool Heap is of size 655360 bytes
Buffer Pool Heap is of size 393216 bytes
Buffer Pool Heap is of size 262144 bytes
Buffer Pool Heap is of size 196608 bytes
Lock Manager Heap is of size 278528 bytes
Database Heap is of size 3342336 bytes
Database Monitor Heap is of size 180224 bytes
Other Memory is of size 7700480 bytes
Total: 23035904 bytes

Memory for agent 2208

Other Memory is of size 16384 bytes
Application Heap is of size 491520 bytes
Application Control Heap is of size 16384 bytes
Total: 524288 bytes

Memory for agent 2252

Other Memory is of size 32768 bytes
Application Heap is of size 278528 bytes
Application Control Heap is of size 16384 bytes
Total: 327680 bytes

Memory for agent 2172

Other Memory is of size 16384 bytes
Application Heap is of size 212992 bytes
Application Control Heap is of size 16384 bytes
Total: 245760 bytes
Nov 12 '05 #7

P: n/a
hi, please ignore my recent post email, here is the right memory
tracking, i have three database under same instance, but we only focus
one, is that even i don't have access to the other two databases,
they also take up memory? i only only three bufferpools under each
database, ibmdefaultbf and the other two i created, so why there are
six bufferpool heap ? what is the difference between bufferpool heap
and bufferpool size? thanks

D:\Program Files\IBM\SQLLIB\BIN>db2 connect to njipd

Database Connection Information

Database server = DB2/NT64 8.1.3
SQL authorization ID = ADMIN
Local database alias = NJIPD
D:\Program Files\IBM\SQLLIB\BIN>db2mtrk -i -p -v
Tracking Memory on: 2004/04/30 at 16:04:55

Memory for instance

Backup/Restore/Util Heap is of size 16384 bytes
Package Cache is of size 442368 bytes
Catalog Cache Heap is of size 425984 bytes
Buffer Pool Heap is of size 1196032 bytes
Buffer Pool Heap is of size 8355840 bytes
Buffer Pool Heap is of size 427737088 bytes
Buffer Pool Heap is of size 655360 bytes
Buffer Pool Heap is of size 393216 bytes
Buffer Pool Heap is of size 262144 bytes
Buffer Pool Heap is of size 196608 bytes
Lock Manager Heap is of size 4243456 bytes
Database Heap is of size 1736704 bytes
Backup/Restore/Util Heap is of size 16384 bytes
Package Cache is of size 442368 bytes
Catalog Cache Heap is of size 425984 bytes
Buffer Pool Heap is of size 2473984 bytes
Buffer Pool Heap is of size 23445504 bytes
Buffer Pool Heap is of size 655360 bytes
Buffer Pool Heap is of size 393216 bytes
Buffer Pool Heap is of size 262144 bytes
Buffer Pool Heap is of size 196608 bytes
Lock Manager Heap is of size 4243456 bytes
Database Heap is of size 1753088 bytes
Backup/Restore/Util Heap is of size 16384 bytes
Package Cache is of size 6635520 bytes
Catalog Cache Heap is of size 4259840 bytes
Buffer Pool Heap is of size 1196032 bytes
Buffer Pool Heap is of size 8355840 bytes
Buffer Pool Heap is of size 1069350912 bytes
Buffer Pool Heap is of size 655360 bytes
Buffer Pool Heap is of size 393216 bytes
Buffer Pool Heap is of size 262144 bytes
Buffer Pool Heap is of size 196608 bytes
Lock Manager Heap is of size 4243456 bytes
Database Heap is of size 4571136 bytes
Database Monitor Heap is of size 344064 bytes
Other Memory is of size 13451264 bytes
Total: 1593901056 bytes

Memory for agent 3588

No memory allocated

Memory for agent 3228

Other Memory is of size 32768 bytes
Application Heap is of size 65536 bytes
Application Control Heap is of size 16384 bytes
Total: 114688 bytes

Memory for agent 3560

No memory allocated

Memory for agent 2428

No memory allocated

Memory for agent 3764

Other Memory is of size 32768 bytes
Application Heap is of size 65536 bytes
Application Control Heap is of size 16384 bytes
Total: 114688 bytes

Memory for agent 2608

Other Memory is of size 32768 bytes
Application Heap is of size 212992 bytes
Application Control Heap is of size 16384 bytes
Total: 262144 bytes

Memory for agent 488

Other Memory is of size 32768 bytes
Application Heap is of size 212992 bytes
Application Control Heap is of size 16384 bytes
Total: 262144 bytes

Memory for agent 3656

No memory allocated

Memory for agent 2820

No memory allocated

Memory for agent 3132

No memory allocated

Memory for agent 3064

No memory allocated

Memory for agent 3428

No memory allocated

Memory for agent 2952

No memory allocated

Memory for agent 492

No memory allocated

Memory for agent 1904

No memory allocated

Memory for agent 3996

No memory allocated

Memory for agent 3520

No memory allocated

Memory for agent 3604

No memory allocated

Memory for agent 4092

No memory allocated

Memory for agent 2272

No memory allocated

Memory for agent 3848

No memory allocated

Memory for agent 2192

No memory allocated

Memory for agent 3472

Other Memory is of size 32768 bytes
Application Heap is of size 147456 bytes
Application Control Heap is of size 16384 bytes
Total: 196608 bytes

Memory for agent 3368

No memory allocated

Memory for agent 2828

No memory allocated

Memory for agent 636

No memory allocated

Memory for agent 3748

No memory allocated

Memory for agent 3352

No memory allocated

Memory for agent 2696

No memory allocated

Memory for agent 1764

Other Memory is of size 32768 bytes
Application Heap is of size 704512 bytes
Application Control Heap is of size 16384 bytes
Total: 753664 bytes

Memory for agent 2464

No memory allocated

Memory for agent 3756

No memory allocated

Memory for agent 2744

No memory allocated

Memory for agent 2288

No memory allocated

Memory for agent 3552

No memory allocated

Memory for agent 2932

Application Heap is of size 212992 bytes
Application Control Heap is of size 16384 bytes
Total: 229376 bytes

Memory for agent 544

Application Heap is of size 212992 bytes
Application Control Heap is of size 16384 bytes
Total: 229376 bytes

Memory for agent 2060

No memory allocated

Memory for agent 2088

No memory allocated

Memory for agent 1828

Other Memory is of size 32768 bytes
Application Heap is of size 86130688 bytes
Application Control Heap is of size 16384 bytes
Total: 86179840 bytes
D:\Program Files\IBM\SQLLIB\BIN>
Nov 12 '05 #8

P: n/a
hi, please ignore my recent post email, here is the right memory
tracking, i have three database under same instance, but we only focus
one, is that even i don't have access to the other two databases,
they also take up memory? i only only three bufferpools under each
database, ibmdefaultbf and the other two i created, so why there are
six bufferpool heap ? what is the difference between bufferpool heap
and bufferpool size? thanks

D:\Program Files\IBM\SQLLIB\BIN>db2 connect to njipd

Database Connection Information

Database server = DB2/NT64 8.1.3
SQL authorization ID = ADMIN
Local database alias = NJIPD
D:\Program Files\IBM\SQLLIB\BIN>db2mtrk -i -p -v
Tracking Memory on: 2004/04/30 at 16:04:55

Memory for instance

Backup/Restore/Util Heap is of size 16384 bytes
Package Cache is of size 442368 bytes
Catalog Cache Heap is of size 425984 bytes
Buffer Pool Heap is of size 1196032 bytes
Buffer Pool Heap is of size 8355840 bytes
Buffer Pool Heap is of size 427737088 bytes
Buffer Pool Heap is of size 655360 bytes
Buffer Pool Heap is of size 393216 bytes
Buffer Pool Heap is of size 262144 bytes
Buffer Pool Heap is of size 196608 bytes
Lock Manager Heap is of size 4243456 bytes
Database Heap is of size 1736704 bytes
Backup/Restore/Util Heap is of size 16384 bytes
Package Cache is of size 442368 bytes
Catalog Cache Heap is of size 425984 bytes
Buffer Pool Heap is of size 2473984 bytes
Buffer Pool Heap is of size 23445504 bytes
Buffer Pool Heap is of size 655360 bytes
Buffer Pool Heap is of size 393216 bytes
Buffer Pool Heap is of size 262144 bytes
Buffer Pool Heap is of size 196608 bytes
Lock Manager Heap is of size 4243456 bytes
Database Heap is of size 1753088 bytes
Backup/Restore/Util Heap is of size 16384 bytes
Package Cache is of size 6635520 bytes
Catalog Cache Heap is of size 4259840 bytes
Buffer Pool Heap is of size 1196032 bytes
Buffer Pool Heap is of size 8355840 bytes
Buffer Pool Heap is of size 1069350912 bytes
Buffer Pool Heap is of size 655360 bytes
Buffer Pool Heap is of size 393216 bytes
Buffer Pool Heap is of size 262144 bytes
Buffer Pool Heap is of size 196608 bytes
Lock Manager Heap is of size 4243456 bytes
Database Heap is of size 4571136 bytes
Database Monitor Heap is of size 344064 bytes
Other Memory is of size 13451264 bytes
Total: 1593901056 bytes

Memory for agent 3588

No memory allocated

Memory for agent 3228

Other Memory is of size 32768 bytes
Application Heap is of size 65536 bytes
Application Control Heap is of size 16384 bytes
Total: 114688 bytes

Memory for agent 3560

No memory allocated

Memory for agent 2428

No memory allocated

Memory for agent 3764

Other Memory is of size 32768 bytes
Application Heap is of size 65536 bytes
Application Control Heap is of size 16384 bytes
Total: 114688 bytes

Memory for agent 2608

Other Memory is of size 32768 bytes
Application Heap is of size 212992 bytes
Application Control Heap is of size 16384 bytes
Total: 262144 bytes

Memory for agent 488

Other Memory is of size 32768 bytes
Application Heap is of size 212992 bytes
Application Control Heap is of size 16384 bytes
Total: 262144 bytes

Memory for agent 3656

No memory allocated

Memory for agent 2820

No memory allocated

Memory for agent 3132

No memory allocated

Memory for agent 3064

No memory allocated

Memory for agent 3428

No memory allocated

Memory for agent 2952

No memory allocated

Memory for agent 492

No memory allocated

Memory for agent 1904

No memory allocated

Memory for agent 3996

No memory allocated

Memory for agent 3520

No memory allocated

Memory for agent 3604

No memory allocated

Memory for agent 4092

No memory allocated

Memory for agent 2272

No memory allocated

Memory for agent 3848

No memory allocated

Memory for agent 2192

No memory allocated

Memory for agent 3472

Other Memory is of size 32768 bytes
Application Heap is of size 147456 bytes
Application Control Heap is of size 16384 bytes
Total: 196608 bytes

Memory for agent 3368

No memory allocated

Memory for agent 2828

No memory allocated

Memory for agent 636

No memory allocated

Memory for agent 3748

No memory allocated

Memory for agent 3352

No memory allocated

Memory for agent 2696

No memory allocated

Memory for agent 1764

Other Memory is of size 32768 bytes
Application Heap is of size 704512 bytes
Application Control Heap is of size 16384 bytes
Total: 753664 bytes

Memory for agent 2464

No memory allocated

Memory for agent 3756

No memory allocated

Memory for agent 2744

No memory allocated

Memory for agent 2288

No memory allocated

Memory for agent 3552

No memory allocated

Memory for agent 2932

Application Heap is of size 212992 bytes
Application Control Heap is of size 16384 bytes
Total: 229376 bytes

Memory for agent 544

Application Heap is of size 212992 bytes
Application Control Heap is of size 16384 bytes
Total: 229376 bytes

Memory for agent 2060

No memory allocated

Memory for agent 2088

No memory allocated

Memory for agent 1828

Other Memory is of size 32768 bytes
Application Heap is of size 86130688 bytes
Application Control Heap is of size 16384 bytes
Total: 86179840 bytes
D:\Program Files\IBM\SQLLIB\BIN>
Nov 12 '05 #9

P: n/a
Xixi, I believe the buffer pool heaps are defined by the system only.
They are there in case something goes wrong with your bp definitions and
the db cannot be activated.
DB2 will then use these four heaps (one heap per page size 4k,8k,16k,32k).
You do not have to worry about them as to their use and spaceutilization.
HTH, Pierre.

xixi wrote:
hi, please ignore my recent post email, here is the right memory
tracking, i have three database under same instance, but we only focus
one, is that even i don't have access to the other two databases,
they also take up memory? i only only three bufferpools under each
database, ibmdefaultbf and the other two i created, so why there are
six bufferpool heap ? what is the difference between bufferpool heap
and bufferpool size? thanks

D:\Program Files\IBM\SQLLIB\BIN>db2 connect to njipd

Database Connection Information

Database server = DB2/NT64 8.1.3
SQL authorization ID = ADMIN
Local database alias = NJIPD
D:\Program Files\IBM\SQLLIB\BIN>db2mtrk -i -p -v
Tracking Memory on: 2004/04/30 at 16:04:55

Memory for instance

Backup/Restore/Util Heap is of size 16384 bytes
Package Cache is of size 442368 bytes
Catalog Cache Heap is of size 425984 bytes
Buffer Pool Heap is of size 1196032 bytes
Buffer Pool Heap is of size 8355840 bytes
Buffer Pool Heap is of size 427737088 bytes
Buffer Pool Heap is of size 655360 bytes
Buffer Pool Heap is of size 393216 bytes
Buffer Pool Heap is of size 262144 bytes
Buffer Pool Heap is of size 196608 bytes
Lock Manager Heap is of size 4243456 bytes
Database Heap is of size 1736704 bytes
Backup/Restore/Util Heap is of size 16384 bytes
Package Cache is of size 442368 bytes
Catalog Cache Heap is of size 425984 bytes
Buffer Pool Heap is of size 2473984 bytes
Buffer Pool Heap is of size 23445504 bytes
Buffer Pool Heap is of size 655360 bytes
Buffer Pool Heap is of size 393216 bytes
Buffer Pool Heap is of size 262144 bytes
Buffer Pool Heap is of size 196608 bytes
Lock Manager Heap is of size 4243456 bytes
Database Heap is of size 1753088 bytes
Backup/Restore/Util Heap is of size 16384 bytes
Package Cache is of size 6635520 bytes
Catalog Cache Heap is of size 4259840 bytes
Buffer Pool Heap is of size 1196032 bytes
Buffer Pool Heap is of size 8355840 bytes
Buffer Pool Heap is of size 1069350912 bytes
Buffer Pool Heap is of size 655360 bytes
Buffer Pool Heap is of size 393216 bytes
Buffer Pool Heap is of size 262144 bytes
Buffer Pool Heap is of size 196608 bytes
Lock Manager Heap is of size 4243456 bytes
Database Heap is of size 4571136 bytes
Database Monitor Heap is of size 344064 bytes
Other Memory is of size 13451264 bytes
Total: 1593901056 bytes

Memory for agent 3588

No memory allocated

Memory for agent 3228

Other Memory is of size 32768 bytes
Application Heap is of size 65536 bytes
Application Control Heap is of size 16384 bytes
Total: 114688 bytes

Memory for agent 3560

No memory allocated

Memory for agent 2428

No memory allocated

Memory for agent 3764

Other Memory is of size 32768 bytes
Application Heap is of size 65536 bytes
Application Control Heap is of size 16384 bytes
Total: 114688 bytes

Memory for agent 2608

Other Memory is of size 32768 bytes
Application Heap is of size 212992 bytes
Application Control Heap is of size 16384 bytes
Total: 262144 bytes

Memory for agent 488

Other Memory is of size 32768 bytes
Application Heap is of size 212992 bytes
Application Control Heap is of size 16384 bytes
Total: 262144 bytes

Memory for agent 3656

No memory allocated

Memory for agent 2820

No memory allocated

Memory for agent 3132

No memory allocated

Memory for agent 3064

No memory allocated

Memory for agent 3428

No memory allocated

Memory for agent 2952

No memory allocated

Memory for agent 492

No memory allocated

Memory for agent 1904

No memory allocated

Memory for agent 3996

No memory allocated

Memory for agent 3520

No memory allocated

Memory for agent 3604

No memory allocated

Memory for agent 4092

No memory allocated

Memory for agent 2272

No memory allocated

Memory for agent 3848

No memory allocated

Memory for agent 2192

No memory allocated

Memory for agent 3472

Other Memory is of size 32768 bytes
Application Heap is of size 147456 bytes
Application Control Heap is of size 16384 bytes
Total: 196608 bytes

Memory for agent 3368

No memory allocated

Memory for agent 2828

No memory allocated

Memory for agent 636

No memory allocated

Memory for agent 3748

No memory allocated

Memory for agent 3352

No memory allocated

Memory for agent 2696

No memory allocated

Memory for agent 1764

Other Memory is of size 32768 bytes
Application Heap is of size 704512 bytes
Application Control Heap is of size 16384 bytes
Total: 753664 bytes

Memory for agent 2464

No memory allocated

Memory for agent 3756

No memory allocated

Memory for agent 2744

No memory allocated

Memory for agent 2288

No memory allocated

Memory for agent 3552

No memory allocated

Memory for agent 2932

Application Heap is of size 212992 bytes
Application Control Heap is of size 16384 bytes
Total: 229376 bytes

Memory for agent 544

Application Heap is of size 212992 bytes
Application Control Heap is of size 16384 bytes
Total: 229376 bytes

Memory for agent 2060

No memory allocated

Memory for agent 2088

No memory allocated

Memory for agent 1828

Other Memory is of size 32768 bytes
Application Heap is of size 86130688 bytes
Application Control Heap is of size 16384 bytes
Total: 86179840 bytes
D:\Program Files\IBM\SQLLIB\BIN>


--
Pierre Saint-Jacques - Reply to: sesconsjunk at attglobaljunk dot com
Reconstruct address: Remove the two junk and replace at and dot by
their symbols.
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.

Nov 12 '05 #10

P: n/a
Xixi, I believe the buffer pool heaps are defined by the system only.
They are there in case something goes wrong with your bp definitions and
the db cannot be activated.
DB2 will then use these four heaps (one heap per page size 4k,8k,16k,32k).
You do not have to worry about them as to their use and spaceutilization.
HTH, Pierre.

xixi wrote:
hi, please ignore my recent post email, here is the right memory
tracking, i have three database under same instance, but we only focus
one, is that even i don't have access to the other two databases,
they also take up memory? i only only three bufferpools under each
database, ibmdefaultbf and the other two i created, so why there are
six bufferpool heap ? what is the difference between bufferpool heap
and bufferpool size? thanks

D:\Program Files\IBM\SQLLIB\BIN>db2 connect to njipd

Database Connection Information

Database server = DB2/NT64 8.1.3
SQL authorization ID = ADMIN
Local database alias = NJIPD
D:\Program Files\IBM\SQLLIB\BIN>db2mtrk -i -p -v
Tracking Memory on: 2004/04/30 at 16:04:55

Memory for instance

Backup/Restore/Util Heap is of size 16384 bytes
Package Cache is of size 442368 bytes
Catalog Cache Heap is of size 425984 bytes
Buffer Pool Heap is of size 1196032 bytes
Buffer Pool Heap is of size 8355840 bytes
Buffer Pool Heap is of size 427737088 bytes
Buffer Pool Heap is of size 655360 bytes
Buffer Pool Heap is of size 393216 bytes
Buffer Pool Heap is of size 262144 bytes
Buffer Pool Heap is of size 196608 bytes
Lock Manager Heap is of size 4243456 bytes
Database Heap is of size 1736704 bytes
Backup/Restore/Util Heap is of size 16384 bytes
Package Cache is of size 442368 bytes
Catalog Cache Heap is of size 425984 bytes
Buffer Pool Heap is of size 2473984 bytes
Buffer Pool Heap is of size 23445504 bytes
Buffer Pool Heap is of size 655360 bytes
Buffer Pool Heap is of size 393216 bytes
Buffer Pool Heap is of size 262144 bytes
Buffer Pool Heap is of size 196608 bytes
Lock Manager Heap is of size 4243456 bytes
Database Heap is of size 1753088 bytes
Backup/Restore/Util Heap is of size 16384 bytes
Package Cache is of size 6635520 bytes
Catalog Cache Heap is of size 4259840 bytes
Buffer Pool Heap is of size 1196032 bytes
Buffer Pool Heap is of size 8355840 bytes
Buffer Pool Heap is of size 1069350912 bytes
Buffer Pool Heap is of size 655360 bytes
Buffer Pool Heap is of size 393216 bytes
Buffer Pool Heap is of size 262144 bytes
Buffer Pool Heap is of size 196608 bytes
Lock Manager Heap is of size 4243456 bytes
Database Heap is of size 4571136 bytes
Database Monitor Heap is of size 344064 bytes
Other Memory is of size 13451264 bytes
Total: 1593901056 bytes

Memory for agent 3588

No memory allocated

Memory for agent 3228

Other Memory is of size 32768 bytes
Application Heap is of size 65536 bytes
Application Control Heap is of size 16384 bytes
Total: 114688 bytes

Memory for agent 3560

No memory allocated

Memory for agent 2428

No memory allocated

Memory for agent 3764

Other Memory is of size 32768 bytes
Application Heap is of size 65536 bytes
Application Control Heap is of size 16384 bytes
Total: 114688 bytes

Memory for agent 2608

Other Memory is of size 32768 bytes
Application Heap is of size 212992 bytes
Application Control Heap is of size 16384 bytes
Total: 262144 bytes

Memory for agent 488

Other Memory is of size 32768 bytes
Application Heap is of size 212992 bytes
Application Control Heap is of size 16384 bytes
Total: 262144 bytes

Memory for agent 3656

No memory allocated

Memory for agent 2820

No memory allocated

Memory for agent 3132

No memory allocated

Memory for agent 3064

No memory allocated

Memory for agent 3428

No memory allocated

Memory for agent 2952

No memory allocated

Memory for agent 492

No memory allocated

Memory for agent 1904

No memory allocated

Memory for agent 3996

No memory allocated

Memory for agent 3520

No memory allocated

Memory for agent 3604

No memory allocated

Memory for agent 4092

No memory allocated

Memory for agent 2272

No memory allocated

Memory for agent 3848

No memory allocated

Memory for agent 2192

No memory allocated

Memory for agent 3472

Other Memory is of size 32768 bytes
Application Heap is of size 147456 bytes
Application Control Heap is of size 16384 bytes
Total: 196608 bytes

Memory for agent 3368

No memory allocated

Memory for agent 2828

No memory allocated

Memory for agent 636

No memory allocated

Memory for agent 3748

No memory allocated

Memory for agent 3352

No memory allocated

Memory for agent 2696

No memory allocated

Memory for agent 1764

Other Memory is of size 32768 bytes
Application Heap is of size 704512 bytes
Application Control Heap is of size 16384 bytes
Total: 753664 bytes

Memory for agent 2464

No memory allocated

Memory for agent 3756

No memory allocated

Memory for agent 2744

No memory allocated

Memory for agent 2288

No memory allocated

Memory for agent 3552

No memory allocated

Memory for agent 2932

Application Heap is of size 212992 bytes
Application Control Heap is of size 16384 bytes
Total: 229376 bytes

Memory for agent 544

Application Heap is of size 212992 bytes
Application Control Heap is of size 16384 bytes
Total: 229376 bytes

Memory for agent 2060

No memory allocated

Memory for agent 2088

No memory allocated

Memory for agent 1828

Other Memory is of size 32768 bytes
Application Heap is of size 86130688 bytes
Application Control Heap is of size 16384 bytes
Total: 86179840 bytes
D:\Program Files\IBM\SQLLIB\BIN>


--
Pierre Saint-Jacques - Reply to: sesconsjunk at attglobaljunk dot com
Reconstruct address: Remove the two junk and replace at and dot by
their symbols.
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.

Nov 12 '05 #11

P: n/a
Pierre Saint-Jacques <se*****@attglobal.net> wrote in message news:<40************@attglobal.net>...
Xixi, I believe the buffer pool heaps are defined by the system only.
They are there in case something goes wrong with your bp definitions and
the db cannot be activated.
DB2 will then use these four heaps (one heap per page size 4k,8k,16k,32k).
You do not have to worry about them as to their use and spaceutilization.
HTH, Pierre.

xixi wrote:
hi, please ignore my recent post email, here is the right memory
tracking, i have three database under same instance, but we only focus
one, is that even i don't have access to the other two databases,
they also take up memory? i only only three bufferpools under each
database, ibmdefaultbf and the other two i created, so why there are
six bufferpool heap ? what is the difference between bufferpool heap
and bufferpool size? thanks

D:\Program Files\IBM\SQLLIB\BIN>db2 connect to njipd

Database Connection Information

Database server = DB2/NT64 8.1.3
SQL authorization ID = ADMIN
Local database alias = NJIPD
D:\Program Files\IBM\SQLLIB\BIN>db2mtrk -i -p -v
Tracking Memory on: 2004/04/30 at 16:04:55

Memory for instance

Backup/Restore/Util Heap is of size 16384 bytes
Package Cache is of size 442368 bytes
Catalog Cache Heap is of size 425984 bytes
Buffer Pool Heap is of size 1196032 bytes
Buffer Pool Heap is of size 8355840 bytes
Buffer Pool Heap is of size 427737088 bytes
Buffer Pool Heap is of size 655360 bytes
Buffer Pool Heap is of size 393216 bytes
Buffer Pool Heap is of size 262144 bytes
Buffer Pool Heap is of size 196608 bytes
Lock Manager Heap is of size 4243456 bytes
Database Heap is of size 1736704 bytes
Backup/Restore/Util Heap is of size 16384 bytes
Package Cache is of size 442368 bytes
Catalog Cache Heap is of size 425984 bytes
Buffer Pool Heap is of size 2473984 bytes
Buffer Pool Heap is of size 23445504 bytes
Buffer Pool Heap is of size 655360 bytes
Buffer Pool Heap is of size 393216 bytes
Buffer Pool Heap is of size 262144 bytes
Buffer Pool Heap is of size 196608 bytes
Lock Manager Heap is of size 4243456 bytes
Database Heap is of size 1753088 bytes
Backup/Restore/Util Heap is of size 16384 bytes
Package Cache is of size 6635520 bytes
Catalog Cache Heap is of size 4259840 bytes
Buffer Pool Heap is of size 1196032 bytes
Buffer Pool Heap is of size 8355840 bytes
Buffer Pool Heap is of size 1069350912 bytes
Buffer Pool Heap is of size 655360 bytes
Buffer Pool Heap is of size 393216 bytes
Buffer Pool Heap is of size 262144 bytes
Buffer Pool Heap is of size 196608 bytes
Lock Manager Heap is of size 4243456 bytes
Database Heap is of size 4571136 bytes
Database Monitor Heap is of size 344064 bytes
Other Memory is of size 13451264 bytes
Total: 1593901056 bytes

Memory for agent 3588

No memory allocated

Memory for agent 3228

Other Memory is of size 32768 bytes
Application Heap is of size 65536 bytes
Application Control Heap is of size 16384 bytes
Total: 114688 bytes

Memory for agent 3560

No memory allocated

Memory for agent 2428

No memory allocated

Memory for agent 3764

Other Memory is of size 32768 bytes
Application Heap is of size 65536 bytes
Application Control Heap is of size 16384 bytes
Total: 114688 bytes

Memory for agent 2608

Other Memory is of size 32768 bytes
Application Heap is of size 212992 bytes
Application Control Heap is of size 16384 bytes
Total: 262144 bytes

Memory for agent 488

Other Memory is of size 32768 bytes
Application Heap is of size 212992 bytes
Application Control Heap is of size 16384 bytes
Total: 262144 bytes

Memory for agent 3656

No memory allocated

Memory for agent 2820

No memory allocated

Memory for agent 3132

No memory allocated

Memory for agent 3064

No memory allocated

Memory for agent 3428

No memory allocated

Memory for agent 2952

No memory allocated

Memory for agent 492

No memory allocated

Memory for agent 1904

No memory allocated

Memory for agent 3996

No memory allocated

Memory for agent 3520

No memory allocated

Memory for agent 3604

No memory allocated

Memory for agent 4092

No memory allocated

Memory for agent 2272

No memory allocated

Memory for agent 3848

No memory allocated

Memory for agent 2192

No memory allocated

Memory for agent 3472

Other Memory is of size 32768 bytes
Application Heap is of size 147456 bytes
Application Control Heap is of size 16384 bytes
Total: 196608 bytes

Memory for agent 3368

No memory allocated

Memory for agent 2828

No memory allocated

Memory for agent 636

No memory allocated

Memory for agent 3748

No memory allocated

Memory for agent 3352

No memory allocated

Memory for agent 2696

No memory allocated

Memory for agent 1764

Other Memory is of size 32768 bytes
Application Heap is of size 704512 bytes
Application Control Heap is of size 16384 bytes
Total: 753664 bytes

Memory for agent 2464

No memory allocated

Memory for agent 3756

No memory allocated

Memory for agent 2744

No memory allocated

Memory for agent 2288

No memory allocated

Memory for agent 3552

No memory allocated

Memory for agent 2932

Application Heap is of size 212992 bytes
Application Control Heap is of size 16384 bytes
Total: 229376 bytes

Memory for agent 544

Application Heap is of size 212992 bytes
Application Control Heap is of size 16384 bytes
Total: 229376 bytes

Memory for agent 2060

No memory allocated

Memory for agent 2088

No memory allocated

Memory for agent 1828

Other Memory is of size 32768 bytes
Application Heap is of size 86130688 bytes
Application Control Heap is of size 16384 bytes
Total: 86179840 bytes
D:\Program Files\IBM\SQLLIB\BIN>

DB2 creates one bufferpool for each page size (4,8,16, 32 KB) for
internal use. That's why there are seven (not six) bufferpool heaps in
the output - default BP, two which you have created and rest 4 for
four different page size.
Nov 12 '05 #12

P: n/a
Pierre Saint-Jacques <se*****@attglobal.net> wrote in message news:<40************@attglobal.net>...
Xixi, I believe the buffer pool heaps are defined by the system only.
They are there in case something goes wrong with your bp definitions and
the db cannot be activated.
DB2 will then use these four heaps (one heap per page size 4k,8k,16k,32k).
You do not have to worry about them as to their use and spaceutilization.
HTH, Pierre.

xixi wrote:
hi, please ignore my recent post email, here is the right memory
tracking, i have three database under same instance, but we only focus
one, is that even i don't have access to the other two databases,
they also take up memory? i only only three bufferpools under each
database, ibmdefaultbf and the other two i created, so why there are
six bufferpool heap ? what is the difference between bufferpool heap
and bufferpool size? thanks

D:\Program Files\IBM\SQLLIB\BIN>db2 connect to njipd

Database Connection Information

Database server = DB2/NT64 8.1.3
SQL authorization ID = ADMIN
Local database alias = NJIPD
D:\Program Files\IBM\SQLLIB\BIN>db2mtrk -i -p -v
Tracking Memory on: 2004/04/30 at 16:04:55

Memory for instance

Backup/Restore/Util Heap is of size 16384 bytes
Package Cache is of size 442368 bytes
Catalog Cache Heap is of size 425984 bytes
Buffer Pool Heap is of size 1196032 bytes
Buffer Pool Heap is of size 8355840 bytes
Buffer Pool Heap is of size 427737088 bytes
Buffer Pool Heap is of size 655360 bytes
Buffer Pool Heap is of size 393216 bytes
Buffer Pool Heap is of size 262144 bytes
Buffer Pool Heap is of size 196608 bytes
Lock Manager Heap is of size 4243456 bytes
Database Heap is of size 1736704 bytes
Backup/Restore/Util Heap is of size 16384 bytes
Package Cache is of size 442368 bytes
Catalog Cache Heap is of size 425984 bytes
Buffer Pool Heap is of size 2473984 bytes
Buffer Pool Heap is of size 23445504 bytes
Buffer Pool Heap is of size 655360 bytes
Buffer Pool Heap is of size 393216 bytes
Buffer Pool Heap is of size 262144 bytes
Buffer Pool Heap is of size 196608 bytes
Lock Manager Heap is of size 4243456 bytes
Database Heap is of size 1753088 bytes
Backup/Restore/Util Heap is of size 16384 bytes
Package Cache is of size 6635520 bytes
Catalog Cache Heap is of size 4259840 bytes
Buffer Pool Heap is of size 1196032 bytes
Buffer Pool Heap is of size 8355840 bytes
Buffer Pool Heap is of size 1069350912 bytes
Buffer Pool Heap is of size 655360 bytes
Buffer Pool Heap is of size 393216 bytes
Buffer Pool Heap is of size 262144 bytes
Buffer Pool Heap is of size 196608 bytes
Lock Manager Heap is of size 4243456 bytes
Database Heap is of size 4571136 bytes
Database Monitor Heap is of size 344064 bytes
Other Memory is of size 13451264 bytes
Total: 1593901056 bytes

Memory for agent 3588

No memory allocated

Memory for agent 3228

Other Memory is of size 32768 bytes
Application Heap is of size 65536 bytes
Application Control Heap is of size 16384 bytes
Total: 114688 bytes

Memory for agent 3560

No memory allocated

Memory for agent 2428

No memory allocated

Memory for agent 3764

Other Memory is of size 32768 bytes
Application Heap is of size 65536 bytes
Application Control Heap is of size 16384 bytes
Total: 114688 bytes

Memory for agent 2608

Other Memory is of size 32768 bytes
Application Heap is of size 212992 bytes
Application Control Heap is of size 16384 bytes
Total: 262144 bytes

Memory for agent 488

Other Memory is of size 32768 bytes
Application Heap is of size 212992 bytes
Application Control Heap is of size 16384 bytes
Total: 262144 bytes

Memory for agent 3656

No memory allocated

Memory for agent 2820

No memory allocated

Memory for agent 3132

No memory allocated

Memory for agent 3064

No memory allocated

Memory for agent 3428

No memory allocated

Memory for agent 2952

No memory allocated

Memory for agent 492

No memory allocated

Memory for agent 1904

No memory allocated

Memory for agent 3996

No memory allocated

Memory for agent 3520

No memory allocated

Memory for agent 3604

No memory allocated

Memory for agent 4092

No memory allocated

Memory for agent 2272

No memory allocated

Memory for agent 3848

No memory allocated

Memory for agent 2192

No memory allocated

Memory for agent 3472

Other Memory is of size 32768 bytes
Application Heap is of size 147456 bytes
Application Control Heap is of size 16384 bytes
Total: 196608 bytes

Memory for agent 3368

No memory allocated

Memory for agent 2828

No memory allocated

Memory for agent 636

No memory allocated

Memory for agent 3748

No memory allocated

Memory for agent 3352

No memory allocated

Memory for agent 2696

No memory allocated

Memory for agent 1764

Other Memory is of size 32768 bytes
Application Heap is of size 704512 bytes
Application Control Heap is of size 16384 bytes
Total: 753664 bytes

Memory for agent 2464

No memory allocated

Memory for agent 3756

No memory allocated

Memory for agent 2744

No memory allocated

Memory for agent 2288

No memory allocated

Memory for agent 3552

No memory allocated

Memory for agent 2932

Application Heap is of size 212992 bytes
Application Control Heap is of size 16384 bytes
Total: 229376 bytes

Memory for agent 544

Application Heap is of size 212992 bytes
Application Control Heap is of size 16384 bytes
Total: 229376 bytes

Memory for agent 2060

No memory allocated

Memory for agent 2088

No memory allocated

Memory for agent 1828

Other Memory is of size 32768 bytes
Application Heap is of size 86130688 bytes
Application Control Heap is of size 16384 bytes
Total: 86179840 bytes
D:\Program Files\IBM\SQLLIB\BIN>

DB2 creates one bufferpool for each page size (4,8,16, 32 KB) for
internal use. That's why there are seven (not six) bufferpool heaps in
the output - default BP, two which you have created and rest 4 for
four different page size.
Nov 12 '05 #13

P: n/a
since i don't have answer on the memory used , i would like to ask
again, under dB2 instance, i have three database, but only one is
being used by application, so does the other two also takes memory
even no active connection? thanks
Nov 12 '05 #14

P: n/a
since i don't have answer on the memory used , i would like to ask
again, under dB2 instance, i have three database, but only one is
being used by application, so does the other two also takes memory
even no active connection? thanks
Nov 12 '05 #15

P: n/a
My previous e-mail:

DB2 creates one bufferpool for each page size (4,8,16, 32 KB) for
internal use. That's why there are seven (not six) bufferpool heaps in
the output - default BP, two which you have created and rest 4 for
four different page size.

=======

For database level memory question - Yes, it will take memory if the
database is activated explicitly.

da****@yahoo.com (xixi) wrote in message news:<c0*************************@posting.google.c om>...
since i don't have answer on the memory used , i would like to ask
again, under dB2 instance, i have three database, but only one is
being used by application, so does the other two also takes memory
even no active connection? thanks

Nov 12 '05 #16

P: n/a
My previous e-mail:

DB2 creates one bufferpool for each page size (4,8,16, 32 KB) for
internal use. That's why there are seven (not six) bufferpool heaps in
the output - default BP, two which you have created and rest 4 for
four different page size.

=======

For database level memory question - Yes, it will take memory if the
database is activated explicitly.

da****@yahoo.com (xixi) wrote in message news:<c0*************************@posting.google.c om>...
since i don't have answer on the memory used , i would like to ask
again, under dB2 instance, i have three database, but only one is
being used by application, so does the other two also takes memory
even no active connection? thanks

Nov 12 '05 #17

P: n/a
No they do not.
A db only uses and allocates memory if either of the following are true.
A connection exists on the db
A db2 activate db <dbname> command has been issued.

Understand that if any of these are true but no work is being done by
ANY connection, the OS can reclaim any allocated memory pages not busy
and allocate them to any application process that would need memory pages.

HTH, Pierre.

xixi wrote:
since i don't have answer on the memory used , i would like to ask
again, under dB2 instance, i have three database, but only one is
being used by application, so does the other two also takes memory
even no active connection? thanks


--
Pierre Saint-Jacques - Reply to: sesconsjunk at attglobaljunk dot com
Reconstruct address: Remove the two junk and replace at and dot by
their symbols.
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.

Nov 12 '05 #18

P: n/a
No they do not.
A db only uses and allocates memory if either of the following are true.
A connection exists on the db
A db2 activate db <dbname> command has been issued.

Understand that if any of these are true but no work is being done by
ANY connection, the OS can reclaim any allocated memory pages not busy
and allocate them to any application process that would need memory pages.

HTH, Pierre.

xixi wrote:
since i don't have answer on the memory used , i would like to ask
again, under dB2 instance, i have three database, but only one is
being used by application, so does the other two also takes memory
even no active connection? thanks


--
Pierre Saint-Jacques - Reply to: sesconsjunk at attglobaljunk dot com
Reconstruct address: Remove the two junk and replace at and dot by
their symbols.
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.

Nov 12 '05 #19

P: n/a
hi, when i do db2mtrk, i found there is two set of data under "memory
for instance", which is backup/restore/util heap, package cache,
catalog cache heap, bufferpool heap, lock manger heap, database heap,
makes me think that two databases running together. since db2mtrk
can't get remote server info, what else command i can from pc to
remote server? thanks
Nov 12 '05 #20

P: n/a
our database is 64 bit DB2 on windows, i have been dropped the
bufferpool size to 200000 pages (machine physical memory is 4G), but
still db2sysc.exe easily takes 2g mem and 4g vm of the machine,
anybody get suggestion?
Nov 12 '05 #21

P: n/a
Xixi, what command exactly did you issue.
db2mtrk -i -m
Gives you maximum values set for the parms. you specify. This does not
mean what is used but what has been set.
All the parms you mention in your note are demand parms. This means you
set the max. value thay can claim but they claim only what is needed
when it is needed.
It does not mean, one, two, three, ... db's are running.

Since db2mtrk runs locally on the server, you'll have to use TelNet or
whatever other product that allows you to run a local session on a
server from a remote terminal. This is not a DB2 function.
HTH, Pierre.

xixi wrote:
hi, when i do db2mtrk, i found there is two set of data under "memory
for instance", which is backup/restore/util heap, package cache,
catalog cache heap, bufferpool heap, lock manger heap, database heap,
makes me think that two databases running together. since db2mtrk
can't get remote server info, what else command i can from pc to
remote server? thanks


--
Pierre Saint-Jacques - Reply to: sesconsjunk at attglobaljunk dot com
Reconstruct address: Remove the two junk and replace at and dot by
their symbols.
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.

Nov 12 '05 #22

P: n/a
i am doing db2mtrk -i -p -v to get the current value of memory. And
two set of data getting under memory of instance which i posted cause
me question because our application only activate connect with one db.
Nov 12 '05 #23

This discussion thread is closed

Replies have been disabled for this discussion.