Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003
    Location
    India
    Posts
    7

    Unanswered: ISAM-113, Error 288 : How to unlock the table ,which is locked by another user.

    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.

  2. #2
    Join Date
    Dec 2003
    Location
    North America
    Posts
    146
    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>

  3. #3
    Join Date
    Nov 2003
    Location
    Mumbai, India
    Posts
    92
    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

  4. #4
    Join Date
    Dec 2003
    Location
    India
    Posts
    7

    Thumbs up

    Hi Mjldba/ Shriyan,

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


    Regards,
    Mathav.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •