SEO

#1 (**permalink**) 04-19-2008, 08:14 PM

Bouncy - Bouncy. That's obnoxious.

----- Original Message -----
From: "Jack Parker" <vze2qjg5@verizon.net>
To: "Daniel" <dhw377@nothing.no.spam.com>
Sent: Thursday, February 05, 2004 6:40 PM
Subject: Re: newbie with problems restoring db

> Not quite. That will set your root size for initialization - after that
the
> engine will read from the root partition itself to figure out size. What
> you want is:
>
> dbimport -d dbspace database
>
> cheers
> j.
>
> ----- Original Message -----
> From: "Daniel" <dhw377@nothing.no.spam.com>
> To: <informix-list@iiug.org>
> Sent: Thursday, February 05, 2004 3:01 PM
> Subject: Re: newbie with problems restoring db
>
>
> >
> > "Obnoxio The Clown" <obnoxio@hotmail.com> wrote in message
> > news:bvttvi$10m2t3$2@ID-64669.news.uni-berlin.de...
> > > Daniel wrote:
> > >
> > > > I tried "$0.00" and that did not work. However, "0.00" did work. The
> > > > dbimport program ran more this time, but did not complete itself. I
> got
> > a
> > > > different error this time, complaining that I ran out of disk space.
> My
> > HD
> > > > still has over 44 gigs of free space left.
> > > >
> > > > [dbimport running...]
> > > > revoke all on "informix".module_code from "public";
> > > >
> > > > { TABLE "informix".notes row size = 2328 number of columns = 7 index
> > size
> > > > { =
> > > > 43 }
> > > > { unload file name = notes00750.unl number of rows = 7062 }
> > > >
> > > > create table "informix".notes
> > > > (
> > > > create_date datetime year to second
> > > > default current year to second not null ,
> > > > create_user_id integer not null ,
> > > > subject varchar(255),
> > > > notes "informix".lvarchar not null ,
> > > > notes_id serial not null ,
> > > > module_code char(1) not null ,
> > > > subject_id integer not null ,
> > > > primary key (notes_id) constraint "informix".notes_id_pk
> > > > );
> > > > *** put loadcur
> > > > 271 - Could not insert new row into the table.
> > > >
> > > > 131 - ISAM error: no free disk space
> > >
> > > Are you sure you're inserting where you think you're inserting...?
> > (Fnaar!)
> > >
> >
> > I am inserting into rootdbs.
> >
> > I think that is the problem, as rootdbs is only 50 megs and my new db
> takes
> > more space than thtat. I have tried to increase the rootdbs size by
> changing
> > the ROOTSIZE variable in etc\onconfig.std and etc\onconfig.mymachinename
> > files, restarted the server (and rebooted the machine). However, I still
> see
> > the file as being 50 megs, and I stillg get the same error of no free
disk
> > space.
> >
> > Perhaps it's best not to but my new db into rootdbs, but for now, I
would
> > just be happy to get this thing working (dbimport). Is the above the
right
> > procedure to change the rootdbs size?
> >
> >
> >
> > > --
> > > "C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule"
> > > - Coluche
> >
> >
>

sending to informix-list

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Fw: newbie with problems restoring db