UnixPedia : HPUX / LINUX / SOLARIS: HPUX :HOW TO USE CLEANWORK FOR SAS ON UNIX

Thursday, October 3, 2013

HPUX :HOW TO USE CLEANWORK FOR SAS ON UNIX

The SAS work directory - /saswork on JUPITER.finsh.com server is filling up now.  It is 86% full.
Generally when SAS processes run properly, any temporary files are removed when the process completes.
However, if a SAS process fails, the sas temp files remain in the WORK directory. It sounds like that is what is being seen here.
1041203200 889510925 142214623   86% /saswork
To prevent it reach to 100% full and all the applications will be shut down. To avoid the outage of application need to run the cleanwork script to remove the temporary unsed file holding the space.
1.       Run script “cleanwork”  as root from /sas/9.3/SASFoundation/9.3/utilities/bin
If it reduce /saswork from 86% down to below 15% then stop here.  Otherwise go to next step
2.       please run as root remove all the file folders in attached file - manul_remove. (remove older then 1 months)
3.   Schedule the cleanwork in non_business to cleanup the directory.
Enter the below line in cron file. with schedule time and date.

* * * * * /SASHome/SASFoundation/9.3/utilities/bin/cleanwork  /suser/temp > /dev/null 2>&1
For testing (In preview mode)
/SASHome/SASFoundation/9.3/utilities/bin/cleanwork  /suser/temp  -n

1 comment:

  1. /dev/vg_sasuser/suser
    314376192 309424320 4916896 98% /suser

    #Run the cleanwork in preview mdoe to check file which will get removed.
    #-> /SASHome/SASFoundation/9.3/utilities/bin/cleanwork /suser/temp -n
    /suser/temp/SAS_workFB55000013C9_jupitorp
    /suser/temp/SAS_work6B0000007137_jupitorp
    cleanwork: /suser/temp/SAS_workFDD3000035A7_jupitorp is IN USE by process id 13735
    /suser/temp/SAS_work1329000016E9_jupitorp
    ------ trunc -------------------
    /suser/temp/SAS_util0001000068C3_jupitorp
    /suser/temp/SAS_work549F00003609_jupitorp
    /suser/temp/SAS_util000100003609_jupitorp
    /suser/temp/SAS_work931F0000046E_jupitorp
    /suser/temp/SAS_util00010000046E_jupitorp

    #-> /SASHome/SASFoundation/9.3/utilities/bin/cleanwork /suser/temp
    cleanwork: /suser/temp/SAS_workFDD3000035A7_rau0001p is IN USE by process id 13735

    #-> bdf .
    Filesystem kbytes used avail %used Mounted on
    /dev/vg_sasuser/suser
    314376192 239372944 74421184 76% /suser

    ReplyDelete