Tracking sensitive table access
Home > IT Answers > AS/400 > Tracking sensitive table access
LarryH60
15 pts.
0
Q:
Tracking sensitive table access
AS/400 tables, AS/400 journaling, PCI DSS
How can I track the number of Read's users perform on specific tables on an iSeries?
ASKED: May 8 2009  4:30 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
WilsonAlano
2005 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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
Last Answered: May 9 2009  4:18 PM GMT by WilsonAlano   2005 pts.
Latest Contributors: Philpl1jb   24610 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

LarryH60   15 pts.  |   May 8 2009  7:51PM GMT

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?)

 

Philpl1jb   24610 pts.  |   May 10 2009  1:03PM GMT

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

 
0