MQSeries.net :: View topic - Assinging the List to Env Var from Select Query

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Assinging the List to Env Var from Select Query

Assinging the List to Env Var from Select Query

« View previous topic :: View next topic »

Author

Message

Gemz

Posted: Wed May 18, 2011 11:05 pm Post subject: Assinging the List to Env Var from Select Query

Centurion

Joined: 14 Jan 2008
Posts: 124

Hi,

I am using a passthru to select the values from Database which will return around 100 rows with 7 columns.

Select query is getting executed in 1 or 2 sec. But while assigning the values to Environment variables, it takes more than 40 sec.

We are using Broker Version 6.1.0.2

Pls suggest how can we improve the perf...

Quote:

2011-05-19 09:13:55.125672 9518 UserTrace BIP2562I: Node 'FlowName.Format_Inquiry_Reply': Assigning a list to ''Environment.Variables.AccountInq.AccountDetails[]''.
2011-05-19 09:14:36.802668 9518 UserTrace BIP2537I: Node 'FlowName.Format_Inquiry_Reply': Executing statement ''SET Environment.Variables.AccountInq.AccountDetails_Count[ ] = DEFAULTPASSTHRU('SELECT COUNT(1) AS TOTAL_COUNT FROM TABLE WHERE ACCOUNT_NUMBER = ? AND

_________________
GemZ
"An expert is one who knows more and more about less and less until he knows absolutely everything about nothing...."

j.f.sorge

Posted: Thu May 19, 2011 8:52 am Post subject: Re: Assinging the List to Env Var from Select Query

Master

Joined: 27 Feb 2008
Posts: 218

Gemz wrote:

We are using Broker Version 6.1.0.2

Probably updating to a newer version could help.

Did you try to assign the list into a ROW directly or use a REFERENCE to the last element within your Environment tree?
_________________
IBM Certified Solution Designer - WebSphere MQ V6.0
IBM Certified Solution Developer - WebSphere Message Broker V6.0
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0

Gemz

Posted: Fri May 20, 2011 4:38 am Post subject:

Centurion

Joined: 14 Jan 2008
Posts: 124

Hi,

It looks like an environment issue. We have restarted the broker and now it is takes less than 4 sec for the same request.

-GemZ
_________________
GemZ
"An expert is one who knows more and more about less and less until he knows absolutely everything about nothing...."

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Assinging the List to Env Var from Select Query

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