Hi,

I need to monitor which database users select's data from an individual table. There is a vast anmount of SQL hitting the database, so capturing all SQL is not practical. Anybody know if/how I could achieve this ? This is a DB2 UDB v7.2 database running on windows 2000.

Any help appreciated.

Mike.

If you create a CONNECTION EVENT MONITOR , information about all applications will be captured at connect and disconnect time ...

If you parse it and load into a table , you can then get information at application level(including number of rows read) ... This may give a fair idea of what you want ...

Another option is to use db2 auditing, and capture data as and when connections happen ... This data can be loaded into a table using db2 facilites itself

HTH

Sathyaram