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

when we query a table from the RedShift – we can see that our server memory (60Gb) gets exhausted. And when we terminate the query execution all the memory will be freed-up. So, from this looks, we can observe that the query result is being computed on our local SAS server thus causing for significant resource consumption.

ODBC-Drivers used:

PostgreSQL:  psqlodbc.so,  libodbcpsqlS.so

MySQL: libmyodbc5.so,   libodbcmyS.so

MySQL Unicode:  libmyodbc5w.so

MySQL ANSI Driver: libmyodbc5a.so

1 ACCEPTED SOLUTION

Accepted Solutions
ChrisHemedinger
Community Manager

See the doc for the different environment variables and ODBC.INI options that influence where SAS finds/loads your ODBC driver libraries.

 

I'm not sure we can tell you exactly how to change this for your environment, given that only you will know exactly where these libraries reside.  But perhaps there are common conventions and someone can chime in.

 

This article about UnixODBC (with lots of linked articles) might also help.

Register for SAS Innovate 2025!! The premier event for SAS users, May 6-9 in Orlando FL. Sign up now for the best deals!

View solution in original post

7 REPLIES 7
ChrisHemedinger
Community Manager

Hi, it sounds like you're using a generic ODBC (or Postgres) driver for this from SAS.  Even though Redshift is Postgres-like, it's not the same as Postgres.

 

SAS has a specialized engine for Redshift that's more performant -- read about it here.  If you don't have access to this engine, then I think you'll need to rely on explicit passthrough (use the CONNECT statement in your PROC SQL) to pass exactly the SQL you want the database to process.  The Redshift engine will help to optimize -- without this specific engine, the burden is on you to know more about how the Redshift database works.

 

Chris

Register for SAS Innovate 2025!! The premier event for SAS users, May 6-9 in Orlando FL. Sign up now for the best deals!
vishakh
Calcite | Level 5

How can we determine that we have access to this specialized Redshift Engine?

ChrisHemedinger
Community Manager

In your SAS environment, run:

 

proc product_status;
run;

If it's licensed/installed, you'll see it listed in the log.

Register for SAS Innovate 2025!! The premier event for SAS users, May 6-9 in Orlando FL. Sign up now for the best deals!
vishakh
Calcite | Level 5

Just to brief-in: Currently, I am using UnixODBC Driver Manager of version 2.2.14  and as we know to install the redshift driver we need to have a UnixODBC manager of minim. version 2.3.0

I have installed the newest version of manager.

Can you please let me know the files and locations of SAS config files where I need to change the path of the odbc path to pick-up new version?

vishakh
Calcite | Level 5

Can you please let me know the locations/files that I need to update with the new unixODBC driver path

vishakh
Calcite | Level 5

Attached is the screenshot showing our current LD_LIBRARY_PATH and PATH

 

Screen Shot 2019-05-22 at 11.04.26 AM.png

ChrisHemedinger
Community Manager

See the doc for the different environment variables and ODBC.INI options that influence where SAS finds/loads your ODBC driver libraries.

 

I'm not sure we can tell you exactly how to change this for your environment, given that only you will know exactly where these libraries reside.  But perhaps there are common conventions and someone can chime in.

 

This article about UnixODBC (with lots of linked articles) might also help.

Register for SAS Innovate 2025!! The premier event for SAS users, May 6-9 in Orlando FL. Sign up now for the best deals!

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 7 replies
  • 1356 views
  • 0 likes
  • 2 in conversation