Results 1 to 6 of 6

Thread: DB2 Vs Informix

  1. #1
    Join Date
    Oct 2008
    Posts
    3

    Unanswered: DB2 Vs Informix

    Hi All,
    I am a student of Advance database system.I have two questions in my mind

    1) what is the biggest advantage of DB2 over Informix and whats the biggest drawback in DB2.
    2) what is the biggest advantage of Informix over DB2 and whats the biggest drawback in Informaix.


    Please anyone can help me with these two questions or any web resource which talks abt these issue.
    Thanks in advance.

  2. #2
    Join Date
    Sep 2004
    Location
    Belgium
    Posts
    1,126
    Quote Originally Posted by learningdbms
    1) what is the biggest advantage of DB2 over Informix and whats the biggest drawback in DB2.
    2) what is the biggest advantage of Informix over DB2 and whats the biggest drawback in Informix.
    Formulating differences and advantages is very difficult, mainly because (1) there are not that many people who know the two products well enough to compare, and (2) because advantages/disadvantages are measured w.r.t. a certain goal, and different people use RDBMSs for different purposes, hence will see different good or bad points in a certain product.

    Anyhow, GOOGLE and Wikipedia are always good tools to find (partial) answers on this kind of questions:
    See e.g. http://www.theregister.co.uk/2004/10..._informix_db2/
    --_Peter Vanroose,
    __IBM Certified Database Administrator, DB2 9 for z/OS
    __IBM Certified Application Developer
    __ABIS Training and Consulting
    __http://www.abis.be/

  3. #3
    Join Date
    Oct 2008
    Posts
    3
    yes ur rite bt actually i was trying to compare size limitation of both of these,like what is Max database size,what is Max table size,max number of columns in a row,Max Blob/Clob size ? in DB2 and Informix.

    If anyone can provide me with these info abt Informix.I got DB2 info. bt not Informix....

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Did you try the Informix forum on this site?
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Oct 2008
    Posts
    3
    i didnt find this info in Informix forum




    www.farazch.byethost13.com

  6. #6
    Join Date
    Aug 2006
    Location
    The Netherlands
    Posts
    248

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •