BookmarkSubscribeRSS Feed
fbwoinem
Calcite | Level 5

Hi,

according for the documentation ti is not possible to set the libname option ENABLEDIRECTIO for the WORK library.

I wonder whether there is a good reason for this limitation.

If not, is there maybe a trick to use it anyway?

Thanks,

Frank

1 REPLY 1
Kurt_Bremser
Super User

I would not do that, even if it worked.

My reasoning:

When writing through the OS cache, any subsequent read will not have to access the disk, but will read the contents of the cache, if the data are still there. Since it is quite common that the data written to WORK are read again shortly after, disabling the OS cache will have a negative impact on performance (and lead to additional disk contention in the physical volumes containing the WORK directories).

A good OS will make very good decisions which data to keep in its cache; it will also help you by deferring disk writes (speeding up virtual write performance) and by reading ahead for you.

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

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