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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.