| Author |
Message
|
| angka |
 Posted: Mon Dec 14, 2009 1:47 am Post subject: handling retry in mapping node(DB select) when DB down? |
 |
|
Chevalier
Joined: 20 Sep 2005
Posts: 406
|
Hi,
My DB server resides on different server from MB server and if there is intermitten nw issue, how should I retry the mapping node with DB select?
I want to keep retrying until DB is up because without DB up, the flow will not complete.
Thanks |
|
| Back to top |
|
 |
| sirsi |
| Posted: Mon Dec 14, 2009 1:57 am Post subject: |
|
|
Disciple
Joined: 11 Mar 2005
Posts: 177
|
one way to implement is:-
first note down db error codes which occur due to non-availability of the database.
in the error handler, when an db error occurs, lookup for the above error codes and send the input message to reprocessing queue... after sometime try to process these message again...(may be a java program to move messages from reprocessing queue to input queue of the flow)... |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Mon Dec 14, 2009 2:29 am Post subject: Re: handling retry in mapping node(DB select) when DB down? |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
| angka wrote: |
Hi,
My DB server resides on different server from MB server and if there is intermitten nw issue, how should I retry the mapping node with DB select?
|
This is an architectural and/or configuration issue in your organisation. FIX THIS PROBLEM FIRST.
The number of possible errors you can get back as a resuilt of network glitches are huge and it is almost impossible to code for them all let alone test the operation of your code when handling each & everyone of them.
I had this problem at one customer. In the end, they put in another LAN just to make sure their production databases were always available for the users like Broker. Directly connected clients used the old lan. Overall, the reliability was vastly increased and the business was happy.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| angka |
| Posted: Mon Dec 14, 2009 4:11 am Post subject: |
|
|
Chevalier
Joined: 20 Sep 2005
Posts: 406
|
Hi
both e servers reside on e same lan. it could be the any error. i just name one of them. basically i just need to re try mapping if there is DB error. |
|
| Back to top |
|
|
| fschofer |
| Posted: Mon Dec 14, 2009 4:56 am Post subject: |
|
|
Knight
Joined: 02 Jul 2001
Posts: 524
Location: Mainz, Germany
|
Hi,
in the Bullet Proofing Message Flows redpaper below you will find several examples how you can react to error situation in your message flows.
http://www.redbooks.ibm.com/redpapers/pdfs/redp4043.pdf
There are also some samples regarding database problems which may match your requirements or at least give you some hints.
Greetings
Frank |
|
| Back to top |
|
|
|
|
