RE: Is there a problem with NOT ending journaling before doing a reorg?

Dave,

Are you using High Availability software? If so you never really
want to end journaling, for ANY reason.

If you are doing the standard reorg, then there is only one record
written to the journal when a reorg is done. So, there is no harm in keeping
journaling active. If you use a Reorg while Active, then each record as it
is moved to a new Relative Record would be written to the journal, and this
would be an HUGE amount of entries written to the journal. Basically
atleast two for every record in the file. So, if you had a million records,
you would have at least 2 million entries written t your journal.

Pete Massiello
iTech Solutions

-----Original Message-----
From: midrange-l-bounces+pmassiello-ml=itechsol.com@xxxxxxxxxxxx
[mailto:midrange-l-bounces+pmassiello-ml=itechsol.com@xxxxxxxxxxxx] On
Behalf Of Dave Odom
Sent: Thursday, December 13, 2007 7:06 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Is there a problem with NOT ending journaling before doing a reorg?

I have one IBM program product installed that doesn't like journals to be
ended and my systems programmers have always been told to end journaling
before doing a reorg. Your opinions on keeping journaling running and
doing a reorg anyway?

Thanks,

Dave