topic Source database is down when reading the data, is there anyway that query can wait for sometime and re-connect again?? in SAS Programming https://communities.sas.com/t5/SAS-Programming/Source-database-is-down-when-reading-the-data-is-there-anyway/m-p/56042#M11937 <HTML><HEAD></HEAD><BODY><P>COMMAND_TIMEOUT= looks like a libname option that could help...? </P><P></P></BODY></HTML> Tue, 29 Nov 2011 07:31:12 GMT LinusH 2011-11-29T07:31:12Z Source database is down when reading the data, is there anyway that query can wait for sometime and re-connect again?? https://communities.sas.com/t5/SAS-Programming/Source-database-is-down-when-reading-the-data-is-there-anyway/m-p/56041#M11936 <HTML><HEAD></HEAD><BODY><P>Hi Everyone,</P><P></P><P></P><P>We have SAS job which is connecting to DB2 database, and the job runs every day in unix environment.</P><P></P><P>Here we are facing problem that, DB2 database is getting down quite freqently (1 or 2 times in a weekly).</P><P>For that, we are re-running the job manually.</P><P></P><P></P><P>Question is,</P><P></P><P>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.</P><P></P><P></P><P>Thanks in advance!</P></BODY></HTML> Tue, 29 Nov 2011 05:34:09 GMT https://communities.sas.com/t5/SAS-Programming/Source-database-is-down-when-reading-the-data-is-there-anyway/m-p/56041#M11936 durga 2011-11-29T05:34:09Z Source database is down when reading the data, is there anyway that query can wait for sometime and re-connect again?? https://communities.sas.com/t5/SAS-Programming/Source-database-is-down-when-reading-the-data-is-there-anyway/m-p/56042#M11937 <HTML><HEAD></HEAD><BODY><P>COMMAND_TIMEOUT= looks like a libname option that could help...? </P><P></P></BODY></HTML> Tue, 29 Nov 2011 07:31:12 GMT https://communities.sas.com/t5/SAS-Programming/Source-database-is-down-when-reading-the-data-is-there-anyway/m-p/56042#M11937 LinusH 2011-11-29T07:31:12Z Source database is down when reading the data, is there anyway that query can wait for sometime and re-connect again?? https://communities.sas.com/t5/SAS-Programming/Source-database-is-down-when-reading-the-data-is-there-anyway/m-p/56043#M11938 <HTML><HEAD></HEAD><BODY><P> Thank You, COMMAND_TIMEOUT= is&nbsp; a libname option, I am actually connecting using Proc sql( I had to use passthough only)</P><P></P><P>How this option works, is it waits for the specified seconds when the connection got failed and it tries to re-connect?</P><P></P><P>Please help!</P></BODY></HTML> Tue, 29 Nov 2011 08:03:20 GMT https://communities.sas.com/t5/SAS-Programming/Source-database-is-down-when-reading-the-data-is-there-anyway/m-p/56043#M11938 durga 2011-11-29T08:03:20Z Source database is down when reading the data, is there anyway that query can wait for sometime and re-connect again?? https://communities.sas.com/t5/SAS-Programming/Source-database-is-down-when-reading-the-data-is-there-anyway/m-p/56044#M11939 <HTML><HEAD></HEAD><BODY><P> try using a libname statement with this option just before your CONNECT statement</P></BODY></HTML> Tue, 29 Nov 2011 10:07:58 GMT https://communities.sas.com/t5/SAS-Programming/Source-database-is-down-when-reading-the-data-is-there-anyway/m-p/56044#M11939 Peter_C 2011-11-29T10:07:58Z