Row locks
Posted in 1992
Clay Irving — — source: Informix-list mailing list archive (1991-1998)
We've written a program that updates several rows in a table. We assumed that we may run into locking problems since these rows may be updated by another program. So... We test for the lock and if we can't lock the row, we issue an error message to inform the user that one of the rows can not be locked -- someone else has it. Now, how can we find who's locking the row? Tbmonitor shows me users with locks, but it doesn't indicate what the lock is... There has to be a better way?... -- Clay Irving Personal: clay@panix.com {...uunet, cmc12}!panix!clay New York, New York Work: clay@garpac.com {...uupsi3, 4gen}!garpac!clay --