Re: dbexport/dbimport question

"Brian McLaughlin" To: <informix-list@iiug.org> <bmclaugh@georgef cc: ox.edu> Subject: dbexport/dbimport question Sent by: owner-informix-li st@iiug.org 04/05/2005 08:14 In the continuing story of our preparation to migrate to a new version our business software, I've set up our "practice" server with Informix 9.4. I'm using dbexport/dbimport to load our data, because we've changed the dbspaces a bit -- taking advantage now of large chunks, consolidating some spaces, etc. dbexport on our business server produced a hair over 9GB. (Nice tidy little database!) When I look at the .sql file dbexport generated, most of the create table statements do not specify a dbspace. I believe that means that when this is dbimported, those tables are created in rootdbs? (You need include the -ss option on the dbexport command.) Rootdbs on the dbexported server is only 30MB. Rootdbs on the imported server is 512MB. Yet, on the dbimport, rootdbs filled up, and the import aborted. I can pretty easily edit the .sql file to include an "IN mydbs" after each create table statement, but my question is... where are these tables residing now if there is no dbspace specified in the dbexport results? (The default dbexport allows you to change your dbspaces however in practice even when you want to change them you probably want to start with the existing setup and edit just the dbspace names themselves anyway) Brian McLaughlin Administrative Computing George Fox University (503) 554-2587 sending to informix-list sending to informix-list