SAP Knowledge Base Article - Preview

1963392 - In SQL Anywhere, how to determine if there are any locks in the system?


Executing a Statement at the database hangs or randomly takes much longer than normal.   How can we determine if this is due to locks and what connection or statement is blocking?



SAP SQL Anywhere (any supported versions)


SAP SQL Anywhere 16.0 ; SAP SQL Anywhere 17.0 ; SAP Sybase SQL Anywhere 12.0


KBA , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , How To

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.