Unix Technical Forum

Utilizing db2mtrk..

This is a discussion on Utilizing db2mtrk.. within the DB2 forums, part of the Database Server Software category; --> We are about to 'stress test' our DB2 environment. I've played with db2mtrk off and on, trying to figure ...


Go Back   Unix Technical Forum > Database Server Software > DB2

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 07:55 AM
cbielins@gmail.com
 
Posts: n/a
Default 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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 06:01 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com