Re: Fw: Creating Sandbox and CRP Environments from Production

Re: Fw: Creating Sandbox and CRP Environments from Production

Chuck, thank you for your suggestions. I was not aware of the omit object
parameter on the savlib. This could be very useful. We currently use a 3590
tape system but the main problem is limited dasd on our dev AS/400, causing us
to find a better solution than just copying all of production to sandbox. By
doing a selective copy on our production environment, I will be able to cut
down on the size of the sandbox / crp environments. This may be the solution.

I was also not aware of the ACCPTHSIZ parameter, so will need to do some
research on this item.

Thank you again.

"Chuck Bower" <[email protected]> on 11/16/2000 04:23:48 PM

To: Paul Normandeau/SIF/MTL/[email protected]
Subject: Fw: Creating Sandbox and CRP Environments from Production


I sent this response back to the JDE list group, then thought I would
contact you individually.
What kind of tape hardware do you use? Do you have capacity issues with
disk space, and
any specific application that really chews up disk? We had to invest in a
3590E11 tape, with a tape library feature.

Also, I have just had to change some of my files to use a special parameter
that IBM allows (primarily on the lfs). The parameter is
ACCPTHSIZ(*MAX1TB). I was having some serious file contention on the
biggest files, that was causing not only long response time, but even to the
point of appearing to have users locked up solid on the system. I had to do
this to F0311 and its logicals, and to F4111 and its logicals. My F0911
will be done next. If you are not a techie, then I apologize ahead of time,
this may not make sense. But I wondered (since you have a large F0911 file)
if your company or you have had to do this type of change too.

----- Original Message -----
From: "Chuck Bower" <[email protected]>
To: <[email protected]>
Sent: Thursday, November 16, 2000 4:11 PM
Subject: Re: Creating Sandbox and CRP Environments from Production

> Paul
> You can use the OMITOBJ parameter on your IBM SAVLIB command to accomplish
> what you are looking for. This will allow you to omit objects, such as
> F0911* from the save. Note that I added an asterisk to the end of the
> F0911, because the OMITOBJ allows a generic entry, and thus you can also
> skip the logical files associated with F0911 from being saved. You
> will find that an omit of the F42199 and F43199 file groups would also be
> helpful to your process.
> Chuck
> ----- Original Message -----
> From: <[email protected]>
> To: <[email protected]>
> Sent: Thursday, November 16, 2000 2:50 PM
> Subject: Creating Sandbox and CRP Environments from Production
> >
> >
> > My question to everyone is has anyone found a good solution to creating
> sandbox
> > or crp environments from their production environment. We have two
> AS/400's,
> > one for our production environment and the other for a sandbox
> and
> > crp environments. We normally refresh sandbox each weekend with a full
> copy of
> > production from a tape backup. This is very time consuming process as
> F0911
> > file alone is over 22 million records (for '99 & 00'. We cut down the
> F0911
> > file with a selective copy after it has been restored to Sandbox. We
> want to
> > move to a much faster and leaner sandbox and crp environments. I could
> perform
> > a record selection on production before the save to tape but doing this
> for
> > approximately 4000 files is a little daunting. I could do this for only
> the
> > largest files, which is a little easier but I don't know how I would
> exclude
> > those largest files from the savlib when I want to save the library to
> tape. I
> > don't really want to do a save object. And if I did do a savobj for the
> 4000
> > files, would it take longer to restore than would a savelib. Anyone
> any
> > ideas that they are willing to share on how they are managing their
> > crp's/sandbox environments?
> >
> >
> > *************************************************************
> > This is the JDEList World Mailing List.
> > Archives and information on how to SUBSCRIBE, and
> > UNSUBSCRIBE can be found at
> > *************************************************************
> >
> >