Re: Problem with Restore V.7.30.

From: "Prof.Dr.Gipper" <gipper@fh-aachen.de> > > I am using Informix Version 7.30.fe3 >the command "onstat -d" gives the following information: > size free >/rootdbs 175000 173553 >/dat1dbs 975000 5 >/dat2dbs 975000 673741 >there are no other ...dbs-files. >1. Is it true, that the sum of (root+dat1+dat2) is the size of the >database? It depends. If you only have one database in this instance, then yes, that is true. >2. I export firm1 (size about 380000) and >3. import it as firm2 >After that action Database is instable. It is impossible to restore the >Bakupfiles. >question: if I import firm2 (which is a copy of firm1) must I give >explicit the name of a are big enough to store the hole firm? Is it so, I assume you mean "a _dbspace_"? You can stick it all in one dbspace that's big enough, or you can split off individual tables into separate dbspaces, or you can fragment a table across multiple dbspaces. By default, it will try to stick all the tables in the dbspace in which you created the database, which, by default, is the rootdbs >that informix store the import automatic into rootdbs, which is not big >enough in this case? What can happen? It _should_ just crash and burn with an out of space error. >In my case, afterv that action, we run into problems 4-5 weeks later. >Now we restore the database with a backup befor that action. >has anyone an idea?? Sounds like something got corrupted, but it's difficult to tell. HTH. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com