473,378 Members | 1,368 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,378 software developers and data experts.

db2ckpwd uses a lot of memory

Hi!

I'm on Linux RHEL 64-bit db2 version 9.5.0.1 using four partitions on
a single server.
The db2ckpwd 4*3 =12 processes each uses 959220 k of memory which
totals +10GB.
Also the four db2wdog processes each uses +1GB
Are these figures normal?
Can they be configured?
/dg

Aug 4 '08 #1
4 8633
On Aug 4, 5:33*am, danfa...@hotmail.com wrote:
Hi!

I'm on Linux RHEL 64-bit db2 version 9.5.0.1 using four partitions on
a single server.
The *db2ckpwd *4*3 =12 processes each uses 959220 k of memory which
totals +10GB.
Also the *four db2wdog processes each uses +1GB
Are these figures normal?
Can they be configured?
/dg
I experienced same thing in V8.2 The resolution was db2set
DB2_NUM_CKPW_DAEMONS=0
and bounce instance.
Aug 4 '08 #2

"Richard" <RS****@gmail.comwrote in message news:9f**********************************@p25g2000 hsf.googlegroups.com...
On Aug 4, 5:33 am, danfa...@hotmail.com wrote:
Hi!

I'm on Linux RHEL 64-bit db2 version 9.5.0.1 using four partitions on
a single server.
The db2ckpwd 4*3 =12 processes each uses 959220 k of memory which
totals +10GB.
Also the four db2wdog processes each uses +1GB
Are these figures normal?
Can they be configured?
/dg
I experienced same thing in V8.2 The resolution was db2set
DB2_NUM_CKPW_DAEMONS=0
and bounce instance.
That would mean that a ckpw process must be spawned for each logon try.
What perfromance issues did you get?
/dg
Aug 4 '08 #3
da******@hotmail.com wrote:
Hi!

I'm on Linux RHEL 64-bit db2 version 9.5.0.1 using four partitions on
a single server.
The db2ckpwd 4*3 =12 processes each uses 959220 k of memory which
totals +10GB.
Also the four db2wdog processes each uses +1GB
Are these figures normal?
Where are you getting that information from? From what I can tell, each of
my db2ckpwd processes are actually using under 30MB. Perhaps you're
confusing VmSize and VmRSS? The VmSize is a virtual size - it just tells
you how many pages are available to the process. That doesn't mean there is
any real memory (either physical RAM or virtual through your swap
partition(s)) behind it. The VmRSS tells you how much actual memory is
allocated to the process (not swapped).

Stolen from
http://www.linuxforums.org/forum/lin...id-status.html :

VmSize: The size of the virtual memory allocated to the process
VmLck: The amount of locked memory
VmRSS: The amount of memory mapped in RAM ( instead of swapped out )
VmData: The size of the Data segment
VmStk: The stack size
VmExe: The size of the executable segment
VmLib: The size of the library code
VmPTE: Size of the Page Table entry

I believe that shared memory gets counted in here. For example, the library
code is unlikely to be duplicated from process to process - if you already
have libdb2.so.1 loaded in one db2ckpwd process, it's unlikely to be copied
to the other two. Instead, each process gets read-access to the same pages
of memory, and thus it's only loaded once. Same goes for the data segment -
much of it is likely shared in copy-on-write fashion (and most of it is
unlikely to be written to). Some of it may be shared memory that is shared
with db2syscr (the root-based system controller), so it's allocated either
way anyway.
Can they be configured?
You can try the disabling trick - but you should check your memory usage (I
use conky for this) before and after to see if you're really seeing a memory
savings. My bet is that you won't even notice.
Aug 4 '08 #4
On Aug 4, 10:26*pm, Darin McBride
<dmcbr...@naboo.to.org.no.spam.for.mewrote:
danfa...@hotmail.com wrote:
Hi!
I'm on Linux RHEL 64-bit db2 version 9.5.0.1 using four partitions on
a single server.
The *db2ckpwd *4*3 =12 processes each uses 959220 k of memory which
totals +10GB.
Also the *four db2wdog processes each uses +1GB
Are these figures normal?

Where are you getting that information from? *From what I can tell, each of
my db2ckpwd processes are actually using under 30MB. *Perhaps you're
confusing VmSize and VmRSS? *The VmSize is a virtual size - it just tells
you how many pages are available to the process. *That doesn't mean there is
any real memory (either physical RAM or virtual through your swap
partition(s)) behind it. *The VmRSS tells you how much actual memory is
allocated to the process (not swapped).

Stolen fromhttp://www.linuxforums.org/forum/linux-kernel/49438-proc-pid-status.html:

*VmSize: The size of the virtual memory allocated to the process
*VmLck: The amount of locked memory
*VmRSS: The amount of memory mapped in RAM ( instead of swapped out )
*VmData: The size of the Data segment
*VmStk: The stack size
*VmExe: The size of the executable segment
*VmLib: The size of the library code
*VmPTE: Size of the Page Table entry

I believe that shared memory gets counted in here. *For example, the library
code is unlikely to be duplicated from process to process - if you already
have libdb2.so.1 loaded in one db2ckpwd process, it's unlikely to be copied
to the other two. *Instead, each process gets read-access to the same pages
of memory, and thus it's only loaded once. *Same goes for the data segment -
much of it is likely shared in copy-on-write fashion (and most of it is
unlikely to be written to). *Some of it may be shared memory that is shared
with db2syscr (the root-based system controller), so it's allocated either
way anyway.
Can they be configured?

You can try the disabling trick - but you should check your memory usage (I
use conky for this) before and after to see if you're really seeing a memory
savings. *My bet is that you won't even notice.
Thanks. Always learning more.....
/dg
Aug 5 '08 #5

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

Similar topics

11
by: Anze | last post by:
Hi! I have a script that uses a lot of memory and an ISP that has memory-limit set to 10 Mb. The script of course doesn't finish running. :( The program is rather simple - it parses XML into...
9
by: Chris S. | last post by:
Is it possible to determine how much memory is allocated by an arbitrary Python object? There doesn't seem to be anything in the docs about this, but considering that Python manages memory...
5
by: pete | last post by:
Can anyone give me some sugguestions here. Connection is declared at the start of the application Set rsFZReport.ActiveConnection = conn Then a function repeatly opens recordsets like this - ...
9
by: Jimmy Cerra | last post by:
I am a little confused how the memory for objects is allocated in JavaScript. David Flanagan, in "JavaScript: The Definitive Guide," states that each property of a class takes up memory space when...
6
by: Shane Story | last post by:
Are dotnet languages just memory hogs or am I doing something wrong. I have noticed that my program is taking 7MB of ram, and some other simple programs seem to be taking a lot of ram also. I...
8
by: johnlichtenstein | last post by:
I am using cx_Oracle and MySQLdb to pull a lot of data from some tables and I find that the cursor.execute method uses a lot of memory that never gets garbage collected. Using fetchmany instead of...
15
by: mangesh | last post by:
This code is from c++ faq in section 11 : void someCode() { char memory; void* p = memory; Fred* f = new(p) Fred(); f->~Fred(); // Explicitly call the destructor for the placed object }
2
by: Ilkka | last post by:
I have created an C++ application with Windows Forms, ADO and SQL server 2005. Now I need to change something and started debugging the code. Then suddenly I receive an error. "An unhandled...
3
by: crazy420fingers | last post by:
I'm running a python program that simulates a wireless network protocol for a certain number of "frames" (measure of time). I've observed the following: 1. The memory consumption of the program...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
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...

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.