topic Re: Timeout for locks on objects in SAS EG in SAS Enterprise Guide

Timeout for locks on objects in SAS EG

HULK — Thu, 07 Sep 2017 15:50:03 GMT

Hi!

How can i set timeout for locks on objects (for example: tables) in EG.

My case: i opened a table from some library in EG, now i see the content of the table. Then i do nothing and see, that this table close about 40-50 minutes and lock on this object no longer exists. If i try to re-write this object from another session, when this table open in my current session - i have an error:

a lock is not available for MY.TABLE.

Lock held by proccess ****.

I need to know, on which parametres depends the time of blocking on the object?

Thanks!

P.S. Sorry for my English)

Re: Timeout for locks on objects in SAS EG

paulkaefer — Thu, 07 Sep 2017 16:15:41 GMT

If you close the table, the lock should disappear. If you're in EG, you can go to Tools >> View Open Data Sets... and see if it's still open.

The only other thing I could find that might be useful is this knowledge base article talking about how you can set and wait for locks.

Re: Timeout for locks on objects in SAS EG

paulkaefer — Thu, 07 Sep 2017 16:16:28 GMT

To add to my post, this paper dives into locks.

Re: Timeout for locks on objects in SAS EG

nhvdwalt — Fri, 08 Sep 2017 04:27:32 GMT

Not sure if it will help, but have a look at this setting in Enterprise Guide: Tools >> Options >> Data >> Performance >> Close data grid....

Re: Timeout for locks on objects in SAS EG

Patrick — Sat, 09 Sep 2017 13:00:22 GMT

@HULK

In EG set the setting to something below 10 minutes.

In your code use:

options filelockwait=10;

This way your first EG session should release a table after less than 10 minutes but the code in your 2nd EG project will wait for up to 10 minutes for a lock on the table to be released before it fails.