Re: drop empty dbspace & dbimport error...
Hi Listers,
I'm back.
I tried dbimporting the database but although I created the dbspace with
two 2GB chunks, the process failed due to the following:
create index "opsi".akmch4 on "opsi".mch (coentfincble,femovcble,
nrctacble,cotiuniorgext1,couniorgext1,comon,nrtercble,coprod,
cosbp,cotiuniorgext2,couniorgext2,cotiuniorgext3,couniorgext3,
nruserid,txvalsdocble1) in testgldbs2;
*** execute sqlobj
212 - Cannot add index.
179 - ISAM error: no free disk space for sort
I have 6 temporary dbspaces at 50Mb each. Given constraints on the disk
storage, how should a DBA/System Admin determine what size and how many
temporary dbspaces to create? This set of tables currently use 1.4GB of
informix storage of this this particular table with 12 indexes use 1.1GB of
the total informix storage.
I'll follow Paul Mosser's advice to load only the table data for this big
table.
I'll have to remove the create index statements from the schema file.
Then run the create indexes schema after the database is imported.
Please for your advice,
Regards,
Denmark W.
----- Original Message -----
From: Denmark B. Weatherburn <dweatherb@btl.net>
To: <murray@quanta.co.nz>
Sent: Wednesday, February 07, 2001 4:16 PM
Subject: Re: drop empty dbspace & primary chunk
> Thanks Listers,
>
> I was able to drop it after dropping a database which I had imported
> unsuccessfully.
>
> Regards,
>
> Denmark W.
>
> ----- Original Message -----
> From: Murray Wood <murray@quanta.co.nz>
> To: <informix-list@iiug.org>
> Sent: Wednesday, February 07, 2001 3:41 PM
> Subject: RE: drop empty dbspace & primary chunk
>
>
> > There was a problem in older versions ... if that is what you are on
...
> > you need to get tech support to drop it.
> >
> > MW
> >
> > -----Original Message-----
> > From: owner-informix-list@iiug.iiug.org
> > [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Denmark B.
> > Weatherburn
> > Sent: Thursday, February 08, 2001 5:09 AM
> > To: kagel@bloomberg.net; informix-list@iiug.org
> > Subject: Re: drop empty dbspace & primary chunk
> >
> >
> >
> > cc9f500 12 1 12 1 N informix testgldbs
> > cc9eca0 12 12 0 1000000 999697 PO-
> > /work/informix/data/testgl.dbs
> >
> > bbanksig{informix}/sfw/informix/shells>onspaces -d testgldbs -p
> > /work/informix/data/testgl.dbs -o 0
> > WARNING: Dropping a chunk.
> > Do you really want to continue? (y/n)y
> > Chunk not dropped.
> > ISAM error: Can not drop first chunk> >
> > I dropped the database I was attempting to dbimport but I got the same
> > result when trying to drop the dbspace.
> > How can I drop "testgldbs" dbspace?
> >
> > I want to use another disk with raw devices for the chunks.
> >
> > Regards,
> >
> > Denmark W.
> >
> >
>