| Author |
Message
|
| madhavt |
 Posted: Mon Dec 20, 2004 12:24 pm Post subject: Wait process in ESQL. |
 |
|
Newbie
Joined: 23 Aug 2003
Posts: 8
|
| Can anybody tell me if there is any way of holding a particular transaction for certain time (say 60seconds) in ESQL. |
|
| Back to top |
|
 |
| kirani |
| Posted: Mon Dec 20, 2004 12:34 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
No. There is no ESQL function to do this. Also, it's not recommended that you "wait" in your message flow. This could cause other deploy related problems on the same broker. Take a look at Timer plug-in node and see if that fits your requirement.
Also, please explain what exactly are you trying to do?
_________________
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 |
|
|
| madhavt |
| Posted: Mon Dec 20, 2004 1:02 pm Post subject: |
|
|
Newbie
Joined: 23 Aug 2003
Posts: 8
|
Thanks for your suggestion.
There is a big load of transactions going on, In between we get a certain error. So I need to keyoff that error and hold it for 60sec.
Madhav. |
|
| Back to top |
|
|
| kirani |
| Posted: Mon Dec 20, 2004 1:37 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
You mean hold the original message for 60 secs? And what would you do after 60 seconds with the message?
Why don't you just write the messages to a FAILQ and have another job process those messages at every 60 seconds.
_________________
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 |
|
|
| madhavt |
| Posted: Mon Dec 20, 2004 2:06 pm Post subject: |
|
|
Newbie
Joined: 23 Aug 2003
Posts: 8
|
There will be only one message when that particular error comes. So I need to hold that message.
Would you please explain how to invoke the process after 60 seconds to process that particular message.
Thanks
Madhav. |
|
| Back to top |
|
|
| kirani |
| Posted: Mon Dec 20, 2004 3:25 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
If you are running on Windows platform, you can schedule a task that will run every 60 secs, which will execute a program. This program can then put a message on your Broker's input queue to trigger the message flow.
_________________
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 |
|
|
|
|
