Dear Team,
I am getting Out of disk issue in Clustering node when executing the 7 Millions records in SAS Data Management Server. I have used 5 parameters for Match Code then after i used Clustering Node.
I have attached screenshot for your references, Please find it and let me know if required any other details.
I have checked with Cluster Options and also put maximum size in 4000 MB in Override clustering memory size and CLUSTER/BYTES is 4194304000 in Data Management Studio. still i am facing same issue.
Thank You
Shakti
Hi,
The matching and clustering are intensive operations that require lots of resources. You can take a look at your available temp space before and during the operation, but it's most likely that it's filling it out.
Hope this helps.
Audrey
Dear Audrey,
Okay, I have ran the job in server again. Can you suggest me how to check Temp Space in Server ?
That would be in the File System of your DMServer machine.
ADMIN team has increased the server space from 1 TB to 3 TB. it will resolve this issue or is there any other activity pending ?
It's difficult to predict the amount needed as this depends on many factors like the number of records, their size, the number of matching conditions, the size of the clusters (= how many records end in a group), etc.
However I believe 3 TB should be enough and if it's still failing, I would encourage you to open a ticket with Technical Support so they can investigate.
okay, I have checked the Temp File Space. Please find the attached screenshot and let me know if required any other details.
Please find the attachment,
I'm not really sure what that shows.
Is this the total amount of free space on the disk before the job runs? during the run? when it fails?
In any case, that doesn't seem enough. ALso, didn't you say you got more space on the machine?
Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.
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.