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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.