Hi:

I need to know hoy many transactions by day and by table in prodution instance i have.

This in DB2 UDB v 8.1, on Windows 2003 server.

Any script or suggestion wellcome.

Thanks a lot.

If by transactions you mean units of work, I don't believe it's possible, but you can see statistics of table access by running "db2pd -db dbname -tcbstats".

select date(timestamp(AUDTIME)),count(distinct app_id)
from dba.audit_checking
where date(timestamp(AUDTIME)) > current date - 10 days
group by date(timestamp(AUDTIME)) order by 1

1 2
---------- -----------
10/26/2009 21638
10/27/2009 21249
10/28/2009 20470
10/29/2009 22510
10/30/2009 20724
10/31/2009 20629
11/01/2009 21615
11/02/2009 19768
11/03/2009 21308
11/04/2009 17538

10 record(s) selected.


select substr(object_schema||'.'||object_name,1,30),count (distinct app_id)
from dba.audit_checking
where date(timestamp(AUDTIME)) > current date - 10 days
group by object_schema||'.'||object_name order by 1 fetch first 10 rows only

1 2
------------------------------ -----------
A.B 3
A.C 1
AAA.TEMP 17
ADC.TEMP 17
COABC.COATA10_URC 16
COABC.COATZ10_URC 16
COABC.COATZ30_URC 16
CPE12345.LLLLMARKUP 17
CPE12345.DDDBRIIDXREF 17

10 record(s) selected.

Thanks a lot for the answers