lock is not available

[GokulShivananda]

I observe that a table from a library is locked by a process. I ensured all the batches or the sessions from the application are closed and just launched a batch, but unfortunately I see a particular table is getting locked without a reason!.

I have Stopped all the SAS services and started it many times. Didn't work!!

So I logged in Unix and killed the process ID which was locking my table and the batches were successful,

this solution was okay for 30 minutes but the issue appears !! I have SASShare  in my environment.

How would I know what is this process and how to resolve this ?

Thank you

Error Msg:

MPRINT(_M_SET_BOP_RESERVES):   modify CES0094.SIM_NET_PGN_RSK_LI_Q22018 (cntllev=rec) key=XPKSIM_NET_PGN_RSK_LI_Q22018 ;
ERROR: A lock is not available for CES0094.SIM_NET_PGN_RSK_LI_Q22018.DATA.
ERROR: Lock held by process 16973856.

Regards,

Gokul

[Kurt_Bremser]

A ps -fp 16973856 will show you details about the process responsible. "Climbing up" the process tree along PPID will help you determine where it came from.

[GokulShivananda]

Thank you,

Yes I did that but it is pointing to Object Spawner!!

Please Find the attachment.

Any pointers.. ?

Regards,

Gokul Shivananda

[Kurt_Bremser]

In SAS Management Console, look for a server definition for 

A5L1RGTE.AU000005

It's most probably a workspace server, which means you'll get the user-id from the ps output, so you have an avenue for investigation.