Relational Databases Forum
Jan 29 2020
One of the most popular comparisons on IT Central Station is IBM DB2 vs Oracle Database. What is the biggest difference between these two solutions? Which would you recommend? Thanks for your help! --Rhea
Rehana ParvinI think -- Oracle is well known for its performance and security feature and continuous efforts to reach the highest level of performance. A few comparisons are given below: 1. Oracle has multi version read consistency -- but not in DB2 2. In oracle, neither read nor write blocks each other-- DB2 -read blocks write and write blocks read 3. No Dead locks under load in Oracle whereas deadlock is a serious problem in DB2 4. In Oracle --intelligent advisories such as SQL Tuning, Index, Summary, MTTR but in DB2 only Index advisory presents. In terms of Self-tuning capabilities-- Oracle has Automatic Performance Diagnosis, Automatic SQL Tuning , Self-tuning memory, free space, and I/O management and so on but in DB2 No equivalent or limited capabilities Besides all good features exist in Oracle but it is bit complex. When problem occurs then figuring out the right problem in a very short time has become a challenge, Also Oracle is bit expensive. There are a lot more difference. I think you can find good resource by searching online. I think all database software has their own advantages and disadvantages. Depending on the budget and compromises in which feature loss they can afford--companies decide their choices.
Martin Spratt (2300+ Connections)Both DB2 and Oracle are legacy relational databases. 20+ years ago you might pick DB2 for reliability and scalability, but today you would choose Oracle for the sheer size of partners, applications, skills and tools available. So if you have to pick today, I would choose Oracle (I am an ex IBM DB2 Lab person and used to be VERY DB2 bias as it's an excellent engine)... and if I ask you more detailed application and business landscape questions I would recommend decommissioning BOTH those legacy databases and move to PostgreSQL, MariaDB or MySQL (MySQL is ironically now owned by Oracle too), and cloud host your database farm. If you had to pick a legacy "perpetual license" relational database I would go wall to wall MS SQLServer. That's what I would generally recommend without knowing more about your application or business landscape. (SAP, Apps, Mobility, Cloud, Regulatory, Security, HA, Scale, etc etc).
Leonidas GiannoulisWe use both databases (and some more), I would definitely suggest using Oracle against DB2 for better performance but also because it's easier to find collaboration tools and find help. PS : My preference is MS SQL.
Dec 10 2019
Let the community know what you think. Share your opinions now!
it_user182115Backup and replication options.
Mohammad DastpakAt the first based on my experience we need to calculate software or customer requirements and after that choose the best option. Today all databases have the same options with little difference like Data types, HA, Performance, Security, Backup/Recovery, etc. for example if you want to design a software with just 5 to 20 users, is that reasonable to use Oracle database service ? however, from a programmer's point of view evaluating Relational Databases are rated by features like Datatypes, Functions, Index types and etc, DBA's (Database Administrators) vision is different. So my list is - TCO (Total cost of ownership) - High Availability Solutions. - Backup / Restore solutions. - Performance - Data Capacity and Security. - Memory Management. - Caching - Inmemory Database, Tablespace, Table. - 3rd Party software
Agus NurhalimMy priorities: 1. Backup and recovery 2. Data security 3. Price 4. Performance