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-

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

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-

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

In article <3mgn0fF171h7oU1@individual.net>, Serge Rielau
(srielau@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