[jjosh]

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

[gurey]

Hi Jjosh,

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

Gustavo.