Transactions count
Sauron asked how to count active transactions in a stored procedure, like MSSQL @@trancount. Paul Watson pointed to systrans in sysmaster. Sauron replied that it is based on systxptab and counts only transactions that changed data. He then said he solved it, without giving the method.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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
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 #
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 #
Thks All! I solved this problem. -- Sauron