topic Re: how to check if a dataset is used either by a process or a person in SAS Enterprise Guide

how to check if a dataset is used either by a process or a person

alepage — Wed, 26 Jan 2022 14:22:45 GMT

Hello,

A colleague of mine is using a sas program to update a particular dataset. But when the dataset is already used by either another process or user, we get the error message lock.

Is there a way to check if the dataset to be updated is free before updating it and if not how can we "liberate this file"

Regards

Re: how to check if a dataset is used either by a process or a person

Kurt_Bremser — Wed, 26 Jan 2022 14:35:39 GMT

On a UNIX (Linux) system, you can remove the file before writing the dataset.

Also on UNIX, the fuser command can be used to display the process(es) having an open file handle on a particular file.

Re: how to check if a dataset is used either by a process or a person

alepage — Wed, 26 Jan 2022 14:44:08 GMT

if we find that a process have an open file handle on a particular one, is there a way to liberate this file using a unix command and if so how to do that

Re: how to check if a dataset is used either by a process or a person

Kurt_Bremser — Wed, 26 Jan 2022 17:04:29 GMT

See my SASGF21 paper: https://communities.sas.com/t5/SAS-Global-Forum-Proceedings/How-to-Deal-With-Locked-Data-Sets-on-UNIX-systems/ta-p/726339