Re: Remains in recover mode.

In article <CoDCCt.99y@world.std.com>, edwards@world.std.com (Jonathan Edwards) says: > >In article <2objsr$so7@stargate.promus.com> jburks@promus.com (Jim Burks) writes: >> >>Depending upon the nature of the crash, sometimes *NO* database will >>recover ;-). > >I have to disagree: a correct database will ALLWAYS recover from any >failure other than physical loss of media. What about the case of some writes suceeding, while others fail. Not exactly a media failure, but in some ways worse. >If it doesn't, the database vendor should be dialed-in diagnosing >the bug and patching the database. Informix has for us, in such cases. Sometimes, the patch tool they use is tbzero. >The necessary conclusion is that Informix is not reliable enough for >"mission critical" applications. To the contrary, about 1/3 of all the hotel reservations in the US go through Informix. We are up 24 hours a day, seven days a week, 365 days a year. We take Informix down for an hour or three a month for table maintenance. Our business runs on it. That's pretty mission critical to us. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~ Jim Burks jburks@promus.com ~ ~ Database Administrator / Systems Engineer ~ ~ The Promus Companies, Inc. Memphis, TN USA ~ ~ http://stargate.promus.com/public/jbb.html ~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~