topic Re: To continue running schedule jobs when teh Workspace server space is low or full. in Administration and Deployment

To continue running schedule jobs when teh Workspace server space is low or full.

santosh_pat69 — Mon, 19 Sep 2016 15:04:35 GMT

Hi,

I have recently started working on SAS Administration.

I have 5 jobs scheduled using crontab all the jobs have different priorities.

and these jobs are failing due to the less space on SAS workspace server issue.

Please let me know how to go about this issue.

Re: To continue running schedule jobs when teh Workspace server space is low or full.

anja — Mon, 19 Sep 2016 19:04:14 GMT

Hi, what is the exact error message you are getting?

Thanks

Anja

Re: To continue running schedule jobs when teh Workspace server space is low or full.

Kurt_Bremser — Tue, 20 Sep 2016 06:36:37 GMT

First of all, run the cleanwork utility to get rid of remnants of crashed SAS sessions that clutter up your WORK.

Second, check if running the jobs one at a time does not cause an overflow in WORK. If that is the case, schedule the jobs so that enough time is between them that every job is finished before the next one executes; or wrap them into one shellscript that runs them in succession, and schedule only that.

If the single jobs keep exploding your WORK, you need to either increase available space, or work at improving workspace economy within your jobs (replace complicated SQLs with data step logic (as PROC SQL creates large temporary utility files in WORK that will often cause a completely unnecessary overflow), use compress=yes on WORK datasets, use tagsort on sorts of large compressed datasets, and so on. Googling "improve SAS performance" will get you lots of hints.

Re: To continue running schedule jobs when teh Workspace server space is low or full.

JuanS_OCS — Tue, 20 Sep 2016 06:40:30 GMT

Hi,

I currently understand that "less space" means "insufficient disk space or memory".

If that is the situation, please run a df -h such as:

root@tecmint ~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/cciss/c0d0p2      75G   23G   49G  32% /
/dev/cciss/c0d0p5      24G   22G  1.2G  95% /home
/dev/cciss/c0d0p3      29G   25G  2.6G  91% /data
/dev/cciss/c0d0p1     289M   22M  253M   8% /boot
tmpfs                 252M     0  252M   0% /dev/shm

As you see, this will give you the disk space available on your mounted disk volumes. You will need to check you have enough disk space on each. SASWORK by default is written on /tmp, but I hope you have configured a different and separated location for it.

Also, it might be running out space your /home/user folder.

Re: To continue running schedule jobs when teh Workspace server space is low or full.

santosh_pat69 — Tue, 20 Sep 2016 20:51:58 GMT

Hi Kurt,

Thank you !!!!
I have made note of your suggestions and will follow them whenever we have this issue.