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
How to Add New Data File into Existing DBspace (Sybase IQ)
© 2018 ITsiti. All Rights Reserved
Powered by KEEM