Results 1 to 3 of 3
  1. #1
    Join Date
    May 2011
    Posts
    27

    Unanswered: DB2 - How to get estimated value for: Transation Per Minute parameter for DB?

    Hi is there some easy way to find out what is transaction per minute value for the database? Should I use db2 get snapshot (if yes- what parameters to watch?)? We are using DB2 9.7 FixPack 0 on Linux

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    First, let me rant that being on Fixpack 0 is never a good thing. That is about 5 years old. Fixpack 9 came out in December.

    Second:

    Code:
    select snapshot_timestamp,
    db_conn_time,
    commit_sql_stmts,
    rollback_sql_stmts,
    timestampdiff(4,snapshot_timestamp-db_conn_time) as minutes,db_conn_time,
    (commit_sql_stmts+rollback_sql_stmts)/timestampdiff(4,snapshot_timestamp-db_conn_time) as transactions_per_minute 
    from sysibmadm.snapdb
    Andy

  3. #3
    Join Date
    May 2011
    Posts
    27
    Thank you very much this is great.
    It shows exactly as I can see from the last database restart.
    I hope this is relevant, many did not know for this.

    Thank you!!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •