By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,017 Members | 951 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,017 IT Pros & Developers. It's quick & easy.

db2 transactions per second

P: n/a
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-
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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
Nov 12 '05 #2

P: n/a
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-
Nov 12 '05 #3

P: n/a
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
Nov 12 '05 #4

P: n/a
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
Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.