Identifying who deleted records - trigger programs

Hi ...

Savvy auditors typically have another problem with triggers ... they can be turned
on and off "without a trace." If a change happens while the trigger is off, the change
is not observed.

We built an audit solution for the pharmaceutical industry; they obviously have an exceedingly
high need to "see" any changes to BOM records for ethical drugs. The product is called
Stitch-in-Time and it has been used to provide fail-safe observation of crucial iSeries
files in a wide range of enterprises ... even an oil company bought a copy.

When Stitch-in-Time is asked to observe a database, the product saves the image of the
record just before a change and what the record looks like after the change. Also saved:
who did it, precisely when that happened, and what tool was used to execute the change.

The audit features of the product are so strong that we've often used it as a debugger
to efficiently find the "smoking gun" causing a data integrity surprise in a production system.

Here's a link: http://www.unbeatenpathintl.com/stitch_in_time/source/1.html

Warmest personal regards,
Milt Habeck
Founder/CEO
Unbeaten Path International

North America (888) 874-8008
International +(262) 681-3151









From: Blake.Moorcroft@xxxxxxxxxx
Sent: Thursday, November 13, 2008 7:44 AM
To: RPG programming on the AS400 / iSeries
Subject: Identifying who deleted records - trigger programs

Hello all...

I'm wondering if anyone has ever run into this situation before. Any help would be appreciated.

A request has been made to track record activity on a file. Specifically, auditors are looking to see who is deleting or updating records and what changes are being made.

The option to use a file trigger has come up and would provide the option to evaluate changes for updated records. The issue that is being encountered is identifying what program or procedure caused the trigger to kick off, and more importantly, what user profile was associated to the program or procedure.

Have a good day.

Blake Moorcroft
Developer - Corporate
Russell A. Farrow Limited