Skip to Content

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

Locks in NRIV Table

Hi ALL


I am new to production support while monitoring the data loads BASIS find the locks in BW system.

We got more alerts for Row lock contention IN BW production .Kindly help me understanding and resolving the issue.

SQL:

SELECT /*+ FIRST_ROWS (1) */ "FROMNUMBER", "TONUMBER", "NRLEVEL" FROM "NRIV" WHERE "CLIENT"=:A0 AND "OBJECT"=:A1 AND "SUBOBJECT"=:A2 AND "NRRANGENR"=:A3 AND "TOYEAR"=:A4 FOR UPDATE


please suggest the solution to avoid the above locks.


Regards,

Jagadeeshwar.

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