DB2 is a family of relational database software solutions offered by IBM. It includes standard Db2 and Db2 Warehouse editions, either deployable on-cloud, or on-premise.
$0
Oracle Database
Score 8.0 out of 10
N/A
Oracle Database, currently in edition 23ai, is a converged, multimodel database management system. It is designed to simplify development for AI, microservices, graph, document, spatial, and relational applications.
$0.05
per hour
Pricing
Db2
Oracle Database
Editions & Modules
Db2 on Cloud Lite
$0
Db2 on Cloud Standard
$99
per month
Db2 Warehouse on Cloud Flex One
$898
per month
Db2 on Cloud Enterprise
$946
per month
Db2 Warehouse on Cloud Flex for AWS
2,957
per month
Db2 Warehouse on Cloud Flex
$3,451
per month
Db2 Warehouse on Cloud Flex Performance
13,651
per month
Db2 Warehouse on Cloud Flex Performance for AWS
13,651
per month
Db2 Standard Edition
Contact Sales
Db2 Advanced Edition
Contact Sales
Oracle Base Database Service - Standard
$0.0538
per hour
Oracle Base Database Service - Enterprise
$0.1075
per hour
Oracle Base Database Service - High Performance
$0.2218
per hour
Standard Edition
Contact Sales
Enterprise Edition
Contact Sales
Personal Edition
Contact Sales
Offerings
Pricing Offerings
Db2
Oracle Database
Free Trial
Yes
Yes
Free/Freemium Version
Yes
Yes
Premium Consulting/Integration Services
No
No
Entry-level Setup Fee
Optional
No setup fee
Additional Details
—
—
More Pricing Information
Community Pulse
Db2
Oracle Database
Considered Both Products
Db2
Verified User
Anonymous
Chose Db2
Budget availability for making sure product stands test of time for scalability, secure and able to handle large data sets
From working with other databases, I always felt that Db2 was at the top of its game in all aspects of performance, recoverability, and stability—pretty much everything you want out of an Enterprise database system.
Access controls, encryption, and auditing
capabilities are just a few of the strong security features supported by IBM Db2.I think Strong security features are offered by it, such as integration with Active Directory and LDAP enterprise security infrastructures, row and column …
Db2 provides a combination of performance and scalability. Security wise, Db2 is always a first choice, especially for the systems where security can't be compromised. For mainframe systems, there is no other DB in the market that can perform better than Db2. If an organization …
we have felt Db2 with enhance capability stands better than oracle offering and cost benefit is also there with features like better security and better integration with analytical engines and provision for XML, JSON, text and spatial data formats for different kinds of …
Considering Price, features configurations timelines of the IBM Db2 we found that is very Robust in Scalability, Reliability, Highly Available. also, we are already a IBM products user and we are much satisfied with the overall product as well as customer support from IBM team. …
Compared to similar products, Db2 shared common Relational DataBase Management System (RDBMS) features such as SQL support, data integrity, Atomicity, Consistency, Isolation and Durability (ACID) Compliance and concurrency control. However, the Db2 is designed for scalability, …
Db2 is more scalable, reliable, and easily configurable than all the products that we evaluated. We were already using some of the services provided by IBM and were satisfied with the support and pricing. This led us to select Db2 as our database management system.
DB2 works as good as any of these databases. It is cheaper to run than any of them. It is more solid and stable that SQL server or Netezza. It is very comparable to Oracle for reliabilty.
But for administration, Netezza is a little simpler because it has no indexes. Netezza is …
DB2 was more scalable and easily configurable than other products we evaluated and short listed in terms of functionality and pricing. IBM also had a good demo on premise and provided us a sandbox experience to test out and play with the product and DB2 at that time came out …
Db2 is one of the best relational databases I’ve used. It has the ability to maintain large amount of data and execution of million transactions in fraction of a second. If you use it properly, an organization can build a database with thousands of tables, and it can provide …
It's almost not comparable because they all do the same job in varying degrees. There are some things I like about Db2 that I don't enjoy about Oracle, but it mostly comes down to how it works and where it stores everything like SYS tables in Db2. MySQL is probably the fastest …
I did not choose DB2 over any other database engine, the corporation we are currently working for uses all of them for different companies/systems/departments and we need to consolidate data from all of them into a single data warehouse. DB2 is one of the many different data …
Db2 is one of the oldest and mature rdbms available in the market. IBM products were already been used in the organization. Cost effective in terms of licensing.
We use IBM DB2 in AS400 to handle part of our accounting system and our legacy ERP. We are migrating all functionalities to Oracle Database 12c because it is more secure and stable. We have some applications using SQL Server but we want to handle those systems in it because at …
The reason why my team and organization chose to go with Oracle Database 12c with it stacked up against IBM's DB2, or Microsoft's SQL server, as when using other Oracle products, it has been much easier in the past to work along side with other Oracle products, which by the way …
Oracle 12c is superior to SQL Server for large mission critical databases and applications.
We also used DB2 in the past. We migrated many of our SAP applications from DB2 to Oracle 11.2 several years ago. These applications are now on Oracle 12c.
IBM DB2 is extremely heavy as compared to Oracle and is expensive for the price we pay for the product. MySQL doesn’t have most of the features that Oracle has.
MySQL: I used MySQL as part of an old CRM. I think that's also light. But, Oracle seems to have better speed and reliability. DB2: I used DB2 mainly on mainframe and z/OS. I always felt that it's cumbersome to access and write queries on DB2.
I have heard from other similar institutions that they have problems unique to their DB2 database when using the ERP that we have in common. I found the DB2 database system difficult to interact with when I had to use it for a project many years ago. I personally developed some …
I have selected Oracle database from other databases as this database is relational database which stored the data in structural and tabular format which is better than any other databases which I have used in my carrier. Also MongoDB is no SQL database where we can use SQL …
Oracle Database is best in business, consistent, and robust. Even the standard version is sufficient for the best performance. The main thing is I have never seen corruption and in my opinion, it is best when used with Linux.
While I was not available for the original selection, the reason I have fought to keep it in place and not change is mainly due to performance and security. The company has sought other options, however, I continue to maintain that this is the best course of action in our …
Oracle Database 12c is far superior to Microsoft SQL Server (or any other database in fact). For starters, Oracle 12c offers much better performance and higher reliability. That itself should make the difference. Oracle 12c is also superior in terms of features. On a high level, …
Microsoft SQL Server is our most commonly used DBMS because most vendors support it. The user interface for SQL Server Management studio is also very easy to use. For this reason, we usually prefer SQL Server over Oracle. However, we also support Oracle because it is a …
While there are several very good relational databases, some are offered by companies where the database is not the key focus. Even though Oracle's software portfolio has expanded greatly over the years, they remain keenly focused on database technology.
We generally choose Oracle 12c whenever the requirements include reliability, scalability, and interconnectivity with existing applications. Most application upgrades are re-hosted in Oracle, if on Oracle. If the application supplier prefers, or has exclusive experience with a …
I have primarily used it as the basis for a SIS - but I have migrated more than a few systems from there database systems to DB2 (Filemaker, MySQL, etc.). DB2 does have a better structural approach, as opposed to Filemaker, which allows for more data consistency, but this can also lead to an inflexibility that can sometimes be counterintuitive when attempting to compensate for the flexibility of the work environment as Schools tend to have an all in one approach.
I believe Oracle Database is still the best RDBMS database which is the database to consider for OLTP applications and for Adhoc requests. They are good in Datawarehousing in certain aspects but not the best. Oracle is also a great database for scaling up with their Clusterware solution which also makes the database highly available with services moving to the live instance without much trouble.
DB2 maintains itself very well. The Task Scheduler component of DB2 allows for statistics gathering and reorganization of indexes and tables without user interaction or without specific knowledge of cron or Windows Task Scheduler / Scheduled jobs.
Its use of ASYNC, NEARSYNC, and SYNC HADR (High Availability Disaster Recovery ) models gives you a range of options for maintaining a very high uptime ratio. Failover from PRIMARY to SECONDARY becomes very easy with just a single command or windowed mouse click.
Task Scheduler ( DB2 9.7 and earlier ) allows for jobs to be run within other jobs, and exit and error codes can define what other jobs are run. This allows for ease of maintenance without third party softwares.
Tablespace usage and automatic storage help keep your data segmented while at rest, making partitioning easier.
Ability to run commands via CLI (Command Line Interface) or via Control Center / Data Studio ( DB2 10.x+) makes administration a breeze.
New (actually it is more than five years old) multi-tenant architecture is not as straightforward as SQL Server, but it has been enhanced in Oracle 12c Release 2 and later 18c and 19c.
Many features require additional licensing (either as options or as packs) that increase the total cost
The DB2 database is a solid option for our school. We have been on this journey now for 3-4 years so we are still adapting to what it can do. We will renew our use of DB2 because we don’t see. Major need to change. Also, changing a main database in a school environment is a major project, so we’ll avoid that if possible.
It is very likely to use this 12c (or next version) of Oracle Database. Nothing close to it in the marketplace in terms of performance, reliability and overall database management efficiency. If Oracle did one thing really good - it is it's OLTP Database I must say.
You have to be well versed in using the technology, not only from a GUI interface but from a command line interface to successfully use this software to its fullest.
Many of the powerful options can be auto-configured but there are still many things to take into account at the moment of installing and configuring an Oracle Database, compared with SQL Server or other databases. At the same time, that extra complexity allows for detailed configuration and guarantees performance, scalability, availability and security.
I have never had DB2 go down unexpectedly. It just works solidly every day. When I look at the logs, sometimes DB2 has figured out there was a need to build an index. Instead of waiting for me to do it, the database automatically created the index for me. At my current company, we have had zero issues for the past 8 years. We have upgrade the server 3 times and upgraded the OS each time and the only thing we saw was that DB2 got better and faster. It is simply amazing.
The performances are exceptional if you take care to maintain the database. It is a very powerful tool and at the same time very easy to use. In our installation, we expect a DB machine on the mainframe with access to the database through ODBC connectors directly from branch servers, with fabulous end users experience.
Easily the best product support team. :) Whenever we have questions, they have answered those in a timely manner and we like how they go above and beyond to help.
1. I have very good experience with Oracle Database support team. Oracle support team has pool of talented Oracle Analyst resources in different regions. To name a few regions - EMEA, Asia, USA(EST, MST, PST), Australia. Their support staffs are very supportive, well trained, and customer focused. Whenever I open Oracle Sev1 SR(service request), I always get prompt update on my case timely. 2. Oracle has zoom call and chat session option linked to Oracle SR. Whenever you are in Oracle portal - you can chat with the Oracle Analyst who is working on your case. You can request for Oracle zoom call thru which you can share the your problem server screen in no time. This is very nice as it saves lot of time and energy in case you have to follow up with oracle support for your case. 3.Oracle has excellent knowledge base in which all the customer databases critical problems and their solutions are well documented. It is very easy to follow without consulting to support team at first.
Overall the implementation went very well and after that everything came out as expected - in terms of performance and scalability. People should always install and upgrade a stable version for production with the latest patch set updates, test properly as much as possible, and should have a backup plan if anything unexpected happens
With the other two mentioned above, I needed to have processes and frameworks that executed outside of the environment driving DB management operations. Yes, these are completely different solutions; however, the support you get for framework, library, and language support allows for runtime at a different layer than with other solutions.
Oracle Database is among the easiest to integrate with, program against, have a reliable cluster with DR, and has the most understood and well-documented databases. It suits really well if the software shop is primarily Java-based, and deals with large volumes of data with a high degree of diversity among the applications by purpose and use. Paid support is recommended as well as planned periodic patching and upgrades.
DB2 can be configured and can work with a variety of applications as opposed to how it was designed initially to only with with IBM mainframes. It's easy implementation process makes it a good buy for many organizations to scale their applications to be the best in terms of versatility, resilience and application performance
We wasted lots of money (Oracle is crazy expensive), time and effort on the project and were highly relieved when we found a different approach to supporting our aging ERP app that did not include Oracle.
Because of the difficulty of using Oracle, we spent a lot of money on consultants to help us over the conversion hump. Also wasted. And it was interesting to see them struggle with the software. Upgrades never went well always requiring multiple site visits, for example.
