Re: APYJRNCHG

[barsa@xxxxxxxxxxxxxxxxxxx]

Clearly you could use them together.

Journaling was an availability enhancement that came out in Release 4.1 of
CPF.  People that were interested in highly available systems went to it
immediately.  SAVCHGOBJ was introduced in Release 5.0 of CPF, and it was
assumed that anybody that would be using it would first be using
journaling.  (So the default for OBJJRN was set to *NO.)

SAVCHGOBJ was always very slow, because every internal object was
interrogated at the object detail level to determine if it should be saved,
hence you would want to be journaling as the first line of defense.

Since then, two things have happened.

1).  Tapes have gotten dramatically faster.
2).  An internal object changed bit was added in V2R1M0 of OS/400, which
made SAVCHGOBJ run much faster.

Today, most people only journal because of the following needs:

1).  Use of a HA product like MIMIX.
2).  The desire for commitment control, which is a good thing, and not
enough people program for it.
3).  The use of selected rules of referential integrity.

If this answers your question that's great, or else give a call.

Al

Al Barsa, Jr.
Barsa Consulting Group, LLC

400>390

914-251-1234
914-251-9406 fax

http://www.barsaconsulting.com
http://www.taatool.com






                    prumschlag@phdinc.c
                    om                        To:     midrange-l@midrange.com
                    Sent by:                  cc:
                    midrange-l-admin@mi       Subject:     Re: APYJRNCHG
                    drange.com


                    08/22/01 08:30 AM
                    Please respond to
                    midrange-l








Al,

Would you mind expounding a bit more on your response to this question?
Are you
saying don't include journal entries as part of the recovery strategy?  Is
that
a blanket rejection of Journaling, or only in conjunction with SAVCHGOBJ.
Why
not use them together?

Phil

     Message: 1
     From: barsa@barsaconsulting.com
     Subject: Re: APYJRNCHG
     To: midrange-l@midrange.com
     Date: Tue, 21 Aug 2001 22:14:06 -0400
     Reply-To: midrange-l@midrange.com


     Forget using your journal entries as a part of the restore.  On
SAVCHGOBJ,
     change the OBJJRN parameter from *NO (the default) to *YES.  SAVCHGOBJ
was
     created when journaling was a key part of OS/400's (then CPF's) save
     restore strategy.

     Al

     Al Barsa, Jr.
     Barsa Consulting Group, LLC

     400>390

     914-251-1234
     914-251-9406 fax

     http://www.barsaconsulting.com
     http://www.taatool.com






                         Jim.Nelson@RCIS-NET
                         .COM                      To:
     midrange-l@midrange.com
                         Sent by:                  cc:
                         midrange-l-admin@mi       Subject:     APYJRNCHG
                         drange.com


                         08/21/01 05:31 PM
                         Please respond to
                         midrange-l







     We are looking at shortening our backup downtime by going with
SAVCHGOBJ.
     Only problem is that we journal most of our files, which means we
would
     need
     to restore from the SAVEALL, then run APYJRNCHG for the daily saves.
The
     documentation says to expect a longer recovery time, but no estimates.

     During our 'busy time', we create about 300,000 journal entries per
day -
     tables ranging from 150 bytes to over 800.

     1.  Anybody have estimates (or an algorithm) on what the recovery time
     would
     be?  Looking more for those occasional 'restore to a temporary library
to
     check data' rather than a complete recovery.  If we ever need a
reload, a
     few hours here or there will be the least of my worries!

     2.  Any 'tricks' or items to watch for using SAVCHGOBJ and APYJRNCHG?
     Horror stories?

     Thanks for your help.

     JN


_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com