How to get Record locking information?

Posted in 1997

"Vijay R. Anisetti" — 4 Jun 1997 13:13:21 -0400 — source: Informix-list mailing list archive (1991-1998)

Hai! guys, here is the situation: hardware/OS ver : HP 9000/800 HP/UX 10.10 Informix Engine : 7.12 UC3 Question : Given a database, table name, rowid (or some unique key value), Is it possible to know who has locked which record and when (asking for more)? if yes, Are there any scripts/utilities available which provide THIS information? What I know already : I have checked the tables syslocktab, syslcktab, syslocks in SYSmaster database and could not really map the info. available to the requirement mentioned above. Your comments, suggestions or solutions will be appreciated. Vijay R. Anisetti