RE: dbexport/dbimport question
Dbimport creates the tables in the dbspace where you create the database (
-d to dbimport). I would never create a database in rootdbs so would never
have this potential issue.
MW
> -----Original Message-----
> From: owner-informix-list@iiug.org
> [mailto:owner-informix-list@iiug.org] On Behalf Of Brian McLaughlin
> Sent: Wednesday, 4 May 2005 8:15 a.m.
> To: informix-list@iiug.org
> Subject: dbexport/dbimport question
>
> 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.
>
> 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?
>
> 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?
>
> Brian McLaughlin
> Administrative Computing
> George Fox University
> (503) 554-2587
>
>
> sending to informix-list
>
>
sending to informix-list