topic LOCK (Retrieve SYSUSERID instead of JOB_ID) - how to in SAS Enterprise Guide

LOCK (Retrieve SYSUSERID instead of JOB_ID) - how to

Krohn — Wed, 01 Jun 2016 01:14:28 GMT

ERROR: Lock held by process 346

I'd like to know directly who is using the Dataset and not the JOB_ID

Is it possible to retrieve like: "Lock held by user 1234" (that &SYSUSERID macro variable)??

SAS Enterprise Guide 6.1
X command unabled

Thanks!

Re: LOCK (Retrieve SYSUSERID instead of JOB_ID) - how to

LinusH — Wed, 01 Jun 2016 05:46:23 GMT

With the pid you can look up the user by using OS tools/commands.
What is the underlying requirement?
There have been numerous threads discussing this is, sugest that you browse these.
Bottom line: if you have frequent problems with locking switch to a multi user data store, or implement a script that kills all SAS processes prior to batch processing.

Re: LOCK (Retrieve SYSUSERID instead of JOB_ID) - how to

Kurt_Bremser — Wed, 01 Jun 2016 06:04:05 GMT

You will need to use OS tools enabled to do this.

To do it manually, log on to the server with ssh and use something like ps -ef|grep processnumber

To do it automatically in SAS, you MUST have XCMD enabled.

My preferred method to avoid this is to physically delete the target dataset file using OS commands (works on UNIX like a charm) before writing it.