11-29-2011 12:34 AM
We have SAS job which is connecting to DB2 database, and the job runs every day in unix environment.
Here we are facing problem that, DB2 database is getting down quite freqently (1 or 2 times in a weekly).
For that, we are re-running the job manually.
Can we put some logic so that when the connection fails(database is down), Query can re-connect after 15 min and till the time job need to be in ideal state.
Thanks in advance!
11-29-2011 02:31 AM
COMMAND_TIMEOUT= looks like a libname option that could help...?
11-29-2011 03:03 AM
Thank You, COMMAND_TIMEOUT= is a libname option, I am actually connecting using Proc sql( I had to use passthough only)
How this option works, is it waits for the specified seconds when the connection got failed and it tries to re-connect?
11-29-2011 05:07 AM
try using a libname statement with this option just before your CONNECT statement