RE: Journaling question.....

[Rob Berendt <rob@xxxxxxxxx>]

Ah, yes.  Another question.  How to manage journal receivers?  
Frankly I dig the trigger method better for auditing.  And then 
using journalling for journalling and commitment control.  In 
that case I would lock my files at night, then reset the journal 
receiver.  Save the files and the journal receiver and delete 
the old journal receiver.  However if you are going to use the 
journal receiver to 'snoop' then maybe you want a different method 
of deleting them.




Jim.Nelson@RCIS-NET.COM on 03/21/2000 04:32:19 PM
Please respond to MIDRANGE-L@midrange.com@Internet
To:     MIDRANGE-L@midrange.com@Internet
cc:      
Fax to: 
Subject:        RE: Journaling question.....

Have you thought about triggers instead?

Each have their own quirks, but we've found triggers to be more manageable.
Easier to go back and retrieve the information, can selectively 'clean up'
obsolete data - including the ability to keep data on some tables longer
than others, etc. 

But to answer the question, we use one journal for all PF's

JN 


-----Original Message-----
From: Mark Allen [mailto:markallen@kellyskids.com]
Sent: Tuesday, March 21, 2000 9:52 AM
To: 'MIDRANGE-L
Subject: Journaling question.....


We are getting ready to embark on a project where we will be journaling our
major files, mostly for auditing/control checking (i.e. nobody admits to
changing customer order, changed by someone who should not have capability,
etc).  Interested in approach others have used.  One journal per
physical???, all PF's in one journal, one journal per app/module, etc????

Mark Allen
IS Manager
Kelly's Kids
markallen@kellyskids.com

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---