How can know the transaction per second

[richardshen]

What command should should I use get the load on DB2?
SNAPSHOT?
EVENTMONITOR?

[Erik Hendrix]

Exactly what load do you want to know? If you want to know
transaction/second, then I would use the event monitor since through that
you will know for sure. With the snapshot, you can have for example 400
transactions in 10 seconds but you take a snapshot every minute. Thus the
calculation would come down to:
transactions/second
400/60 = 6.66 transactions/second through the snapshot information. But
since out of the 60 seconds, you only had 10 seconds of work and 50 seconds
idle, your true throughput would be:
400/10 = 40 transactions/second.

Hope this helps.
<ri*********@canada.com> wrote in message
news:7c**************************@posting.google.c om...

What command should should I use get the load on DB2?
SNAPSHOT?
EVENTMONITOR?

[Sean McKeough]

Erik is correct, however snapshot monitor is much cheaper than running a
transaction evmon. The info you're looking for is from the database
snapshot, and is basic data (means it's collected as part of basic
processing). If you have an environment where you're just looking at rax
tx numbers over time, consider using the database snapshot.

Erik Hendrix wrote:

Exactly what load do you want to know? If you want to know
transaction/second, then I would use the event monitor since through that
you will know for sure. With the snapshot, you can have for example 400
transactions in 10 seconds but you take a snapshot every minute. Thus the
calculation would come down to:
transactions/second
400/60 = 6.66 transactions/second through the snapshot information. But
since out of the 60 seconds, you only had 10 seconds of work and 50 seconds
idle, your true throughput would be:
400/10 = 40 transactions/second.

Hope this helps.
<ri*********@canada.com> wrote in message
news:7c**************************@posting.google.c om...

What command should should I use get the load on DB2?
SNAPSHOT?
EVENTMONITOR?