user activity tracking

[nnswain]

given a user id and date Can i able to track the add/delete/changes made by the user during the period?
pl.help.

 

[SallyWhite]

Can't do this via any JDE means, although the F0101A keeps track of some activity to F0101 only. You have to have IBM journalling turned on in order to collect the type of info you want. If you have the disk space, this is an excellent, low-overhead means of being able to determine the who/what/when of any data change after the fact. If you decide to do this, be sure to study the journal receiver size and journal management parameters to prevent issues later when journal receivers fill up. There are also SAVLIB/SAVOBJ and restore considerations. Check the IBM iSeries website for more info.

 

[JWalker81]

Although its usefulness is limited, you could look at the menu history
for that id and date in question, see what programs the user was in and
then query the files that can be changed by those programs for the
specific user id & date (User & UPMJ fields). It won't tell you
specifically what data was changed, but it will tell you the user
changed something on the record. If you don't find any records with the
name and date, don't feel too confident. Another user might have
updated the record since then. Not all programs, especially custom
programs, are written to update the user and/or date updated fields.

A journal on the file is the only way to be 100% certain that a change
to data was made by a person. Depending on which view(s) the journal
takes will determine if you will be able to tell exactly what data was
changed (or deleted). Even if you have before and after images on your
journal, journal receivers only hold so much data. Depending on how
your shop is setup regarding number of active receivers, how much data a
receiver holds before it rolls over and how long receivers are kept on
your system, you may not be able to get the data you are looking for
even though your files are journaled. Few shops journal all files.

JW


J Walker
JDE A7.3 cum(mongrel)

 

[tidiehl]

You can use Database Audit Manager to track user changes for specific
fields in selected files. The database impact is less than journaling
because you only need to track the fields you are concerned about.