Re: Cooked Space Problem

Harold Sasaki wrote: > Informix Online 7.2 running on Solaris (sparc) > > I was cleaning up some old databases and files and I believe I removed a > cooked file! The databases that use this dbspace appear to be working > fine. I guess everything is in memory or something. What's going to > happen if I restart the server? I can restore the file from an old backup > but I'm trying not to lose many days of data. > > Any suggestions? I'd hate to have to dump everything from every table and > recreate everything. > > Thanks! > > -- > ----- > Name: Harold Sasaki > Email: hsasaki @ harold.com (remove spaces) > Web: http://www.harold.com/ Hi Harold, This is a situation that can only be solved with caution. As long as you do not shutdown the server, you will be able to continue working because a "rm" by Unix only deletes the entry in the directory. The I-node (which is the actual file) will be deleted (and ther disk space freed) at the moment when the last process (i.e. Informix) closes it. What I would do (I hope I will never be in this situation as I use raw devices) is: 1) stop users working (maybe by going to the quiescent mode) 2) perform a database backup 3) shut down informix (ouch!) 4) restore the database No responsability whatsoever that it works without problem. Regards Helmut Leininger Bull AG Vienna Unix Support Email: Helmut.Leininger@bull.net