Retry on JDBC connector
Posted: Wed Aug 23, 2017 2:46 am
Occasionally we get timeout errors when trying to read DB2 on Z/OS using a JDBC stage.
However on the next run of the batch it then works.
For information, this is the error that occurs
This is one of a number of tables read by a generic routine. Its never the same table that fails twice and the batch can go days without failure
Question
Is there an option in the JDBC stage to allow us to retry x times after a time period has elapsed e.g. 1 minute ?
Are there any other ways to get around this ?
However on the next run of the batch it then works.
For information, this is the error that occurs
Code: Select all
Fatal Error: waitForWriteSignal(): Premature EOF on node vdatastagep.fmsb.be Bad file descriptor
Question
Is there an option in the JDBC stage to allow us to retry x times after a time period has elapsed e.g. 1 minute ?
Are there any other ways to get around this ?