How to find the who locked the row(s)?

Posted in 1997

rambabu@sprynet.com — Wed, 04 Jun 1997 13:21:27 -0600 — 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 -------------------==== Posted via Deja News ====----------------------- http://www.dejanews.com/ Search, Read, Post to Usenet