Re: Monitoring lock tables

Posted in 1998

Leonid Vorontsov — Tue, 01 Sep 1998 16:29:02 +0300 — source: Informix-list mailing list archive (1991-1998)

Art S. Kagel wrote: > > > 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 OK, but syslocks view don't have all locks in the databases. There is syslocktab table in sysmaster database, but unfortunately this table is undocumented. Explain columns in this table, please. And write an SQL statement for monitoring all locks with session, table, lock type if You can. Leonid.