Posting from the Informix-list
Hi,
You can go to sysmaster database and run the follwing SQL to get the owner
select owner from syslocks
where tabname = <Your table name>
Now the user can be found out by giving the command onstat -u|grep <owner>
in the command line. i.e the sessid in the onstat -u command will have the
owner which you found from the above SQL
Bindu Nair
Endura Software Corporation
> -----Original Message-----
> From: Xavier Tarafa [SMTP:xtarafa@cinet.es]
> Sent: Wednesday, July 01, 1998 6:17 AM
> To: informix-list@iiug.org
> Subject: Tables locked
>
> Hi,
>
> I'm working with Informix dbaccess. I've noticed that one of the tables
> on the database I'm working with it's locked.
>
> How can I know who is locking the table?
>
> Thanks,
>
> Xavi