RE: Log all PF changes?

OMTJRNE( *OPNCLO )



-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Justin Taylor
Sent: Wednesday, January 06, 2016 2:58 PM
To: Midrange Systems Technical Discussion
Subject: RE: Log all PF changes?

"1. Start journaling the table. I suggest omitting open and close entries."

Do you know the parameter(s) for that?





-----Original Message-----
From: Monnier, Gary [mailto:Gary.Monnier@xxxxxxxxx]
Sent: Wednesday, January 06, 2016 3:38 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: RE: Log all PF changes?



Thanks,
Gary Monnier
IT Software Engineer CSM, CSPO


There's this...

1. Start journaling the table. I suggest omitting open and close entries.
2. Clone the source for the table in question; renaming it and adding any additional columns you desire: user altering the row,
action taken (insert, update, delete), timestamp for row creation and change if not there already.
3. Write a program that reads the journal entries, formats the entry specific data to the cloned table and writes records to it.
This can be a NEPs program.
4. Use the cloned table to report from.

Now you can let the table grow to whatever size you want. Saving the journals & their receivers provides to the ability rebuild the table if necessary.

You also have the data necessary to rebuild the original table if such a thing becomes necessary.

Hope this helps.

Gary