ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Releasing memory on execution group

Post new topic  Reply to topic
 Releasing memory on execution group « View previous topic :: View next topic » 
Author Message
dbeaumont
PostPosted: Wed Nov 26, 2008 10:13 am    Post subject: Releasing memory on execution group Reply with quote

Newbie

Joined: 10 Oct 2006
Posts: 9

Message Broker version 6.0.0.8
Windows 2003

I'm using the PASSTHRU function in a compute node, which will return about 200,000 records from an Oracle table.
In checking the Task Manager we see that the memory for the DataFlowEngine is not releasing after this is done processing.
Memory usage started at about 87000k and ended at 524792k.
We have a propagate statement for further processing but this is only being invoked once and we've disconnected the terminal.

The PASSTHRU is returning records directly into an OutputRoot tree. No Environment or LocalEnvironment messages are being
written to. We're setting the OutputRoot to NULL right before the final return (RETURN FALSE).

Any recommendations of how we can release memory without restarting the execution group would be appreciated.
Back to top
View user's profile Send private message
golam1983
PostPosted: Thu Nov 27, 2008 6:30 am    Post subject: Reply with quote

Apprentice

Joined: 27 Jun 2008
Posts: 35

I can see only one way. Use database cursor to select. Combine Database stored procedure along with ESQL. May be this link can help you

http://www.databasedesign-resource.com/ref-cursor.html
Back to top
View user's profile Send private message
j.f.sorge
PostPosted: Fri Nov 28, 2008 2:19 am    Post subject: Re: Releasing memory on execution group Reply with quote

Master

Joined: 27 Feb 2008
Posts: 218

dbeaumont wrote:
...
In checking the Task Manager we see that the memory for the DataFlowEngine is not releasing after this is done processing.
Memory usage started at about 87000k and ended at 524792k.

We had the same problem and I asked IBM - it is a "feature" in 6.0 and 6.1 that it does not free memory. The execution group will be restarted automatically if it got to big and free the memory in that way.
Back to top
View user's profile Send private message
francoisvdm
PostPosted: Mon Dec 01, 2008 3:06 am    Post subject: Reply with quote

Partisan

Joined: 09 Aug 2001
Posts: 332

j.f is correct, it is stated in the documentation somewhere that it will never release the memory while exe group is running. I did the research about 1 month ago and came across it.

When you ran out of memory...the exe group will dump...but then it will restart, not 100% good behavior, but at least it will restart.
_________________
If you do not know the answer or you get the urge to answer with "RTFM" or "Search better in this forum", please refrain from doing so, just move on to the next question. Much appreciated.

Francois van der Merwe
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Releasing memory on execution group
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.