RE: Journaling

["Richard Jackson" <richardjackson@xxxxxxxxxxxxxxxxxx>]

Simon, expanding your comment:

Inserts, updates, and deletes are journaled (along with opens and closes)
however, at V4R3, "If the updated physical file image after the update is
the same as the image before the update, and if the file has no variable
length fields, then journal entries are not deposited for that update."
From the Backup and Recovery manual.

Richard Jackson
mailto:richardjackson@richardjackson.net
http://www.richardjacksonltd.com
Voice: 1 (303) 808-8058
Fax:   1 (303) 663-4325

-----Original Message-----
From: owner-midrange-l@midrange.com
[mailto:owner-midrange-l@midrange.com]On Behalf Of Simon Coulter
Sent: Monday, September 18, 2000 12:05 AM
To: MIDRANGE-L@midrange.com
Subject: Re: Journaling


Œ
Hello David,

You wrote:
>But - Andersen bothered to build in the journaling properly.  Part of this
>is to open files for input only where possible.  Files opened for update
>will have all their reads journaled.  So... MACPAC would often open the
same
>file multiple times - once for read only operations, once for updates.
This
>minimized the impact on the journals.

While I agree with most of what you wrote, this statement is silly.  READs
are never
journalled, what would be the point!  I know some sites want to know who
read a record
but journalling isn't the way to accomplish that.  Journalling has no effect
on reads.
Even reads though an update ODP.

Regards,
Simon Coulter.

«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»
«» FlyByNight Software         AS/400 Technical Specialists       «»
«» Eclipse the competition - run your business on an IBM AS/400.  «»
«»                                                                «»
«» Phone: +61 3 9419 0175      Mobile: +61 0411 091 400           «»
«» Fax:   +61 3 9419 0175      mailto: shc@flybynight.com.au      «»
«»                                                                «»
«» Windoze should not be open at Warp speed.                      «»
«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»
+---
| 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
+---