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

Share this article :


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


1. Check the lock status and connection ID.

Lock Status Sybase IQ


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