topic Data set locking issue on EG4.2. in SAS Enterprise Guide

Data set locking issue on EG4.2.

CarlW — Tue, 11 Oct 2011 19:53:47 GMT

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!

Data set locking issue on EG4.2.

NN — Wed, 12 Oct 2011 10:00:52 GMT

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.

Data set locking issue on EG4.2.

twocanbazza — Wed, 12 Oct 2011 21:26:53 GMT

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

Data set locking issue on EG4.2.

CarlW — Thu, 13 Oct 2011 13:29:55 GMT

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.

Data set locking issue on EG4.2.

Doc_Duke — Sun, 16 Oct 2011 15:09:30 GMT

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

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