db2 transactions per second

[Jurgen Haan]

Hey there.
I want to keep track of the transactions per second on a db2 udb luw v
8.1.7. How do I realise this? This would be the case on our production
server and I really don't like the Statement monitor, because of the
performance hit. So, can it be done? And can this be done using the DB2
CLI? So I can use the output in shell scripts.

-R-

[Anton Versteeg]

Jurgen Haan wrote:

Hey there.
I want to keep track of the transactions per second on a db2 udb luw v
8.1.7. How do I realise this? This would be the case on our production
server and I really don't like the Statement monitor, because of the
performance hit. So, can it be done? And can this be done using the DB2
CLI? So I can use the output in shell scripts.

-R-

Perhaps
get snapshot for database on xxxxx

It will show rows inserted/deleted etc. commits
and a lot more. You would have to process the output though.
--
Anton Versteeg
IBM Netherlands

[Jurgen Haan]

Anton Versteeg wrote:

Perhaps
get snapshot for database on xxxxx

It will show rows inserted/deleted etc. commits
and a lot more. You would have to process the output though.

I just took a look at the snapshot.
the number of commits, is it a total since activation or is there some
timespan? The processing isn't a problem.
store timestamp1+commit count1
wait
store timestamp2+commit count2

commit count2-commit count1 / timestamp2-timestamp1 = commits/<time unit>

thanks for the feedback, I will imeplement it.

-R-

[Serge Rielau]

Jurgen Haan wrote:

Anton Versteeg wrote:

Perhaps
get snapshot for database on xxxxx

It will show rows inserted/deleted etc. commits
and a lot more. You would have to process the output though.

I just took a look at the snapshot.
the number of commits, is it a total since activation or is there some
timespan? The processing isn't a problem.
store timestamp1+commit count1
wait
store timestamp2+commit count2

commit count2-commit count1 / timestamp2-timestamp1 = commits/<time unit>

thanks for the feedback, I will imeplement it.

-R-

AFAIK the snapshot counters are always relative to the start of the
monitor switch/db2start.
Another option might be "db2pd -transactions" db2pd is DB2's version of
Informix onstats.

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

[Gert van der Kooij]

In article <3m*************@individual.net>, Serge Rielau
(sr*****@ca.ibm.com) says...

Another option might be "db2pd -transactions" db2pd is DB2's version of
Informix onstats.

I tried it with DB2 PE FP9 but ran into an error. A error message was
displayed:

db2pd.exe - Unable to locate component
This application has failed to start because DB2DIAG.dll was not
found. Re-installing the application may fix this problem.

I installed FP9a to be sure it wasn't a local issue but the problem
still remains. I hope it will be fixed with FP10.

Kind regards, Gert