Re: BRMS full copy versus Cumulative Copy between two Power systems

[Steve McKay <samckay1@xxxxxxxxx>]

Laurence -

The command in your photo is not a BRMS command - it's just a regular
SAVOBJ to a save file.  If you change the SAVOBJ to SAVCHGOBJ, it will save
only objects that have changed since the last full backup.  This is
important because over time the SAVF will growth larger and larger (because
more objects have changed since the last full backup).  So you will need to
periodically perform a full backup to keep the size of the SAVCHGOBJ SAVF
lower.  Once you get the SAVCHGOBJ SAVF FTPed, you should be able to
perform a RSTOBJ at the target site with no problem.

Thanks,

Steve McKay
(205) 585-8424
samckay1@xxxxxxxxx



On Wed, Apr 22, 2020 at 4:39 PM Laurence Chiu <lchiu7@xxxxxxxxx> wrote:

> Sorry if this question seems a bit simple but in my defence I am not a
> Power systems expert and my only source of expertise is our outsourcer and
> I want an independent view also to validate what they tell me.
>
> The situation is the environment I am working is has two Power
> installations (IBMi of course) and each night a full backup of the database
> is taken and FTP'ed to a second site and restore. The command to create the
> back looks like this
>
> https://bit.ly/2yw6kdz
>
> I have blanked out sensitive information like filenames but I presume the
> command still makes sense.
>
> The output files are then sent to the other installation and restored. At
> the moment the second Power server is only a few hundred metres away and
> connected over GbE.  So no problems. But the second server is now being
> moved 2600Km away and on a 200Mbs line. That is causing network issues.  It
> seems to me that if the command above is a full copy, then a better
> solution might be to take a cumulative (differential I am used to saying
> from my DBA days) and sending that across. That would be significantly
> smaller. My question is, can this cumulative copy be loaded in the target
> system when records of the last full copy don't really exist in the target
> BRMS. Unless once the full copy was loaded in the target system, then a
> full copy was taken to create that record. But would BRMS be smart enough
> to know that the subsequent Cumulative was related to the full copy taken
> remotely.
>
> Thanks
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com