Oninit cdi / Archive
Talk to an expert →

monitor lock wait's on a database

Posted in 2000

Topics: General Discussion

Frode Solli — — source: Informix-list mailing list archive (1991-1998)

Hello ! Does someone know how to monitor all "lock wait's " on a informix database. Needed information: -number of lock wait's -duration of every lock wait's -on which table. INFORMIX-OnLine Version 7.23.UC2 -- Thanks in advance Frode Solli Alcatel Telecom Norway Tlf: +47 2263 7788 Fax: +47 2263 7725 e-mail: Frode.Solli@alcatel.no

↪ replying to Frode Solli
Art S. Kagel — — source: Informix-list mailing list archive (1991-1998)

onstat -g wai onstat -g spi Art S. Kagel Frode Solli wrote: > > Hello ! > > Does someone know how to monitor all "lock wait's " on a informix > database. > > Needed information: > -number of lock wait's > -duration of every lock wait's > -on which table. > > INFORMIX-OnLine Version 7.23.UC2 > > -- > > Thanks in advance > Frode Solli > > Alcatel Telecom Norway > Tlf: +47 2263 7788 Fax: +47 2263 7725 > e-mail: Frode.Solli@alcatel.no

Related threads