469,649 Members | 1,676 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,649 developers. It's quick & easy.

Utilizing db2mtrk..

We are about to 'stress test' our DB2 environment. I've played with
db2mtrk off and on, trying to figure out how it's mapping the memory
to its components.

If I have the following output:

Memory for instance

fcmbp monh other
16.7M 176.0K 5.7M

Memory for database: <DB2_NAME>

utilh pckcacheh catcacheh bph bph bph bph
32.0K 1.7M 896.0K 4.2M 31.5M 314.5M 31.5M

bph bph bph bph bph shsorth lockh
4.2M 640.0K 384.0K 256.0K 192.0K 160.0K 480.0K

dbh other appctlh appctlh appctlh appctlh appctlh
12.1M 32.0K 16.0K 16.0K 16.0K 16.0K 32.0K

appctlh appctlh appctlh appctlh appctlh appctlh appctlh
32.0K 32.0K 16.0K 32.0K 32.0K 32.0K 32.0K

appctlh appctlh appctlh appctlh appctlh appctlh appctlh
32.0K 32.0K 48.0K 32.0K 16.0K 32.0K 16.0K

appctlh appctlh appctlh appctlh appctlh appctlh appctlh
32.0K 32.0K 144.0K 32.0K 16.0K 32.0K 32.0K

appctlh appctlh appctlh appctlh appctlh appctlh appctlh
32.0K 32.0K 32.0K 32.0K 16.0K 32.0K 32.0K

appctlh appctlh appctlh appctlh appctlh appctlh appctlh
32.0K 32.0K 32.0K 32.0K 32.0K 32.0K 16.0K

appctlh appctlh appctlh agsh
32.0K 32.0K 80.0K 94.0M

I can see that there is memory allocated for bufferpools, app ctl
heaps, locks, etc etc.

This snapshot was taken with 2 active connections both crunching a
query. In our stress test, we plan on having upwards of around 40
connections at once 'going to town',

My question is (finally), with that many connections, and with the
output above, how will I be able to see what's going on? Will I be
able to tell if there really is a memory leak? How will I be able to
deduce this information?

Thanks, Chris

Apr 28 '06 #1
0 1119

This discussion thread is closed

Replies have been disabled for this discussion.

By using this site, you agree to our Privacy Policy and Terms of Use.