DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
clarcombe



Group memberships:
Premium Members

Joined: 08 Jun 2005
Posts: 506
Location: Europe
Points: 5277

Post Posted: Mon Sep 25, 2017 12:47 pm Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Following on from another topic I have posted when we have a failure on our JDBC connector, I was wondering what process I could place to retry or automatically restart a job if there is a failure.

We connect to a DB2 Z/OS mainframe and, more often than not, there are no resources on the mainframe to service our enquiry.

Our Delete/Insert jobs hang and we need to restart them manually. Is there a way to detect this sort of error and loop and try again X times until the job actually completes ?

Thanks

_________________
Colin Larcombe
-------------------

Certified IBM Infosphere Datastage Developer
clarcombe



Group memberships:
Premium Members

Joined: 08 Jun 2005
Posts: 506
Location: Europe
Points: 5277

Post Posted: Thu Nov 16, 2017 2:47 am Reply with quote    Back to top    

We have not been able to get to the bottom of why this is failing. Even though we have installed the latest JDBC connector we still get intermittent failures.

I have asked the production team who run the DS script to re-run the script up to 5 times if they get an error code returned from the DS script.

This is not a great solution and they are reluctant to implement it. I find it strange that there is no retry after failure option.

_________________
Colin Larcombe
-------------------

Certified IBM Infosphere Datastage Developer
Rate this response:  
Not yet rated
qt_ky



Group memberships:
Premium Members

Joined: 03 Aug 2011
Posts: 2653
Location: USA
Points: 19683

Post Posted: Thu Nov 16, 2017 8:48 am Reply with quote    Back to top    

I don't know about the JDBC stage. The Oracle Connector stage does have some retry yes/no settings and sub-settings you can enable. Hopefully IBM would provide the same functionality on the JDBC Connector.

As you discovered on this post, you can work around it at a higher level, automatically, by using looping in a sequence job.

http://www.dsxchange.com/viewtopic.php?t=157449

_________________
Choose a job you love, and you will never have to work a day in your life. - Confucius
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
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



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours