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.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.