Retry upon connection failure in Datastage for MQ and WS

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
bman
Participant
Posts: 33
Joined: Wed Oct 10, 2007 5:42 pm

Retry upon connection failure in Datastage for MQ and WS

Post by bman »

Hi,

I am working on a project where one of the requirement is to have retry logic bulit in the datastage flow so that incase of a conenction failure datastae will retry to load data multiple time before aborting.

I have twocases, in one scenario destination is an MQ and in the second scenario destination is a Webservice ( I am using WS transformer stage).

And I want to build a retry logic so that incase of a connection failure to WS, my code should be able to try sending the data to the Webservice multiple time without manual intervention and if it fails even after multiple attempts then it aborts. ( And I a similiar logic for MQ stage also ).

Do we have any standard way in Datastage to schieve this functionality in Datastage? Or has any one worked on similiar approach?
JoshGeorge
Participant
Posts: 612
Joined: Thu May 03, 2007 4:59 am
Location: Melbourne

Post by JoshGeorge »

Modular design! When loading job, ie. loading to MQ / Webservice job fails, check for reason (If required look up with known connection error) in the job sequence and play it in a loop. Set or parameterize loop tries.
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
eostic
Premium Member
Premium Member
Posts: 3838
Joined: Mon Oct 17, 2005 9:34 am

Post by eostic »

Yes...that is probably the best method, because a connection failure on most Stages is fatal, and not easily capturable for techniques and tricks within the job itself.

Ernie
Ernie Ostic

blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
eostic
Premium Member
Premium Member
Posts: 3838
Joined: Mon Oct 17, 2005 9:34 am

Post by eostic »

Yes...that is probably the best method, because a connection failure on most Stages is fatal, and not easily capturable for techniques and tricks within the job itself.

Ernie
Ernie Ostic

blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
Post Reply