Re: Tables locked
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
At 12:16 PM 7/1/98 +0200, you wrote:
>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
>
>
>
Bindu Nair
Endura Software Corporation (115 NE, 100th Street, Seattle,WA)
5001, LBJ Freeway, Suite 700 Email: bindu.nair@enduracorp.com
Dallas TX 75244 Off : 1-800-333-4436 (x -6547)
_________________________________________________________________