Why Informix is Best

Hello Friends I want to give a presentation on Informix Database I have prepared the history,architecture and all the other required points But when comparing it with other RDBMS i am not able to find out sufficient point can you just help me and give me point as to why one should go for Informix and not oracle why Informix is best compared to oracle

prateek_mjv@yahoo.com wrote: > > But when comparing it with other RDBMS i am not able to find out > sufficient point can you just help me and give me point as to why one > should go for Informix and not oracle > why Informix is best compared to oracle > Hardhats, bullet proof vests and flame proof overalls will be provided........

prateek_mjv@yahoo.com wrote: > Hello Friends > I want to give a presentation on Informix Database > I have prepared the history,architecture and all the other required > points > But when comparing it with other RDBMS i am not able to find out > sufficient point can you just help me and give me point as to why one > should go for Informix and not oracle > why Informix is best compared to oracle > It's easier to use than Oracle, smaller footprint, more flexible configuration, less overhead, simpler engine, less DBA intervention required.

Data Goob wrote: > It's easier to use than Oracle, smaller footprint, more flexible > configuration, > less overhead, simpler engine, less DBA intervention required. "Easier to use" than WHAT version of Oracle? This is the kind of fluff that is used for tinder in flame wars. I think Prateek's expectation is for substance. Prateek ... different transaction models, different locking models, different ways of using rollback, different object types, even different types of tables and indexes. Contact me off-line and I'll gladly point you to the differences that matter. Then you can make your own value judgements. -- Daniel A. Morgan http://www.psoug.org damorgan@x.washington.edu (replace x with u to respond)

<prateek_mjv@yahoo.com> wrote > Hello Friends > I want to give a presentation on Informix Database > I have prepared the history,architecture and all the other required > points > But when comparing it with other RDBMS i am not able to find out > sufficient point can you just help me and give me point as to why one > should go for Informix and not oracle > why Informix is best compared to oracle Since you are posting from India let me warn that there are hardly any user of Informix in India and consequently the skilled people to run it will be hard to find. I am aware of few big companies using Informix bcos they are supporting outsourced applications from USA. It all depends on your application. If I were you I would recommend SQL Server. Easy to maintain/run. Plenty of skilled people. Don't have to worry about its future as it is MS.

I following is MY opinion based on MY experience. " Proper multithreaded architecture. Easier to read manuals. Better performance. Easier to debug (crash dumps have meaningful messages in them). Backups automatically include everything needed to recover the database rather that needing to create your own backup scripts or configure a complex and unreliable RMAN configuration. When I did the Oracle Admin course part 2 (1 on 1 with instructor for a week paid for out of my own money!) we managed to completely stuff RMAN within a couple of backups/restores! ontape needs little configuration and works. ontape -s -L 0 - backup everything in the instance to TAPEDEV no needto change the command if chunks (datafiles) are added/removed/ renamed. Simple copy to tape no complex RMAN configuration needed. ontape -r to recover. Hmm which is more reliable - the simple configuration or the complex one? Hint ...onarchive has been dropped by Informix! ontape -c - Backup transaction logs to tape. Can properly use raw partitions and Kernel Async I/O to increase performance. When adding raw disk space Oracle zeros out the whole raw disk space whereas Informix just writes to the bit it needs to. I've seen adding an 8Gb chunk take 20 minutes of furious disk I/O under Oracle. I've added several 2Gb chunks in a few seconds under Informix. sysmaster database allows monitor of the database via sql allowing you to build performance monitor tools that are less overhead and specific to YOUR needs as opposed to generic monitoring tools that are inflexible.Almost all Internals information can be queried via sql against the sysmaster database. Informix far more willing to fix bugs and even admit bugs exist than Oracle or Microsoft. IBM Informix has direct to engineer support whereas Oracle pass you to a phone monkey in india. When you have a bug on a Unix platform IBM Informix reproduce it on a UNIX platform unlike Oracle who come back 3 days later and say we could not reproduce the problem on NT (Yeah right I have a million pound server running a 64 bit OS and you cannot reproduce the bug on some shitty NT4 box under your desk)! Informix is supported by IBM who are not going away in fact it is the IBM OLTP database of choice." REMEMBER THIS IS MY OPINION SO ORACLE YOU CAN'T SUE ME.. ...YAH BOO SUCKS! If you want more detail and have specific questions then email me david@smooth1.co.uk

david@smooth1.co.uk wrote: > When I did the Oracle Admin course part 2 (1 on 1 with instructor for a > week > paid for out of my own money!) we managed to completely stuff RMAN > within > a couple of backups/restores! ontape needs little configuration and > works. And no doubt your instructor was fully qualified to read PowerPoints. This is the kind of anecdotal nonsense that fuels flame wars. I could point to 200-500 DBAs who can figure out how to do two mouse clicks in OEM without stuffing anything. But then maybe they are qualified to do more than just teach. The things you are pointing to are matters, once again, of personal opinion. How about supplying Prateek with empirical facts and letting him make his own value judgements? Or don't you trust him to make the one's you want? ;-) -- Daniel A. Morgan http://www.psoug.org damorgan@x.washington.edu (replace x with u to respond)

<prateek_mjv@yahoo.com> wrote in message news:1126613436.424963.15010@g14g2000cwa.googlegroups.com... > Hello Friends > I want to give a presentation on Informix Database > I have prepared the history,architecture and all the other required > points > But when comparing it with other RDBMS i am not able to find out > sufficient point can you just help me and give me point as to why one > should go for Informix and not oracle > why Informix is best compared to oracle If you are comparing Informix with Oracle, are you also comparing DB2, Sybase, msSQL, TeraData, PostgressSQL, msAccess, etc???? What about CICS/IMS, DMS-1100? What about Informix-SE??? What about What about VSAM? Cloudscape??? X10? or ... and the list goes on.... The best database is the one which meets the business needs with the fewest problems and the least cost. Since you are not including the business requirements in this thread, it is totally impossible to respond to your posting with any real honestity. >

<david@smooth1.co.uk> wrote in message news:1126638699.401097.52260@z14g2000cwz.googlegroups.com... > > Informix is supported by IBM who are not going away in fact it is the > IBM OLTP database of choice." Oh God, it was all going so well until you trotted out this horseshit. Still, plenty of acid for the eyes of Daniel Morgan I don't doubt ... :-)

I fully expect that Daniel will do a terrific job of presenting Oracle's side of the story. Now all Prateek will need is an equally skilled communicator to present the Informix version of the empircal facts and differences that matter.

Captain Pedantic wrote: > Oh God, it was all going so well until you trotted out this horseshit. > Still, plenty of acid for the eyes of Daniel Morgan I don't doubt ... :-) Hardly. Could care less about DB2 vs Informix though I've a tear in my eye over what will likely be the demise of an old friend. -- Daniel A. Morgan http://www.psoug.org damorgan@x.washington.edu (replace x with u to respond)

Steve Pearson wrote: > I fully expect that Daniel will do a terrific job of presenting > Oracle's side of the story. > Now all Prateek will need is an equally skilled communicator to present > the Informix version of the empircal facts and differences that matter. Actually I don't believe in presenting "Oracle's side of the story" when someone is asking a question worded as Prateep did. He didn't ask "which is best" which invites personal opinion. He asked for information about the differences leading me to think he is intelligent enough to come to his own conclusions. The kind of information I think he needs is the differences in, as I stated, transaction models, locking models, object types, etc. My only objection is that you folks seemed to think "it is easier in my personal opinion" to be a difference in the products: It is not. It is a difference in your perceptions which may or may not be valid. The difference between science and marketing is that in science I can get people from IBM, Microsoft, and Oracle to agree on the melting temperature of ice. In marketing I couldn't get them to agree on anything. The answers originally posted were marketing nonsense: Easier ... softer ... fluffier ... whiter whites and brighter brights. -- Daniel A. Morgan http://www.psoug.org damorgan@x.washington.edu (replace x with u to respond)

If you want more detail and have SPECIFIC questions then email me ^^^^^^^^^^^^^^^^^^^^^^^^ d...@smooth1.co.uk

I though I'd start another holy war as that is all these threads are useful for!! Any I prefer vi to emacs so there! If you want a real answer ask your IBM sales rep or if you are stuck then Danilo Novelli IBM SWG Worldwide Informix Sales danilo@us.ibm.com His email address is on the first page of the presentation next to his name at http://www-5.ibm.com/be/events/download/en/informix.html Hey we are up to 14 message in this thread now...let's see if we can get into three figures shall we? Kind Regards David.

Not horseshit it was on the Slides at the may IBM Infobahn at Bedfont Lakes in the UK. I was at the front where even I could read it...

i-train education ltd www.itrainonline.co.uk Hey it's the one fujitsu put me on for part one! I asked for specific questions without that I don't know where he is coming from, what his level of knowledge is and what he does not currently understand. I suggest he contact IBM.

Madison Pruet wrote: > <prateek_mjv@yahoo.com> wrote in message > news:1126613436.424963.15010@g14g2000cwa.googlegroups.com... >> Hello Friends >> I want to give a presentation on Informix Database >> I have prepared the history,architecture and all the other required >> points >> But when comparing it with other RDBMS i am not able to find out >> sufficient point can you just help me and give me point as to why one >> should go for Informix and not oracle HERE IS HIS ORIGINAL QUESTION DANIEL O'MORGAN >> why Informix is best compared to oracle > > If you are comparing Informix with Oracle, are you also comparing DB2, > Sybase, msSQL, TeraData, PostgressSQL, msAccess, etc???? What about > CICS/IMS, DMS-1100? What about Informix-SE??? What about What about > VSAM? Cloudscape??? X10? or ... and the list goes on.... > > > The best database is the one which meets the business needs with the fewest > problems and the least cost. Since you are not including the business > requirements in this thread, it is totally impossible to respond to your > posting with any real honestity. > > yeah but check this out: Informix is easier to use than Oracle, smaller footprint, more flexible configuration, less overhead, simpler engine, less DBA intervention required. You can get a complete understanding of the product in less time than Oracle simply because there is less product to understand in Informix compared to Oracle. There is a lot more to learn in Oracle hands down compared to Informix. There is no equal in complexity with Oracle--not a negative or a positive, it's just got a lot more going on under the hood. And from a marketing perspective Informix has done its best effort to stay un-noticed, and even tried to kill itself, and tell others to go away, it doesn't want to be sold, it's an artist! Informix should be compared to Van Gogh or any of the other greats, it makes more sense that way. :-)

david@smooth1.co.uk wrote: > > I though I'd start another holy war as that is all these threads are > useful for!! > > Any I prefer vi to emacs so there! Absolutely. People that use emacs might as well be using notepad. ;-) -- Daniel A. Morgan http://www.psoug.org damorgan@x.washington.edu (replace x with u to respond)

<david@smooth1.co.uk> wrote in message news:1126651497.865096.172250@g47g2000cwa.googlegroups.com... > > Not horseshit it was on the Slides at the may IBM Infobahn at Bedfont > Lakes > in the UK. I was at the front where even I could read it... I would think you mis-read it and it said "embedded database of choice". Certainly it would have had the word embedded in it. DB2 is the OLTP database of choice.

September 2004 IBM presentation said embedded database of choice and DB/2 + Informix to merge May 2005 Infobahn said DB/2 and IDS BOTH go forward and do not merge AND said "OLTP and embedded" Maybe that's why they won't but them on the web for me.. I even asked in the last UK Usergroup Steering Committee meeting. They will "look into it". Hmmmm I want those slides...

<david@smooth1.co.uk> wrote in message news:1126638699.401097.52260@z14g2000cwz.googlegroups.com... > > Informix is supported by IBM who are not going away in fact it is the > IBM OLTP database of choice." >> Oh God, it was all going so well until you trotted out this horseshit. >> Not horseshit it was on the Slides at the may IBM Infobahn at Bedfont >> Lakes in the UK. I was at the front where even I could read it... Use your critical faculties, man! It may have said it on a slide but do just accept everything you read without question? What if another slide had said the moon was made of green cheese ...? This "embedded database of choice"stuff is just a sop to Informix. A pat on the head, a "There, there, we're not going to promote you but - tell you what - we'll stick this label on your chest". It's yet another excuse not to market Informix properly less DB2 is adversely affected.