I have a job which is accessing an external application called 'HiPortfolio' through ODBC stage. There is an issue where the DS job hangs even when the 'HiPortfolio' server is down. i.e. it tries to connect to the application even when the server is not up. This situation needs to be handled in DS by providing a TIMEOUT for the connection establishment, so that, the job ends after waiting for a period of say 60 seconds.
Is there any way I can handle this in DS? Is there any 'TimeOut' Environment variable I can use? I searched through the archives but couldnt find an answer to this situation.
Thanks in advance,
TIMEOUT implementation in DataStage job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 74
- Joined: Sat Jul 08, 2006 4:09 am
- Location: Melbourne, Australia
- Contact:
TIMEOUT implementation in DataStage job
Durga Prasad
-
- Participant
- Posts: 83
- Joined: Sat Oct 28, 2006 6:25 am
Re: TIMEOUT implementation in DataStage job
Craig,
I wonder will the job hang or abort because of connection faliure ?
I wonder will the job hang or abort because of connection faliure ?
durgaps wrote:I have a job which is accessing an external application
called 'HiPortfolio' through ODBC stage. There is an issue where the DS job hangs even when the 'HiPortfolio' server is down. i.e. it tries to connect to the application even when the server is not up. This situation needs to be handled in DS by providing a TIMEOUT for the connection establishment, so that, the job ends after waiting for a period of say 60 seconds.
Is there any way I can handle this in DS? Is there any 'TimeOut' Environment variable I can use? I searched through the archives but couldnt find an answer to this situation.
Thanks in advance,
-
- Participant
- Posts: 83
- Joined: Sat Oct 28, 2006 6:25 am
I do agree with you, because from what I have seen the jobs abort with connection failure error!
chulett wrote:Connection failures would typically result in a simple abort of the job... don't recall any situations where it would result in a 'hang'.![]()
But then I've never heard of HiPortfolio or if there is anything 'special' about it...