number of transactions

hi, how can i know the number of transactions on a database in a given period (for example 1 day) ???

__toto wrote: > hi, > how can i know the number of transactions > on a database in a given period (for example 1 day) ??? > > Onstat -p will show you, in the commit & rollback columns how many transactions were committed and/or rolled back since startup or since the last time onstat -z was run to zero these stats. You can get the same information from the SMI table sysmaster:sysprofile and if you periodically copy data from sysprofile to another table which includes a timestamp you can develop historical values. Art S. Kagel