Re: Cannot Open Sys.Catalogs & Table Space

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