RE: Potential Long transactions

The only point I would add is that the query assumes that sh_maxlogs
have been allocated.


-----Original Message-----
From: informix-list-bounces@xxxxxxxx
[mailto:informix-list-bounces@xxxxxxxx] On Behalf Of Jack Parker
Sent: Tuesday, 26 February 2008 11:54 PM
To: Mohit; informix-list@xxxxxxxx
Subject: RE: Potential Long transactions

Haven't looked at this thoroughly yet, but thought that I'd point out
that
you can get $ONCONFIG values (like LTXHWM) directly out of sysmaster.

select * from sysmaster:sysconfig where cf_name like 'LTX%'

cheers
j.

Sane ego te vocavi. Forsitan capedictum tuum desit.

-----Original Message-----
From: informix-list-bounces@xxxxxxxx
[mailto:informix-list-bounces@xxxxxxxx]On Behalf Of Mohit
Sent: Monday, February 25, 2008 8:07 PM
To: informix-list@xxxxxxxx
Subject: Potential Long transactions


Version: IDS 10

I have written below query to find out those transactions that could
be potential long transactions. Assuming 50/60 is high water mark
values:

select s.txid,r.owner, r.sid, scb.pid
from systxptab s, sysrstcb r, sysscblst scb
where (loguniq-logbeg)/(select sh_maxlogs
from sysshmvals) > 40/100 { catch when it's
over 40% }
and logbeg > 0 { I saw lot of transactions owned by informix that
have logbeg as 0 }
and s.owner = r.address
and r.sid = scb.sid;

Does this query look correct ? I didn't know how to get LTXHWM value
from sysmaster to hard coded the values. Any suggestion or
improvement ?
_______________________________________________
Informix-list mailing list
Informix-list@xxxxxxxx
http://www.iiug.org/mailman/listinfo/informix-list

_______________________________________________
Informix-list mailing list
Informix-list@xxxxxxxx
http://www.iiug.org/mailman/listinfo/informix-list

*******************************************************************
Everything about this email and its attachments, including potentially confidential components, is only for the eyes and ears of the persons to whom it has been addressed (i.e. the persons whose names appear in the "To" section of the email; however, those listed in sections "CC" and "BCC" may also consider themselves included in the group whose eyes and ears this email is for.). In the event that no physical, emotional or spiritual resemblance can be made between you and the intended recipients, you have been mistakenly or deliberately omitted from the email, someone has given it to you, or you have nicked it. If you're not supposed to have access to this email, please delete it, destroy it and deprive others from it. Oh, and let us know when you are done.
*******************************************************************

.

Relevant Pages

  • RE: Display queried records with Null values (null recordcount)
    ... tables related to Assets and Transactions tables in the query, ... since AssetID from tblAssets is a foreign ... The query would return multiple rows per account, ...
    (microsoft.public.access.gettingstarted)
  • Re: Potential Long transactions
    ... you can get $ONCONFIG values (like LTXHWM) directly out of sysmaster. ... I have written below query to find out those transactions that could ... have logbeg as 0} ...
    (comp.databases.informix)
  • RE: Display queried records with Null values (null recordcount)
    ... "...It might work as a single query with an outer join between the assets ... tables related to Assets and Transactions tables in the query, ... The query would return multiple rows per account, ...
    (microsoft.public.access.gettingstarted)
  • Re: User Select Top Value Percentage
    ... I don't think you can use a variable parameter with the TOP option can you? ... your suggestion of a ranking query gave me an idea of how it can be ... FROM Transactions AS T1 ...
    (microsoft.public.access.queries)
  • Re: Design Question - Accounts/Transactions
    ... The indexed view can't return anything about individual transactions. ... reason is that the indexed view contains only one row per account. ... you want an index that will help this query. ... One of the most important thing to get right is the clustered index. ...
    (microsoft.public.sqlserver.programming)