Hello all,

Is there way in DB2 to turn on logging of all SQL that gets executed against a particlular database/table? In Oracle it's called 'auditing', I believe.

Thanks a lot
James

this is also called audit in DB2 - although this generates lot of data
monitor statement can be activated to capture dynamic statements
or see how index advisor collects workload...
or use query patroller... many possibilities todo the same..

Thanks very much! Very helpful

Best,
James