RE: Log all PF changes?

Personally, I would use a journal because its likely to be faster than a trigger.

YMMV...

Terry


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Justin Taylor
Sent: Wednesday, January 06, 2016 1:21 PM
To: MIDRANGE-L (midrange-l@xxxxxxxxxxxx)
Subject: Log all PF changes?

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?
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Confidentiality Notice: The preceding e-mail message (including any attachments) contains information that may be confidential, protected by applicable legal privileges, or constitute non-public information. It is intended to be conveyed only to the designated recipient(s). If you are not an intended recipient of this message, please notify the sender by replying to this message and then delete it from your system. Use, dissemination, distribution or reproduction of this message by unintended recipients is not authorized and may be unlawful.