Tracking sensitive table access
How can I track the number of Read's users perform on specific tables on an iSeries?
Software/Hardware used:
Software/Hardware used:
ASKED:
May 8, 2009 4:30 PM
UPDATED:
May 10, 2009 1:03 PM
Answer Wiki:
Journalling can include Open/Closes - allowing you to capture access to
////////////////////////////////////////////
You can use DSPFD and you will find # of logical reads and # of physical reads. There is Statistics for data activity and access path activity.
There is a way to restart the statistics but I can't find how.
Regards,
Wilson
To see all answers submitted to the Answer Wiki: View Answer History.
In this case, I’m not concerned with exactly which records are read, but rather how many are read. And that, I think, is the problem with tracking the number of opens and/or closes. I can tell a table was accessed, but I can’t tell how much was pulled (ie are they looking up a customer, or are they pulling a customer list?)
You can add a read trigger the each table, it would call an RPGLE program whenever a record was called. It passes user info and the record which could log the access by record to a database file.
Phil