| Author |
Message
|
| basha |
 Posted: Thu Nov 18, 2004 8:22 am Post subject: Timeout Help |
 |
|
Apprentice
Joined: 25 Apr 2004
Posts: 31
|
Hello All,
Can we use the aggregate nodes for a request , reply and time out functionality in a single message flow. All I need is to watch out for a time out on a DB insert compute node.
Do we need two seperate message flows for this?
Thanks,
Basha
Last edited by basha on Tue Nov 23, 2004 9:59 am; edited 2 times in total |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Thu Nov 18, 2004 8:26 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| http://publib.boulder.ibm.com/infocenter/wbihelp/index.jsp?topic=/com.ibm.etools.mft.doc/ac12310_.htm wrote: |
| You can either create the fan-out and fan-in flows in the same message flow, or in two different message flows. |
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| kirani |
| Posted: Thu Nov 18, 2004 5:54 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
From the description you provided it seems like you are going to be using single compute node to insert into DB withtin the same message flow?? If so, then why do you need the aggregate nodes for? You can set a timeout value on DB, so that it will throw and SQL error if your query processing time exceeds that time. You can then handle such errors with your message flow to create falure message.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| basha |
| Posted: Tue Nov 23, 2004 9:53 am Post subject: Timeout Help |
|
|
Apprentice
Joined: 25 Apr 2004
Posts: 31
|
Kiran,
Could you please elaborate your suggestion? I did not find any property that speaks about time out in any one of these nodes: DBUpdate, DBIinsert, Compute etc;
Or is it some thing you enable it on the table itself.
Thanks,
Basha. |
|
| Back to top |
|
|
| kirani |
| Posted: Tue Nov 23, 2004 11:41 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
It's not a property of DB/WMQI nodes. It's a property at DB level. What DB are you using?
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| basha |
| Posted: Wed Nov 24, 2004 11:27 am Post subject: |
|
|
Apprentice
Joined: 25 Apr 2004
Posts: 31
|
I am using DB2 8.1.
Thanks,
Basha |
|
| Back to top |
|
|
| kirani |
| Posted: Wed Nov 24, 2004 5:06 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
I dont remember the parameter name, but if you do a "get db cfg for <db_name>" at db2 command prompt, it will return you the list of exisiting parameter with values. One of them controls the Timeout on the DB.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
|
|
