Hi All,
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.

Try this

onstat -u & look for the sessid associated with your user name.

if your want to look at the last SQL you were executing, key in
onstat -g sql <sessid>

to kill this session (like kill -9 on a UNIX box) key in
onmode -z <sessid>

Hi,

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.

select unique
dbsname db,
tabname table,
case
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"
else
"unknown lock type"
end lock_type,
lpad(owner,5) ses_id,
lpad(waiter,5) wait_id
from sysmaster:syslocks
where tabname != 'sysdatabases';

Regards,
Shriyan

Hi Mjldba/ Shriyan,

I followed user suggestion, now the table is unlocked.
Thank you for providing me such a accurate support.


Regards,
Mathav.