Re: SQL Question

[Jerry Adams <jerry@xxxxxxxxxxxxxxx>]

Alan,


I have a similar set-up.  Except that I refresh the Dev box nightly.  I 
don't use DDM or SQL, but simply SaveFiles FTP-ed.  Takes about 30 
minutes for us (ymmv) to do that at 1:30 am. 


Although I don't explode the libraries at that point, it would be a 
simple matter to invoke a process (RUNRMTCMD) from Prod to do that.  
Just be sure that, if you do that, the procedure in the RUNRMTCMD isn't 
the one that actually explodes the libraries but submits the real one to 
the job queue on Dev, otherwise Prod will stay connected to Dev; i.e., 
the Production process will be an active job until the remote command 
ends on Dev.


The problem that I have with automatically restoring the libraries is 
errors related to journals when I clear or delete the libraries before 
the restore.  Primarily, though, I don't want it to wipe out "stuff" 
I've been developing and testing. 


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



Alan Shore wrote:

> Good morning list - Before I forget, or don't have a chance again,
> A Merry Christmas and a Happy New Year to one and all.
>
> We have 2 boxes, one for PRODUCTION, the other one for DEVELOPMENT
> Each weekend, using DDM, we refresh the DEVELOPMENT data from the
> PRODUCTION box.
> The past 3 weekends we have been having problems where one of the files has
> not finished till late Monday/early Tuesday. This has resulted in a cleanup
> of this file deleting some records that shouldn't be there otherwise we
> have problems on the DEVELOPMENT box when we try and test any new changes
> to the ORDER ENTRY system.
> My question is
> can SQL be used to directly create files ON the DEVELOPMENT box from the
> same name files ON the PRODUCTION box?
> If so, does anyone have any examples of what is required?
>
>
> Thanks in advance
>
>
>
> Alan Shore
>
> NBTY, Inc
> (631) 244-2000 ext. 5019
> AShore@xxxxxxxx
>