SAP Knowledge Base Article - Preview

2778990 - DB6: Lock waiting on table NRIV and NRIVSHADOW

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

SAP ERP 6.0

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.