Re: Time the locks

On Feb 25, 9:18 am, jpren...@xxxxxxxxx wrote:
On Feb 24, 2:20 pm, Mohit <mohitanch...@xxxxxxxxx> wrote:





On Feb 23, 10:24 pm, Mohit <mohitanch...@xxxxxxxxx> wrote:

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              --InformixSession 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;

After little bit of work and pieces of information I got, I have this
query. Is this query correct ?

select r.sid,r.address,l.owner,
dbinfo('utc_to_datetime', l.grtime),dbinfo('utc_current')-l.grtime,
s.pid,s.hostname, dbinfo('dbspace', l.partnum),st.tabname, s.progname
from
systxptab t,sysrstcbr,syslcktab l,flags_text f,sysscblst s,
systabnames st
where dbinfo('utc_current')-l.grtime > $SECS_OLD and t.address =
l.owner
and r.address = t.owner and f.tabname = "syslcktab" and l.type =
f.flags
and s.sid = r.sid and r.address = s.address and st.partnum =
l.partnum;

This query looks correct, but when I run, I don't get any rows. If I
remove r.address = s.address then it seems to be working, but I added
r.address = s.address so that I get only specific information about
lock associated with that table.

r.address will never = s.address

r.address is the address of the rstcb, s.address is the address of the
scb, they are two different structures.

I'm not sure what you mean when you say you added it so that you get
only specific information about lock associated with that table...umm
which table?  Are you trying to find locks held on a certain table?- Hide quoted text -

- Show quoted text -

So if I rework above query would I get information about only those
locks that are over certain age:

select r.sid,r.address,l.owner,
dbinfo('utc_to_datetime', l.grtime),dbinfo('utc_current')-l.grtime,
s.pid,s.hostname, dbinfo('dbspace', l.partnum),st.tabname, s.progname
from
systxptab t, sysrstcb r,syslcktab l,flags_text f,sysscblst s,
systabnames st
where dbinfo('utc_current')-l.grtime > $SECS_OLD and t.address =
l.owner
and r.address = t.owner and f.tabname = "syslcktab" and l.type =
f.flags
and s.sid = r.sid and st.partnum =
l.partnum;
.

Relevant Pages

  • RE: Xlocking with a select statement
    ... named query expression, order clause, update clause, lock option ... A result table or the underlying base tables are updateable if the query ... A lock can be requested for the ...
    (microsoft.public.sqlserver.programming)
  • Its working :-)
    ... The query results that I get is without using the single quotes. ... Each test REQUEST has a Lock, Key and Pattern Combination (sometimes ... "Ken Sheridan" wrote: ...
    (microsoft.public.access.queries)
  • RE: Using Multiple Combo Boxes as Criteria for Query
    ... I Believe the query works the way it is written to, ... In my results table I wanted to track which lock they were using, ... "Ken Sheridan" wrote: ... In such circumstances I'd usually leave the bound column for Null, ...
    (microsoft.public.access.queries)
  • Re: A new proof of the superiority of set oriented approaches: numerical/time serie linear interpola
    ... reduces the number of passes through the data required to answer a query. ... What kind of lock? ... The reduction in execution time improves response time. ... by a "sufficiently intelligent" optimizer. ...
    (comp.databases.theory)
  • NETWORKIO?!?!
    ... I have a database here which is used for purchasing/stock etc. ... The queries return all ... if a query is run, this lock is exhibited. ...
    (microsoft.public.access.queries)