That information is not normally stored in the stats tables. you can do one
of two things:

1) run a table/tablespace event trace and look at the output. It will be
for that time duration that you run the trace
2) Turn on the audit facility and set the paramaters so that you can see
some of that info. (you wont get all you want)

The other alternative is to get Query Patroller, it will show the
different kinds of activity on the tables and it is all stored in Query
Patroller
system tables.

Dan Callahan IT Specialist
603-472-4121 t/l 525-4121
[Email Address Removed] [Email Address Removed]
Pedro Miguel
Gonçalves
<[Email Address Removed] To
l-seguros.pt> <[Email Address Removed]
cc
03/17/2004 07:39
AM Subject
How to take some stats about table
updates,adds,I/Os on DB2 CATALOG
TABLES.










Hi fellow DB2 DBA's,


I was asked to show stats based on work commited on the tables.
Like I/O's , Number of Updates, Number of field ADD's, table Accesses.

Are these informations on DB2 Catalog Tables?

Where can I find those stats?

Pedro Gonçalves.

DB2 & UDB email list listserv db2-l LazyDBA home page