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

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

Bella, doesn't db2pd report some of those variable? or at least can be used to extract it.

What's new in Optim Performance Manager Extended Edition for DB2 for Linux, UNIX, and Windows

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.

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.