Transactions count – Informix Archive

Sauron — Fri, 10 Oct 2003 12:02:30 +0300 — source: Usenet: comp.databases.informix

Hi! In a stored proc I need to determine a count of active transactions... How I can do it? (for example, in MSSQL: @@trancount) -- Sauron

↪ replying to Sauron

Paul Watson — Fri, 10 Oct 2003 13:21:02 +0100 — source: Usenet: comp.databases.informix

Look at systrans in sysmaster, that will give you the number of open transactions that have done some work Sauron wrote: > > Hi! > > In a stored proc I need to determine a count of active transactions... > How I can do it? (for example, in MSSQL: @@trancount) > > -- > Sauron -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #

↪ replying to Paul Watson

Sauron — Fri, 10 Oct 2003 15:46:21 +0300 — source: Usenet: comp.databases.informix

Sysmaster:systxptab (from this table systrans take your data) will give you only the number of transactions that changed object of database (insert, update, delete)...:( -- Sauron "Paul Watson" <paul@oninit.com> ???????/???????? ? ???????? ?????????: news:3F86A42E.C5ED0170@oninit.com... > Look at systrans in sysmaster, that will give you the number > of open transactions that have done some work > > > -- > Paul Watson # > Oninit Ltd # Growing old is mandatory > Tel: +44 1436 672201 # Growing up is optional > Fax: +44 1436 678693 # > Mob: +44 7818 003457 # > www.oninit.com #

↪ replying to Sauron

Sauron — Fri, 10 Oct 2003 17:26:25 +0300 — source: Usenet: comp.databases.informix

Thks All! I solved this problem. -- Sauron