Hello all,
I have a macro that sets up DB connections (libnames) to a ORA db when a new SAS EG session starts.
DB has a timeout of disconnect if connection is 15 min or idle.
The issue is if there is inactivity on the EG session and user re-run the macro manually (re-establish libnames) it takes 20-30 minutes to finish connecting/re-establishing or if a STOP or any other activity (open dataset, etc) is done the whole EG session freezes and one has to kill and start new. Any previous work is lost.
EG is 7.15 HF 7, SAS 9.4TS1M5
Any pointers as to why?
TIA.
S
I suggest you try DEFER = YES as an option on your database LIBNAME statements. This has the effect of delaying actual database connections until they are actually used. I doubt it will fix your problem but it may help reduce it.
I suggest you try DEFER = YES as an option on your database LIBNAME statements. This has the effect of delaying actual database connections until they are actually used. I doubt it will fix your problem but it may help reduce it.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.