473,325 Members | 2,805 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,325 software developers and data experts.

Stored Procedures (db2dari.exe) sucking up memory

Helpful folks,

Platform: DB2 UDB v7.2, Win2000, KEEPDARI=YES
I am trying to reduce memory usage of our SP's. We only have 80 or so
SP's but in the Task Manager/Processes display, there are over 200
entries for DB2DARI.EXE. Interestingly, there are many sets of these
entries which have the exact same memory usage size. It would appear
that for many of the SP's, there are multiple copies in memory.
Is there any way I can correlate the PID in this display to find (or
verify) just which SP is spawning multiple times?
Is there any way I can stop this behavior? If only one occurance of
each of the 80 SP's lived in memory, that would make my server much
happier.

Any help or pointers would be much appreciated.

Thanks
Sean

Nov 12 '05 #1
2 2006

"Scav" <db*****@yahoo.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...
Helpful folks,

Platform: DB2 UDB v7.2, Win2000, KEEPDARI=YES

I am trying to reduce memory usage of our SP's. We only have 80 or so
SP's but in the Task Manager/Processes display, there are over 200
entries for DB2DARI.EXE. Interestingly, there are many sets of these
entries which have the exact same memory usage size. It would appear
that for many of the SP's, there are multiple copies in memory.
Is there any way I can correlate the PID in this display to find (or
verify) just which SP is spawning multiple times?
Is there any way I can stop this behavior? If only one occurance of
each of the 80 SP's lived in memory, that would make my server much
happier.


The fact that some groups of these processes have the same memory size is
definitely related to the particular SP that the DARI process last executed.
But since these DARI processes are shared across all the agents, an agent
needing to run a SP will just pick an idle DARI to run the SP. So the
memory usage of these DARI processes may change over time.

The maximum number of these DARI processes will be the same as the maximum
number of agents that you have configured. This would only occur if every
one of your agents was running a SP at the same time though.

--
Matt Emmerton
Nov 12 '05 #2
Matt,

Thanks a lot for the feedback.
I always thought the MAXDARI dbm cfg parameter controlled how many dari
processes were allowed to run concurrently. I seem to remember getting
an error to this effect, that was resolved when I bumped this value up.

Sean

Nov 12 '05 #3

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

Similar topics

1
by: Rhino | last post by:
I am trying to get a sense of requirements and best practices for Java stored procedures in DB2 V7.2 for Windows. 1. Is it required or recommended that any of the following be closed before...
3
by: Rhino | last post by:
I've spent the last couple of hours trying to figure out how to debug a Java stored procedure and am just going in circles. The last straw came when I got "Cannot open input stream for default"...
5
by: Jeff | last post by:
I have question about differences in fenced sql procedures and fenced stored procedures. Do fenced sql procedures take up an extra memory segment when executed? Reason I ask is we have several...
2
by: Kent Lewandowski | last post by:
hi all, Recently I wrote some stored procedures using java jdbc code (admittedly my first stab) and then tried to implement the same within java packages (for code reuse). I encountered...
3
by: Bruce Pullen | last post by:
db27.2 fp7 on AIX5.2 I just bounced the database (as a specific db2dari process had reached user memory limit), and some (orpahned) db2dari processes are still there. db2fenc1 42682 1...
5
by: Rhino | last post by:
I am trying to determine the behaviour of stored procedures in DB2 V8.2.x in Windows/Unix/Linux and how I can control that behaviour. Some documentation in the manuals is confusing the issue...
45
by: John | last post by:
Hi When developing vb.bet winform apps bound to sql server datasource, is it preferable to use SELECTs or stored procedure to read and write data from/to SQL Server? Why? Thanks Regards
9
by: anilcool | last post by:
Hi all, Another novice question. I want to insert multiple records into my DB2 database using stored procedure but I do not know how many I would like to insert at any given time. Each record...
0
by: vanesa | last post by:
Hi, In a client we must begin to program many stored procedures of DB2. The following doubts arise to me that I raise you to see if you can help me: 1. From a point of view of the programming:...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
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...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.