SAP Knowledge Base Article - Preview

2981685 - DB6: Lock waits on tables WITH CS

Symptom

Sometimes we could find lock waits happen in the system, if we collect and check and result of db6util, we could find
following log info on related lock waits:

Status :Lock Waiting (575 seconds)
User * : <User_Name>
Wkstn : CNLFKUX013P
Appl. : ptype DIA
Acc. Info : SAPLYECEJ_INTERFACE_CBXXHC
Lock Name : 000C364000000009F1F0001652
Last SQL : SELECT * FROM "<Table_Name>" ORDER BY "OLTPSOURCE" WITH CS
-- OPTLEVEL( 5 ) -- QUERY_DEGREE( 1 ) ... -- HASH_VALUE( 659517485 )
...

Status :Lock Waiting (934 seconds)
User * : <User_Name>
Wkstn : CNLFKUX013P
Appl. : EG30
Acc. Info : SAPLE30D
Lock Name : 000C364000000009F1F0001652
Last SQL : SELECT * FROM "<Table_Name>" ORDER BY "OLTPSOURCE" WITH CS
-- OPTLEVEL( 5 ) -- QUERY_DEGREE( 1 ) ... -- HASH_VALUE( 659517485 )
...


Read more...

Environment

SAP on IBM Db2 on LUW Database

Keywords

Lock waits, Lock Waiting, WITH CS, CUR_COMMIT, DB6 , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , 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.