BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
shoin
Lapis Lazuli | Level 10

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

1 ACCEPTED SOLUTION

Accepted Solutions
SASKiwi
PROC Star

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.

View solution in original post

1 REPLY 1
SASKiwi
PROC Star

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.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

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!

Register Now

Creating Custom Steps in SAS Studio

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1221 views
  • 0 likes
  • 2 in conversation