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?
22  3438 
"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.
"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.
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?
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?
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
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
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>
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>
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.
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.
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.
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.
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
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
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
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
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.
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.
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
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?
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.
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.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: John |
last post by:
Hi all:
When I run my code, I find that the memory that the code uses keeps
increasing.
I have a PC with 2G RAM running Debian linux. The code consumes 1.5G
memory by the time it finishes...
|
by: Fred Zwarts |
last post by:
Hello,
I am trying to debug some complex debug code.
In order to track the use of dynamically allocated memory,
I replaced the standard global new and delete operators.
(Not for changing the...
|
by: Jonas |
last post by:
Hi,
I'm 99 % sure that Standard C guarantees to do a memory move inside
realloc() in case the new, returned memory block (address) is different than
the original one. Can any C expert confirm...
|
by: vikram |
last post by:
i have series of questions
1.How a c program is loaded in memory
i mean the whats is the structure that the code segment?? data segment??
2.When you say
const int *p;
where is p...
|
by: jimjim |
last post by:
Hello,
This is a simple question for you all, I guess .
int main(){
double *g= new double;
*g = 9;
delete g;
cout<< sizeof(g)<<" "<<sizeof(double)<<" "<<sizeof(*g)<<" "<<*g<<" "<<endl;
*g =...
|
by: Ramasubbu Ramasubramanian XR (AS/EAB) |
last post by:
What is memory leakage, could any one explain with sample code
|
by: Zeng |
last post by:
I finally narrowed down my code to this situation, quite a few (not all) of
my CMyClass objects got hold up after each run of this function via the
simple webpage that shows NumberEd editbox. My...
|
by: Ashish |
last post by:
hi all,
I have been doing some performance testing of a asp_net website, to be
hosted on a shared server ..
as far as i understand every page when accessed first time is compiled
and loaded in...
|
by: toton |
last post by:
Hi,
I have a STL vector of of characters and the character class has a
Boost array of points.
The things are vector<Characterchars; and
class Character{
private:
array<Point,Npoints;
};
Now...
|
by: Hemal |
last post by:
Hi All,
I need to know the memory required by a c program. Is there any
tool/utility which can give me the memory usage in terms of DATA
segment, TEXT segment, BSS segment etc.
I am working...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
| |
