Fw: newbie with problems restoring db

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