Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

sap table locks

Hi Every body this is a strage issue we have in production system .

each time wtih different sap tables like ADR2 or LIKP .., there migh be an issue with custom code that running as background jobs , we could not trace which program is locking these table and there is program that kills all jobs that are waiting for this table .

I would like to know which program is causing this issue , unfortunatly I only have very limited information .

like PID , SID , and some times user name . but not the job name .

can we able to find the job name by PID or SID and by the server name .

I will appreciate your help in this regards.

**Detail of Lock Processed**

SIDW: 773

SIDH: 2289

ID1: 1724296

Holderprocess: 16119

HolderPID: 23576

WaiterPID: 5806

Holdergranttime: 1245

Waitergranttime: 1191

Objectname: LIKP

H_SPID: 23576

W_SPID: 5806

ROW_ID: 27522000.4000.5150

Srinu. K

Former Member
Not what you were looking for? View more on this topic or Ask a question