× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. April 2020

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

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


As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.