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.
SAP Knowledge Base Article - Preview