Re: Journaling newbie - questions

While I am not a fan of SAVCHGOBJ, the process you have described would work.

Yes you should do a CHGJRN just before the backup. I assume that you are doing a weekly save (not a SAVCHGOBJ).


Jim

----- Original Message ----
From: Jeff Crosby <jlcrosby@xxxxxxxxxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Sent: Thursday, June 26, 2008 2:07:20 PM
Subject: Re: Journaling newbie - questions

The more I think about your FTP suggestion, the more I like it.

How does this sound for a strategy:

1) Start journaling all DB files.
2) Every workday at 12:01am, do a full save (already doing).
3) Hourly, do a CHGJRN, save the detached receiver to a SAVF, and FTP it
to my PC.
4) At end of workday, do a SAVCHGOBJ of all user libraries. (This would
also save those FTP'ed journal receivers to tape. At this point, the
SAVF sent to my PC, as well as the journal receivers themselves are no
longer needed because the end of day SAVCHGOBJ saved a) the object
itself, and b) the journal receivers)

Sound reasonable? Other scheduled jobs could remove the saved journal
receivers, and I'm sure I could find a way to auto delete the files from
my PC. I think I could find a local (within the city) FTP site instead
of my PC too.

PS, before that 12:01am save, I should do a CHGJRN too, shouldn't I?