User ‘another user’ has the row in ‘ITSITI’ locked



Share this article :

Symptom

You are altering a table in the Sybase IQ but encountered with below error,

Could not execute statement.

User 'another user' has the row in 'ITSITI' locked
SQLCODE=-210, ODBC 3 State="40001"
Line 1, column 1

Lock Table Sybase IQ

Solution

1. Check the lock status and connection ID.

Lock Status Sybase IQ

sp_iqlocks

2. Once you get the connection ID from above command, execute below command to drop the user connection from the Syabase IQ database.

drop connection [CONNECTION-ID]

Related posts

Types of Database Space in Sybase IQ
How to Create Technical User in SAP IQ Cockpit
How to Drop Connection in Sybase IQ
© 2017 ITsiti. All Rights Reserved
Powered by KEEM