Re: Log all PF changes?

[DrFranken <midrange@xxxxxxxxxxxx>]

Journaling, that's what it's there fore! It's also better because you 
cannot tamper with it. Any log written by your own program (such as a 
trigger) is suspect because you could ignore certain changes or mess 
with the log afterword with DBU etc etc.

        - Larry "DrFranken" Bolhuis

www.Frankeni.com
www.iDevCloud.com - Personal Development IBM i timeshare service.
www.iInTheCloud.com - Commercial IBM i Cloud Hosting.

On 1/6/2016 1:21 PM, Justin Taylor wrote:

> I need to keep a permanent log of all data changes in a particular PF.  I can think of two ways to accomplish this.
>
> 1.       A DB2 journal with the receivers set to never expire.
>
> 2.       A trigger that would write the before images to a separate PF.
>
> I expect questions of "who changed what when" to be a weekly occurrence.
>
> Either of those options sound better than the other?  Anyone have a door #3?