SAS EG Connection to DB; session Freezing

shoin — Thu, 28 Mar 2019 15:37:03 GMT

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.

Re: SAS EG Connection to DB; session Freezing

SASKiwi — Thu, 28 Mar 2019 20:21:53 GMT

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.

topic SAS EG Connection to DB; session Freezing in SAS Enterprise Guide

SAS EG Connection to DB; session Freezing

Re: SAS EG Connection to DB; session Freezing