RE: Tables locked
You need to query the systables to get the tblspace num (tblsnum)
use tblsnum for the table that is locked.
use your onstat -k and look for the tblsnum and look accross to the owner
column. do an onstat -u | grep 'address' (from onstat -k) this is the
address associated with the lock being held.
This will tell you the ses id that has the lock.
Paul J. Brais
Northrop Grumman Corp.
1 Northrop Ave.
Hawthorne, Ca. 90250
Phone: 310/332-3734
Pager: 310/249-1027
email: braispa@mail.northgrum.com
> ----------
> From: Peddi, Bala[SMTP:Bala.Peddi@fmr.com]
> Sent: Wednesday, July 01, 1998 6:42 AM
> To: 'xtarafa@cinet.es'; informix-list@iiug.org
> Subject: RE: Tables locked
>
> onstat -k
> onstat -u>
> Comapre Users threads in these outputs , YOu should know who is loking
>
>
>
> BALA PEDDI
> (617) 563-1949
> (bala.peddi@fmr.com)
>
> > -----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
>