Re: Intermittent backup

[Jerry Adams <jerry@xxxxxxxxxxxxxxx>]

I had to do something similar awhile back.  The route that I chose was 
to use SQL to CONNECT to the 2nd system.  This required that receiver 
files, of course, be on the 2nd system that were mirror images of those 
being pushed.  I got all of the information that I needed from the 
Redbook (SG24-6393-00) written by Birgitta and company.


I thought that it would be intolerably slow, but even as part of an 
interactive process, the users didn't even notice it.  Bear in mind, 
though, that the number of records being pushed per incident ranged from 
2-n with n probably being < 5 in 98% of the cases. 


There was another option that I glanced at that you might want to 
investigate: ObjectConnect.  It is part of the base OS (option 22 in 
V5R3). 


Either option, if you don't want to use journaling, should be way faster 
than popping everything into a *Savf and then FTPing it to the 2nd system. 


        * Jerry C. Adams
*IBM System i5/iSeries Programmer/Analyst
B&W Wholesale Distributors, Inc.* *
voice
        615.995.7024
fax
        615.995.1201
email
        jerry@xxxxxxxxxxxxxxx <mailto:jerry@xxxxxxxxxxxxxxx>



Dave Snyder wrote:
> I am looking for a way to "backup" or make copies of files and
> libraries, without knocking people out of the system or slowing them
> down to do so. I need a way to periodically backup up transaction files
> or updated master files periodically throughout the day and send them to
> an alternate box. HA software is not an option at this point. I know I
> could use journaling but do not know that I want to go down that road,
> or else I will push for the HA software. 
>
>  
>
> Can I use CPYLIB, CPYF, CRTDUPOBJ, SAVOBJ, SAVLIB commands and achieve
> the results I am looking for? I realize I might have to run them
> multiple times throughout the day.
>
>  
>
> Thanks for the direction.
>
>  
>
> Dave 
>
>  
>
>
> ***********************************************
> PRIVILEGED AND CONFIDENTIAL:
> This communication, including attachments, is for the exclusive use of the 
> addressee and may contain proprietary, confidential and/or privileged 
> information. If you are not the intended recipient, any use, copying, 
> disclosure, dissemination or distribution is strictly prohibited.  If you are 
> not the intended recipient, please notify the sender immediately by return 
> e-mail, delete this communication and destroy all copies.
> ***********************************************
>
>