473,472 Members | 2,155 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

DB2 Memory usage

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 individually.
If you have any home grown tools to calculate total memory,
please share with us.
Thank You.
Ramesh Vasudevan.

Nov 12 '05 #1
5 2143
rameshv wrote:
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 individually.
If you have any home grown tools to calculate total memory,
please share with us.
Thank You.
Ramesh Vasudevan.

Uhm..wouldn't the memory visualizer do that? I don't recall whether it's
V8.1 or V8.2

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #2
In v8 db2 snapshot for dbm/db/app will also report memory heap usage if
you want raw numbers...

Serge Rielau wrote:
rameshv wrote:
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 individually.
If you have any home grown tools to calculate total memory,
please share with us.
Thank You.
Ramesh Vasudevan.

Uhm..wouldn't the memory visualizer do that? I don't recall whether it's
V8.1 or V8.2

Cheers
Serge

Nov 12 '05 #3
what about db2mtrk

regards
Joachim

"rameshv" <ra***********@yahoo.com> schrieb im Newsbeitrag
news:11**********************@l41g2000cwc.googlegr oups.com...
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 individually.
If you have any home grown tools to calculate total memory,
please share with us.
Thank You.
Ramesh Vasudevan.

Nov 12 '05 #4
i have heard/read about db2mtrk but i can not find it on my system
i am using db2 v8.2 (fixpack 8) on AIX

please tell me where is this located? i get error "db2mtrk file not found"
regards
krishna

"Joachim Müller" <jo*****@douglas-informatik.de> wrote in message
news:d0**********@news.dtag.de...
what about db2mtrk

regards
Joachim

"rameshv" <ra***********@yahoo.com> schrieb im Newsbeitrag
news:11**********************@l41g2000cwc.googlegr oups.com...
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 individually.
If you have any home grown tools to calculate total memory,
please share with us.
Thank You.
Ramesh Vasudevan.


Nov 12 '05 #5
i think it should be in the instance's sqllib/bin directory. try giving
the absolute path of the db2mtrk command/utility.

regards,
dotyet

Nov 12 '05 #6

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

Similar topics

8
by: rbt | last post by:
Would a Python process consume more memory on a PC with lots of memory? For example, say I have the same Python script running on two WinXP computers that both have Python 2.4.0. One computer has...
5
by: Justice | last post by:
Currently I'm doing some experimenting with the XMLHTTP object in Javascript. Now, the XMLHttp object is asynchronous (at least in this case), and the following code causes a significant memory...
2
by: tomvr | last post by:
Hello I have noticed some 'weird' memory usage in a vb.net windows app The situation is as follows I have an app (heavy on images) with 2 forms (actually there are more forms and on starting...
6
by: Tom | last post by:
We have a VERY simple .NET C# Form Application, that has about a 23MB Memory Footprint. It starts a window runs a process and does a regular expression. I have done a GC.Collect to make sure that,...
2
by: Jarvis | last post by:
I've made a testing program to test the memory usage of some Data Forms. I create a MDI parent form with one single MDI child form, which is a Data Form generated by .NET Data Form Wizard. To...
3
by: Ian Taite | last post by:
Hello, I'm exploring why one of my C# .NET apps has "high" memory usage, and whether I can reduce the memory usage. I have an app that wakes up and processes text files into a database...
20
by: Philip Carnstam | last post by:
How come .Net applications use so much memory? Every application I compile uses at least 10 MB of memory, even the ones consisting of only a form and nothing else. If I minimize them though the...
13
by: Ilias Lazaridis | last post by:
How to detect memory leaks of python programms, which run in an environment like this: * Suse Linux 9.3 * Apache * mod_python The problem occoured after some updates on the infrastructure....
1
by: yzghan | last post by:
Hi all, I feel that my python script is leaking memory. And this is a test I have: log.write(" " + "test() ... memory usage: " + " ".join(repr(i/(1024*1024)) for i in getMemInfo()) + "\n") m...
1
by: Jean-Paul Calderone | last post by:
On Tue, 22 Apr 2008 14:54:37 -0700 (PDT), yzghan@gmail.com wrote: The test doesn't demonstrate any leaks. It does demonstrate that memory usage can remain at or near peak memory usage even after...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

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.