Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367

    Unanswered: transaction info

    Questions:

    How to find the following information in v9.5:

    1. The the number of transactions per hour.
    2. The average response time per transaction.
    3. The average and peak number of "users".
    4. The average and maximum size of the transactions


    I'm not exactly sure what they mean by number of users and size of transaction (I guess number of connections / number of statements per UOW?). I think this person has Oracle background.

    I'm sure I can get some info from db2 snapshots. Is there any other way of getting this info? Some tool (3rd party)?

    Thanks

  2. #2
    Join Date
    Jun 2009
    Posts
    272
    I think foglight does that but its really slow and has lot of bugs. I am not sure if tivoli also has the above functionality

  3. #3
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    Bella, doesn't db2pd report some of those variable? or at least can be used to extract it.
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1

  5. #5
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by db2girl View Post
    1. The the number of transactions per hour.
    2. The average response time per transaction.
    3. The average and peak number of "users".
    4. The average and maximum size of the transactions
    You really need more context to answer that. DB2 may have a different concept of transactions (UOW) than the application that connects to it. What is considered a single transaction from the application standpoint may generated multiple UOWs, and vice versa. Ditto response time per transaction.

    Number of "users" is even more confusing. In most cases you have some sort of middleware sitting between the application and the database, and DB2 only sees one "user" (authorization ID) and a bunch of constantly open connections coming from a pool. On the other end of the pipe it can translate into thousands of application "users" "connecting" and "disconnecting" all the time, and there is no way DB2 even knows about that.

  6. #6
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Thank you. I see DBI has some monitoring tool as well.

    I got some additional clarification from the customer and realized that they have a federated env. So, it's with the federation team for now.

Posting Permissions

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