BookmarkSubscribeRSS Feed
astrae_research
Obsidian | Level 7

Dear all,

 

How do you edit your .cfgs to balance the load for UTILLOC and WORK librefs on 2 NVME drives?

HEre are my lines from sasv9.cfg

 

-UTILLOC ('d:\SAS UTILITY FILES','e:\SAS UTILITY FILES')

-WORK "e:\SAS94\SASFoundation\9.4\nls\en\work_list.txt"

 

Here is my work_list.txt following http://support.sas.com/documentation/cdl/en/hostwin/69955/HTML/default/viewer.htm#n1qr5dmzagn9krn1lt...

/d/SAS_TEMP
/e/SAS_TEMP
    Method=Random

 

SAS loaded through EG just freezes until i remove these lines. The folders exist and everything else works ok. If i just specify one UTILLOC and and only one work lib, and run a whole bunch of sorting with 10 gigs datasets, the code runs a minute but it never writes any util files to the UTILLOC (verified through res monitor) it just creates a few 0 size files in that location. I really wish there were more documentation on these features. I have a terabytes big project and this optimization will save time.

 

Thank you

5 REPLIES 5
Kurt_Bremser
Super User

I'd rather use one volume striped over those two disks, and use the one resulting path for WORK. To further speed things up, use a similar stripeset for UTILLOC. That's what I did for a long time with LVM on AIX, and it served me well. Nowadays, the SAN storage is fast enough to handle all I/O (WORK and permanent).

astrae_research
Obsidian | Level 7

Thank you for the answer! Unfortunately, there is no budget (or time to research other options) for anything else so I'm looking for a quick and dirty way to make things work.

 

I corrected the file (just trial and error, love the sas doc) and now SAS loads but only uses one folder for WORK and never the other.

 

Thsi is the file now

"d:\SAS_TEMP"
"e:\SAS_TEMP"
    Method=Random

 

 

astrae_research
Obsidian | Level 7

Ok, so I misunderstood the doc. Would software striping done in Win 7 x64 do?

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 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 5 replies
  • 1136 views
  • 0 likes
  • 2 in conversation