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

I do this on a normal basis, using BRMS.
By individual library.
RSTLIBBRM
No FTP.
On the target system

Cause . . . . . : Command to execute is: RSTLIBBRM SAVLIB(CABLEFILES)
DEV(TAPMLB01) SAVLVL(*CURRENT) SAVDATE(010119 *LATEST) ENDOPT(*LEAVE)
OPTION(*ALL) MBROPT(*ALL) ALWOBJDIF(*ALL) RSTASP(01) FROMSYS(PENCOR05).

Notice the FROMSYS
It is pointing back to my source production system.

FROMSYS(PENCOR05)

Paul

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
Laurence Chiu
Sent: Wednesday, April 22, 2020 4:39 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: BRMS full copy versus Cumulative Copy between two Power systems

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://smex-ctp.trendmicro.com:443/wis/clicktime/v1/query?url=https%3a%2f%2fbit.ly%2f2yw6kdz&umid=2f943d10-036c-4d2d-bbf9-ce24e44f9cf4&auth=438b0784514c1757bd202125ca4db8b0abdb021e-3ce3672d66ebc2413d573f15550e80456352009f

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
--
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