Symptom
The following lock waits related to tables NRIV and NRIVSHADOW can be found in the application snap shots:
... X X ROW SAP<sid>.NRIV
Status : Lock Waiting ( ... seconds)
User Id : WF-BATCH
Wkstn :
Appl. : ptype BTC
Acc. Info : SAP<sid>
Lock Name : ...
Last SQL : SELECT * FROM "NRIV" WHERE "CLIENT" = ? AND "OBJECT" = ?
AND "SUBOBJECT" = ? AND "NRRANGENR" = ? AND "TOYEAR" = ?
OPTIMIZE FOR 1 ROWS WITH RS USE AND KEEP EXCLUSIVE LOCKS
... X NS ROW SAP<sid>.NRIVSHADOW
Status : Lock Waiting ( ... seconds)
User Id :
Wkstn :
Appl. : ptype DIA
Acc. Info : SAP<sid>
Lock Name : ...
Last SQL : INSERT INTO "NRIVSHADOW" VALUES( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
Read more...
Environment
SAP on IBM Db2 for Linux, UNIX, and Windows
Product
Keywords
Lock Wait, table, NRIV, NRIVSHADOW , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-SRV-NUM , Number Range Management , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.