SAS EG Connection to DB; session Freezing

[shoin]

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

[SASKiwi · Accepted solution]

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.