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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.