Re: Quickest way to copy data from production LPAR to DEV LPAR

[DrFranken <midrange@xxxxxxxxxxxx>]

SAVRSTOBJ   Hands down the best way for such things. Can be on line, can 
be batch, scheduled etc. Maintains all attributes about the object.

        - Larry "DrFranken" Bolhuis

www.Frankeni.com
www.iDevCloud.com - Personal Development IBM i timeshare service.
www.iInTheCloud.com - Commercial IBM i Cloud Hosting.

On 9/28/2015 12:26 PM, Matt Olson wrote:
> *This message was transferred with a trial version of CommuniGate(r) Pro*
> I am attempting to copy data from a file in the production LPAR to the DEV LPAR and have yet to find an easy way to do it.
>
> Here is what I looked at so far:
>
>
> 1.       iSeries Navigation Export/Import function. No Go, only works with flat files, can not point to other system.
>
> 2.       DDM (so far not working due to bug in iSeries navigator with base database *LOCAL name on DEV LPAR being same as production LPAR and navigator apparently doesn't understand aliases to overcome this limitation). Apparently if we could get this working you can do a copy/paste from one system to another in iSeries navigator (would be awesome if it worked).
>
> 3.       SAVF, FTP, restore SAVF, do a rain dance.
>
> So far nothing is easy. I'm about ready to just build a Microsoft SQL Server SSIS data transfer package but it seems like I shouldn't have to do this. Option #3 has been the historical mode of operation but is too time consuming.
>
> Any other thoughts on how to do this quickly with as few steps as possible?
>
> Matt