Re: SQL Collection Duplicating a DB

[Mike Wills <koldark@xxxxxxxxx>]

Someone on another list send me a CL program he used on that exact same 
schema and it worked. Apparenly, in this case at least a mass copy (using 
CPYF) worked.

On 4/13/05, Carel Teijgeler <coteijgeler@xxxxxxxxx> wrote:
> 
> Mike,
> 
> Have you looked at the Generate Data Definition Language API? It can 
> retrieve the DDL of a table, view, index, triggers, scheme (or library) in a 
> source member and recreate it as well.
> 
> Ted Holt at IT Jungle wrote a utility for this API. Searching Google will 
> give some hits.
> 
> The API is not that dif ficult to use in a CLP, either.
> 
> I think passing a library name and objecy type SCHEME you can retrieve all 
> the SQL commands to create it all, I think even with constraints and such.
> 
> Just a thought.
> 
> Regards,
> Carel Teijgeler
> 
> *********** REPLY SEPARATOR ***********
> 
> On 12-4-05 at 13:34 Mike Wills wrote:
> 
> >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.
> 
> --
> 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.
> 
> 


-- 
Mike Wills
Midrange Programmer/Lawson Software Administrator
koldark@xxxxxxxxx
http://mikewills.name
Want Gmail? Email koldark+gmail@xxxxxxxxx to get on my waiting list.