RE: SQL Collection Duplicating a DB

["Wilt, Charles" <CWilt@xxxxxxxxxxxx>]

Use iSeries navigator to "Generate SQL" script for the entire schema.

Do a global search and replace on the resulting script to rename the schema 
from it's original name to the new name.

Now run the script to create the duplicate schema.

At this point, you've got the files but they are empty of data.

To populate the files with data, I think you're going to have to roll your own 
routine using CPYF (or SQL).  May want to consider populating with just a 
subset of data.  There are tools out there designed to do subset extraction, 
for testing in an intelligent manner.

HTH,

Charles Wilt
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
 

> -----Original Message-----
> From: midrange-l-bounces+cwilt=meaa.mea.com@xxxxxxxxxxxx
> [mailto:midrange-l-bounces+cwilt=meaa.mea.com@xxxxxxxxxxxx]On 
> Behalf Of
> Mike Wills
> Sent: Tuesday, April 12, 2005 2:34 PM
> To: Midrange_Midrange-L
> Subject: SQL Collection Duplicating a DB
> 
> 
> I know there was some discussion on this a week or two ago 
> with David. We 
> are trying to create a duplicate SQL COLLECTION as a test DB. 
> I know I can't 
> save and restore as a new name. So how would I go about 
> copying all of the 
> data to the new DB? I have the tables setup, I just need to 
> copy the data. 
> 
> My vendor has a utility to do this, but it takes forever. It 
> first creates a 
> dump of the DB (about a 17 GB file) onto the IFS, then they 
> have me do an 
> import. Problem is this import ran for over 24 hours and 
> wasn't complete 
> yet. I let it run over 36 hours before I cancelled it. That 
> is not really 
> acceptable timeline for me. Plus you need to basically have 
> three copies of 
> the DB on your server at once. That isn't exactly ideal when 
> we have limited 
> amount of disk space.
> 
> Any ideas on how to do this?
> 
> -- 
> Mike Wills
> Midrange Programmer/Lawson Software Administrator
> koldark@xxxxxxxxx
> http://mikewills.name
> Want Gmail? Email koldark+gmail@xxxxxxxxx to get on my waiting list.
> -- 
> This is the Midrange Systems Technical Discussion 
> (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
>