Re: Replicating Data Between IBM i Prod and Dev

[Rob Berendt <robertowenberendt@xxxxxxxxx>]

We restore from a save.  Since we use VTL it's pretty quick.

There are software packages available to strip the data down.  Some of the
belief is to give you a smaller test set.  One concern with a smaller test
set is that query optimization may not match what's in production, etc.

On Fri, Sep 27, 2024 at 4:35 PM Richard Schoen <richard@xxxxxxxxxxxxxxxxx>
wrote:

> HI All,
>
> Customer wants to regularly refresh data between Production and Dev
> systems.  (Once every few weeks be able to refresh)
>
> Please give me some ideas on best practices.
>
> I can think of:
> -Replication software. (Probably the MOST up to date)
> -Save/restore libraries between systems with save files
> -Use DDM files to move data.
>
> Please share your strategies to keep test data relatively fresh on your
> dev systems.
>
> Thanks in advance.
>
> Regards,
> Richard Schoen
> Web: http://www.richardschoen.net<http://www.richardschoen.net/>
> Email: richard@xxxxxxxxxxxxxxxxx<mailto:richard@xxxxxxxxxxxxxxxxx>
>
> --
> 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.