Re: Monitoring lock tables

Mauro wrote: > > Informix 7.24 UC1 > > How Can I see the lock tables (just in this moment) in the data base. > Is possible to monitoring to level lock of rows in the lock table. How Can > I? > I can see tables with: > > select * tabname from syslocks> > but I don't know if the tables are lock to level of rows or level of table. > I want to know if I can see the lock row of the table and if is ok the > system table syslocks to see the row locks. If the rowidlk column of the syslocks VIEW is zero (0) the lock is a table level lock. Otherwise if the keynum column is non-zero it is an index key node lock, else it is a row or page lock depending on the table's locking mode. Art S. Kagel