RE: SQL Collection Duplicating a DB

I just found the following article, "Managing DB2 UDB for iSeries Schemas and 
Journals" written by Kent Milligan w/IBM.

http://www-128.ibm.com/developerworks/db2/library/techarticle/0305milligan/0305milligan.html

It has a section titled "Moving a schema" that is relevant to this discussion.


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@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Wilt, Charles
> Sent: Tuesday, April 12, 2005 3:20 PM
> To: Midrange Systems Technical Discussion
> Subject: RE: SQL Collection Duplicating a DB
> 
> 
> 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
>  
>