BookmarkSubscribeRSS Feed
AsakoOkano
Fluorite | Level 6

Hi

 

I have SAS9.4 Intelligence platform environment connect to other RDBMS with SAS Access Interface ot ODBC.

I have ODBC database server and ODBC library resistered in metadata. I want to limit number of secession that connect outside of RDBMS at same time for server resource reason. Is there any way to cofigure the limitation of concurrent session on ODBC library?

 

thanks.

Asako

2 REPLIES 2
Patrick
Opal | Level 21

@AsakoOkano wrote:

Hi

 

I have SAS9.4 Intelligence platform environment connect to other RDBMS with SAS Access Interface ot ODBC.

I have ODBC database server and ODBC library resistered in metadata. I want to limit number of secession that connect outside of RDBMS at same time for server resource reason. Is there any way to cofigure the limitation of concurrent session on ODBC library?

 

thanks.

Asako


Isn't this something you'd typically restrict on the database side?

SAS sessions execute independently from each other and I'm not aware of any repository which registers active connections to a database. As such I wouldn't know how such a limitation could even get implemented on the SAS side.

Anand_V
Ammonite | Level 13
Hi @AsakoOkano,

I haven't seen an option that can be given as integer value to limit connections to DB from SAS Side. This is something you can set on the DB configuration. However there are few options on SAS Side which you can use to optimize your connection to external database. This can be found under Advanced options -> Connection tab of the DB library.

This #SASGF paper has a nice tabular information on all the possible values for this option along with description.

Pg:8 Section: Connection Tab
https://www.sas.com/content/dam/SAS/support/en/sas-global-forum-proceedings/2018/2357-2018.pdf

Thanks!

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 847 views
  • 1 like
  • 3 in conversation