Time the locks

Version: IDS 10

I asked this question in earlier post, and after that I tried to look
at CDI archives but didn't get the answer. I want to know if there is
any way to find out which lock is being held over certain period of
time on certain resource. I have below query to find out about the
locks:

select sysdatabases.name database, -- Database Name
syssessions.username, -- User Name
syssessions.hostname, -- Workstation
syslocks.owner sid -- Informix Session ID
syslocks.tabname
from syslocks, sysdatabases , outer syssessions
where syslocks.tabname = "sysdatabases" -- Find locks on
sysdatabases
and syslocks.rowidlk = sysdatabases.rowid -- Join rowid to
database
and syslocks.owner = syssessions.sid -- Session ID to get
user info
order by 1;
.

Relevant Pages

  • Re: Zonealarm / Email
    ... > have, namely the ID lock, pop-up blocker, and active spyware monitor. ... Usually, it's very difficult for lusers to handle an IDS, and they're ... First, ID lock is completely useless, if data is send out encoded or even ...
    (comp.security.firewalls)
  • Re: Let me be the first
    ... Lukas Barton said: ... Which version of IDS does this refer to? ... UPDATE TABLE table1 SET col1=10 WHERE col2=15; ... I can't see what why those rows should lock each other. ...
    (comp.databases.informix)
  • Re: Monitor Locks
    ... For a given table how can I find out which process is holding lock. ... If the lock is row level, ... from syslocks, sysdatabases, outer syssessions ...
    (comp.databases.informix)
  • Re: Time the locks
    ... I have below query to find out about the ... from syslocks, sysdatabases, outer syssessions ... Is this query correct? ... lock associated with that table. ...
    (comp.databases.informix)
  • Monitor Locks
    ... For a given table how can I find out which process is holding lock. ... If the lock is row level, ... from syslocks, sysdatabases, outer syssessions ...
    (comp.databases.informix)