Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Posts
    7

    Unanswered: How to identify the thread

    We are using informix 9.40 FS2.

    When i am trying to re-index table bid107, I am getting message table locked.
    Is there any way by which i will be able to identify the thread which is having transaction on this table and can be killed thru onmode -z command so that the lock will be released.

    I observed that all locks are of type shared thru onstat -k command.

    Regards

    JJosh

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    Hi Jjosh,

    Please run onstat -k|grep tblsnumber of table (hex(partnum)), next onstat -u|grep column "owner". Then print session ID.

    Gustavo.

Posting Permissions

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