BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
SSA1
Fluorite | Level 6

1) We are able to connet Remote server server from client machine.

2) And we are able to assign Oracle library through SAS macro. 

3) And then we ar able to call the stored complied macro for oracle connection from Base SAS Windowing Environment

 

When we click the remote library, the remote library is loading and it is not displaying. It is taking long time and it leads to terminate the SAS session. 

 

Can you please help how to quickly load the remote library in Base SAS Environment. 

 

%LET sunsas=server_name port_number;

OPTIONS REMOTE=sunsas COMAMID=TCP;
options compress=yes;
FILENAME RLINK "C:\sas\connect\saslink\tcpunixf.scr";
signon;

 

rsubmit;

     libname t_lib '/one/two';
     options mstored sasmstore=t_lib;
    %conn_macro(one, two, oracl);
endrsubmit;

libname t_ora remote slibref=oracl server=sunsas;

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Kurt_Bremser
Super User

I guess you are simply causing network congestion. If your SAS server (sunsas) uses one interface to connect to both the client and the Oracle server, it will quickly be swamped by colliding packets when it tries to receive information from Oracle and send it to the SAS client concurrently.

 

Try to do a proc datasets on the Oracle library (remote on sunsas) and then look at the results.

View solution in original post

1 REPLY 1
Kurt_Bremser
Super User

I guess you are simply causing network congestion. If your SAS server (sunsas) uses one interface to connect to both the client and the Oracle server, it will quickly be swamped by colliding packets when it tries to receive information from Oracle and send it to the SAS client concurrently.

 

Try to do a proc datasets on the Oracle library (remote on sunsas) and then look at the results.

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
  • 1 reply
  • 1012 views
  • 2 likes
  • 2 in conversation