For once, I have a customer that is more concerned with reducing the
memory usage than with increasing performance - a new direction in
tuning for me. I'm looking at db2 agent processes on the system - db2
7.2 fp 11 on RH Linux - no parallelism (neither inter or intra
partition). There are generally about 14 connections and therefore
about 14 db2agents. OS analysis shows that each agent is using in the
range of 260 - 270 MB of memory. Looking at the configuration and the
parameters which affect the maximum amount of memory used by a
db2agent, I come up with about 20 MB as the upper limit:
applheapsz = 2048
sortheap = 256
stmtheap = 2048
aslheapsz = 1000
DRDA heap, UDF shared memory, and statistics heap size are irrelevant
because none of them are used on this system. (no, we don't do
runstats, but I'm trying to talk them into it ... another story)
What am I missing in my calculations here? why are the agents using
this much memory?
Thanks,
Ember Crooks
2  3601 
Ember wrote: For once, I have a customer that is more concerned with reducing the
memory usage than with increasing performance - a new direction in
tuning for me. I'm looking at db2 agent processes on the system - db2
7.2 fp 11 on RH Linux - no parallelism (neither inter or intra
partition). There are generally about 14 connections and therefore
about 14 db2agents. OS analysis shows that each agent is using in the
range of 260 - 270 MB of memory. Looking at the configuration and the
parameters which affect the maximum amount of memory used by a
db2agent, I come up with about 20 MB as the upper limit:
applheapsz = 2048
sortheap = 256
stmtheap = 2048
aslheapsz = 1000
DRDA heap, UDF shared memory, and statistics heap size are irrelevant
because none of them are used on this system. (no, we don't do
runstats, but I'm trying to talk them into it ... another story)
What am I missing in my calculations here? why are the agents using
this much memory?
You didn't say how you're calculating the number (260-270 Mb), but
generally the numbers you get from 'ps' show the total memory associated
with the process, including shared memory segments that the agents have
attached to (i.e. bufferpools).
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
"Ian" <ia*****@mobile audio.com> wrote in message
news:40******** @corp.newsgroup s.com... Ember wrote: For once, I have a customer that is more concerned with reducing the
memory usage than with increasing performance - a new direction in
tuning for me. I'm looking at db2 agent processes on the system - db2
7.2 fp 11 on RH Linux - no parallelism (neither inter or intra
partition). There are generally about 14 connections and therefore
about 14 db2agents. OS analysis shows that each agent is using in the
range of 260 - 270 MB of memory. Looking at the configuration and the
parameters which affect the maximum amount of memory used by a
db2agent, I come up with about 20 MB as the upper limit:
applheapsz = 2048
sortheap = 256
stmtheap = 2048
aslheapsz = 1000
DRDA heap, UDF shared memory, and statistics heap size are irrelevant
because none of them are used on this system. (no, we don't do
runstats, but I'm trying to talk them into it ... another story)
What am I missing in my calculations here? why are the agents using
this much memory?
You didn't say how you're calculating the number (260-270 Mb), but
generally the numbers you get from 'ps' show the total memory associated
with the process, including shared memory segments that the agents have
attached to (i.e. bufferpools).
I agree with Ian. You must add part of the shared memory into your total
number. The snapshot output from version8.1 will give us more ideas about
the db2 memory/heap usage than version7.
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =----- This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
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 loss even though I seem to be
allocaitng everything; help would be *vastly* appreciated. What am I doing
wrong here? I thought I was doing everything correctly (setting things to
null, for example) but none of the memory seems to get replaced. ...
|
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 the app I load some things into memory for global use of the app but I'll use only 2 starting forms to explain the situation)
situation 1
start app with form 1 (72mb memory usage), show form 2 and hide form 1 (89 mb memory usage
|
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, no memory is
lying around. GC reports only 84k of allocations. Starting 5-10 of
this apps is going to start taking a considerable amount of memory. Is
there a way to reduce this?
Tom
|
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 test the stuff, I keep to open that child data form for about 10 times.
the memory usage shown in GC and task manager both increase.
Then I close all those forms. and perform GC collect. The memory usage shown
in GC falls, however, the memory...
|
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
periodically. What happens, is that the app reads the contents of a
text file line by line into an ArrayList. Each element of the ArrayList
is a string representing a record from the file. The ArrayList is then
processed, and the arraylist goes out of...
| | |
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 memory usage drops to a couple
hundred KB. Why?
Is there anything I should to to prevent this? I have compiled in release
and deactivated all forms of debugging, I think!
Thanks,
Philip
|
by: Joe Ross |
last post by:
(Apologies in advance if there is a better forum for asking advice on this
topic).
Our ASP.NET application occasionally starts spitting out OutOfMemory
exceptions. When this happens, the memory usage for that IIS worker process
is over 1GB. I understand in this sceneario that the virtual memory pool
can become fragmented and produce this type of exception.
This time, however, I was able to do an ADPlus dump while it was in this...
|
by: Zach |
last post by:
Hi,
I am making changes to a few modules of code and wish to test to see
if my changes have made any increases in memory utilization, execution
speed etc... The code is part of a server so lots of other stuff has
to be run AFAIK to test my code (all the server modules). Anyone know
exactly how I can test my code? Ideally I can make a writeup which
says something like, "My changes resulted in functions foo and bar
showed a N% reduction...
|
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 the objects for
which that memory was allocated are no longer live in the process. This
is only a leak if peak memory goes up again each time you create any new
objects. Try repeated allocations of a large dictionary and observe how
memory...
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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 then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
