Re: Emergemcy Chunks Offline - tbzero utility

} } > From: Michael Strother <mstrothr@informix.com> } > Subject: Re: Emergemcy Chunks Offline - tbzero utility } > To: jaegerwl@wckn.dorm.clarkson.edu (Bill Jaeger) } > Date: Tue, 26 Sep 95 10:27:09 EDT } > Cc: informix-list@rmy.emory.edu } > Reply-to: Michael Strother <mstrothr@informix.com> } } > > } > > rridley@sin-apit.DHL.COM (Richard Ridley) writes: } > > } > > >We have had this problem a number of times, and, after trying to } > > >persuade Informix to release the tbzero utility to us, possibly with } > > >some training, Corporate HQ of Informix said no. } > > } > > I think Informix's position on the tbzero utility and the use thereof by the } > > "end user" (ie, system/DB administrator) community is unreasonable. This } > > weekend a disk crashed on a multi-gigabyte DSS system running Informix Online } > > v5.02. Of course, the disk crashed while the latest backup was still running. } > } > } > [ Stuff Deleted] } > } > } > } > } > > } > > -Bill } > > jaegerwl@wckn.dorm.clarkson.edu } > > } > The moaning that you people are doing is nothing compared to what would happen } > if Informix made tbzero available. tbzero has the capability to bring a very } > corrupt system online while you may think that tbzero magically fixed your } > original problem (It didn't). The bottom line is that if your system went } > offline, it did so for a reason and if you can't isolate and fix the original } > problem tbzero is only going to make things worse. } > } > Informix policy here is on the money. } > } > Bill should restore from his last backup. period. } > } > Michael } > } I disagree. } Sometimes, yes this this is a failsafe method of having to deal with } possibly a mojor problem, but there are times that it is not so } major. Informix tries just a few times to access a chunk and with no } response will mark this chunk as Down. I have found several times } that it could be as simple as turning an external disk unit back on } or someone with root permissions has changed the chunks ownerships } from informix. } These are problems that I can fix very easily but must still place a } call with Informix support. Dealing with informix support is a lesson } in patience all its own. It generally takes longer for First Level } Support to write up the incident and give me a case number than it } takes to fix the problem. Granted Informix suport has saved my } backside more than once and I do appreciate having them for a last } line of support but simple recognizable tasks could be performed by } my support group on a much more timely basis. } For those of you that think that all tbzero does is mark down chunks as available you are sorely mistaken and that is exactly the reason that tbzero does not belong in the public domain. Enough on this thread...it aint gonna become available and that's all there is to it... tbzero was never meant to be fix for DBA or SysAdmin oversights. MIchael