Data set locking issue on EG4.2.

CarlW · Posted 10-11-2011 03:53 PM

Currently I have a sas job running each Monday 5:00am by using window schedule task, it failed each time due to a lock is not availabe for data set reason, the data set got locked is totally random. I tried get IT personnel to kill all sas session before the end of week and no background application is running during that period. Still the error prompt out unexpectedly.

Anybody had similiar issue and how did you solve this? your input is highly appreciated!

NN · Posted 10-12-2011 06:00 AM

Hi,

There is a Filelocks= option that can be used in the libname statement when defining a libref . I am not sure if that will help your case but you can definetely look into it.

twocanbazza · Posted 10-12-2011 05:26 PM

Where does the data reside, locally or on a SAN etc? Are there Backups running?

CarlW · Posted 10-13-2011 09:29 AM

Thx for you guys help, the data locates in the metadata server, no backup running during that period. right now I'm thinking is that possible filesystem related, eg integrity check.

Doc_Duke · Posted 10-16-2011 11:09 AM

Have you searched the support.sas.com for the error message. This one may help

http://support.sas.com/kb/36/803.html