Re: Cannot Open Sys.Catalogs & Table Space

I wonder if the difference is a result of the fact that when you employ a cooked file, UNIX may buffer the disk I/O. When you use a raw device, OnLine circumvents UNIX. In article <3ar6u8$d3u@emory.mathcs.emory.edu>, ckipp@vth1.vth.colostate.edu (Cathy Kipp) wrote: > Chetan Anand writes: > -> > ->During in of our busy time, something went wrong with Disk I/O Card > ->and system HP-UX has many databases running non stop in which one > ->database is sitting on Cooked Device. During SOS, informix marked one > ->of the chunk as Down (PD) and dumped all the processes in > ->/tmp/infx_dump. Later when everything (card) was settled and I brought > ->the informix into online. Ghosh! all our databases sitting on raw > ->devices were okay except this on a cooked device. I did everything I > ->know like running tbcheck / shutting down. But all in vain. Later > ->ofcourse Informix Tech. Support helped to bring everything back to > ->normal.~ > > We had some similar problems where our raw device dbspaces were fine, > and only our cooked ones gave us problems... This happened two > or three times. Each time we recovered from backups (archives and > logical logs). After this we just put everything an raw disk and are > living happily ever after. I don't think we ever completely figured > out the root cause, but Informix OnLine 5.01 (maybe 5.00 at the time?) > on our IBM RS6000 model 580 seems much happier using raw disk space. > > Regards, > > - Cathy > > -------------------------------------------------------------------------------- > Cathy Kipp e-mail: ckipp@vth1.vth.colostate.edu Phone: (303) 491-1294 > Colorado State University Veterinary Teaching Hospital Fax: (303) 491-1205