Unanswered: ISAM-113, Error 288 : How to unlock the table ,which is locked by another user.
I am using InformixDS version 9.21, while altering a Table my
DBaccess application got closed, And afterwards if I try update the table I am getting ISAM 113 error.
If I try to Unlock the table I am gettting an error 288 : Stating that the table is locked by another user.
Can you please help me in this regard to unlock the table.
Below is a SQL statement which shows more information about the locked objects. Five columns shown are database name, table name, lock type, owner of the lock (session id) and waiting session id if any for the locked object.
when type="S" then "shared lock"
when type="IS" then "intent shared lock"
when type="SIX" then "shared intent excl lock"
when type="XS" then "shared key value by RR"
when type="IX" then "intent excl lock"
when type="X" then "exclusive lock"
when type="XR" then "excl key value by RR"
when type="U" then "update lock"
when type="B" then "byte lock"
"unknown lock type"
where tabname != 'sysdatabases';