|
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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.