Re: who deleted my trade?

[Rich Duzenbury <rduz-midrange@xxxxxxxxxxxxxxxxxxx>]

At 09:07 PM 10/13/03, murali dhar wrote:


> Iam suprised to knoe  one account 
> "TG699GIVEO47.WEY0000003L            200312  F"  was deleted from one of 
> biggest Transaction File TRNF1 Iam using ...
> is there any way/mechanism I can find out who deleted it among the 
> users?can did anyone face this type of problem earlier ,please  suggest me!
> Thanks,
>
> Murali.

Not unless there is a delete trigger that writes to a log, or a journal on 
the file.  Check the file description with DSPFD and see if there are any 
triggers or journals.  If there are triggers, examine their code to see if 
they save copies of deleted records into another table.  In such cases, I 
generally keep track of which user deleted the record.  In the case of a 
journal, any kind of add, change or delete will generally be listed along 
with the userid.

It could be that the program that allowed the delete might write to some 
kind of log file.  You might check the code of the program you suspect was 
used to delete the record.

If you are concerned about such happenings in the future, add a trigger or 
journal of your own if your circumstances permit.

Regards,
Rich