473,242 Members | 1,493 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,242 software developers and data experts.

db2mtrk

nek
Would someone care to comment the following results of DB2MTRK execution, thanks.

The platform is W2K SP with DB2 V8.1, SP2.

We have this result when running db2mtrk -i

Appctlh utilh pckcacheh catcacheh bph bph bph
96.0K 16.0K 3.4M 320.0K 1.0G 592.0K 336.0K

bph bph lockh dbh appctlh appctlh appctlh
208.0K 144.0K 39.7M 7.9M 16.0K 16.0K 16.0K

Appctlh utilh pckcacheh catcacheh bph bph bph
624.0K 16.0K 320.4K 160.0K 7.9M 1.1M 592.0K

bph bph bph lockh dbh Monh other
336.0K 208.0K 144.0K 256.0K 1.1M 336.0K 89.6M

fcmbp
4.3M

From task manager, db2syscs shows it uses up (approx.) 1.2 GB of memory.
After db2stop/start:

db2mtrk shows:

Monh other fcmbp
16.0K 7.4M 4.3M

And db2syscs uses about 23,980K of memory.

There are only THREE connections from TOOLSDB before and after running db2mtrk.

Why is the discrepancy of memory usage so HUGE after db2stop/start?
Nov 12 '05 #1
2 4796
nek
Yeah, -v gives additional 'total' of all memories used.

So for the case of:
Monh other fcmbp
16.0K 7.4M 4.3M

'db2mtrk -i -v' returns all the above in bytes plus the total
(16K+7.4M +4.3m) in bytes.

What baffles me is that given the same condition (3 connections to
TOOLSDB), why does db2mtrk show a significantly different 'map' after
db2 instance is restarted? Likewise for memory usage by db2syscs.exe
in task mgr?

Thanks..
"Fan Ruo Xin" <fa*****@sbcglobal.net> wrote in message news:<08****************@newssvr26.news.prodigy.co m>...
(1). Use db2mtrk -i -v will give you more words, such as applctlh will be
application control heap ...
When using option -v, which also show you the total memory for the
instance part, db part, agent part ...
(2). On Windows platform, db2 use multiple threads. That is why you found
db2sysc almost hold up all the memory.
(3). db2stop/db2start did not startup the database, only the memory used by
db2 server part.

"nek" <ne*****@hotmail.com> wrote in message
news:1a**************************@posting.google.c om...
Would someone care to comment the following results of DB2MTRK execution,

thanks.

The platform is W2K SP with DB2 V8.1, SP2.

We have this result when running db2mtrk -i

Appctlh utilh pckcacheh catcacheh bph bph bph
96.0K 16.0K 3.4M 320.0K 1.0G 592.0K 336.0K

bph bph lockh dbh appctlh appctlh appctlh
208.0K 144.0K 39.7M 7.9M 16.0K 16.0K 16.0K

Appctlh utilh pckcacheh catcacheh bph bph bph
624.0K 16.0K 320.4K 160.0K 7.9M 1.1M 592.0K

bph bph bph lockh dbh Monh other
336.0K 208.0K 144.0K 256.0K 1.1M 336.0K 89.6M

fcmbp
4.3M

From task manager, db2syscs shows it uses up (approx.) 1.2 GB of memory.
After db2stop/start:

db2mtrk shows:

Monh other fcmbp
16.0K 7.4M 4.3M

And db2syscs uses about 23,980K of memory.

There are only THREE connections from TOOLSDB before and after running

db2mtrk.

Why is the discrepancy of memory usage so HUGE after db2stop/start?

Nov 12 '05 #2

"nek" <ne*****@hotmail.com> wrote in message
news:1a**************************@posting.google.c om...
Yeah, -v gives additional 'total' of all memories used.

So for the case of:
Monh other fcmbp
16.0K 7.4M 4.3M

'db2mtrk -i -v' returns all the above in bytes plus the total
(16K+7.4M +4.3m) in bytes.

What baffles me is that given the same condition (3 connections to
TOOLSDB), why does db2mtrk show a significantly different 'map' after
db2 instance is restarted? Likewise for memory usage by db2syscs.exe
in task mgr?
db2stop/db2start - start the instance
build the connection to the db - start the instance and the database

Thanks..
"Fan Ruo Xin" <fa*****@sbcglobal.net> wrote in message

news:<08****************@newssvr26.news.prodigy.co m>...
(1). Use db2mtrk -i -v will give you more words, such as applctlh will be application control heap ...
When using option -v, which also show you the total memory for the instance part, db part, agent part ...
(2). On Windows platform, db2 use multiple threads. That is why you found db2sysc almost hold up all the memory.
(3). db2stop/db2start did not startup the database, only the memory used by db2 server part.

"nek" <ne*****@hotmail.com> wrote in message
news:1a**************************@posting.google.c om...
Would someone care to comment the following results of DB2MTRK execution,
thanks.

The platform is W2K SP with DB2 V8.1, SP2.

We have this result when running db2mtrk -i

Appctlh utilh pckcacheh catcacheh bph bph bph
96.0K 16.0K 3.4M 320.0K 1.0G 592.0K 336.0K

bph bph lockh dbh appctlh appctlh appctlh
208.0K 144.0K 39.7M 7.9M 16.0K 16.0K 16.0K

Appctlh utilh pckcacheh catcacheh bph bph bph
624.0K 16.0K 320.4K 160.0K 7.9M 1.1M 592.0K

bph bph bph lockh dbh Monh other
336.0K 208.0K 144.0K 256.0K 1.1M 336.0K 89.6M

fcmbp
4.3M

From task manager, db2syscs shows it uses up (approx.) 1.2 GB of

memory.

After db2stop/start:

db2mtrk shows:

Monh other fcmbp
16.0K 7.4M 4.3M

And db2syscs uses about 23,980K of memory.

There are only THREE connections from TOOLSDB before and after running

db2mtrk.

Why is the discrepancy of memory usage so HUGE after db2stop/start?

Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: Jean-Marc Blaise | last post by:
Hi, I'm on Linux Intel, V8.1 / FP4. I have an instance crash. The test case: db2set DB2_FMP_COMM_HEAPSZ = 0 db2stop db2start db2mtrk -i -d -p -v ==> Instance is crashed.
22
by: xixi | last post by:
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...
5
by: rameshv | last post by:
Would like to know how to calculate total memory used by DB2 on a given system/instance. Always I was trying to go through DBM and individual DB configuration parameters and calculate...
1
by: Raj | last post by:
We are on db2 udb v8.2 64 bit,partitioned (5 nodes) on AIX 5.2 ( intra parllelism is enabled). I have a question, i am trying to find the memory usage on my production machine. what is the best...
0
by: cbielins | last post by:
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: ...
2
by: truthinlife | last post by:
I am running the following commands on an AIX 5.2 server, using db2 udb v8.2.2. my ipcs -mb command gives me the following: IPC status from /dev/mem as of Mon Nov 20 12:47:25 EST 2006 T ID...
0
by: db2admin | last post by:
While running following command CREATE INDEX ABC.CDE_X1 ON ABC.CDE (C1 ASC, C2 ASC, C3 ASC, C4 ASC ) allow reverse scans collect detailed statistics DB21034E The command was processed as an SQL...
6
by: dunleav1 | last post by:
I have a db2 9 FP3a installation with one instance and one database installed. I have 4G of physical RAM and I have enabled the /3G switch in boot.ini. I am using STTM. If I run db2mtrk the...
3
by: Lennart | last post by:
A while back I raised a discussion ( http://tinyurl.com/4h3qg7 ) regarding SQL1084C Shared memory segments cannot be allocated. We still have this problem, so I thought I should bump the thread. ...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.