Re: Informix Data Warehouses

Art S. Kagel wrote: > > Paul Watson wrote: > > > > Naomi Walker wrote: > > Sun E10k). I have heard through the grapevine that there are > > > considerable problems with Informix that cause data to be lost, and > > > problems with its general administration (like lots of broken indicies). > There are no such catastrophic problems out there. Certainly not with > any of the currently supported versions and there are a dozen of them > even ignoring platforms. The most recent versions, 7.30UC3, 7.24UC5, > 9.20, 8.?? (I don't remember) are all considered extremely stable and > reliable and the 8.xx product is ideal for data warehouse applications. Uhm Art, I heard a story about a guy who had his DBSPACES on hot swap-able disks and didn't have them mirrored. Then someone pulled the drive and walked off with it. Does *that* count? ;-) Sorry, I couldn't resist. Truth be told, There are problems that in the event of a failure, you can lose data from *ANY* RDBMS product. That's why there are replication schemes, fault tollerant hardware, *TAPE* Backups..... Of course, there are those who *don't* test the validity of their failover or backup strategy and really do lose data. In these cases/horror stories, its the human factor, however there are *issues* with Informix's products. I'm sorry I am not going to sugarcoat the truth or deny it. There are bugs within Informix, however, they are not as catastrophic as the FUD you are being told. If Informix's software was perfect, then we wouldnt need patches would we? -- #include <std_disclaimer.h> /* Mike Segel (MS385) */ #include <No_Spam.h> #ifdef OFFENDED_BY_CONTENT The author takes no responsibility for this post. Any resembalence to a coherent rational thought is purely coincidence. -The Management. #endif ***************************** * Attention * -*- Due to AGIS's Refusal to Act Responsibly -*- Due to ACSI's latest actions, they have been pardoned. [E.Spire] We are blocking all of their domains at the packet level. This block will exist until they modify their policies to conform to existing RFCs and net community standards. We encourage all ISPs and domain holders to do the same. *****************************