Hi Everyone,
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.
Question is,
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!
COMMAND_TIMEOUT= looks like a libname option that could help...?
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?
Please help!
try using a libname statement with this option just before your CONNECT statement
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.