Db2 excels in handling large datasets. But Oracle is strong, too. I can't definitively compare which is better, Db2 or Oracle, because Db2 integrates seamlessly with existing IBM solutions by design. That's their database, after all. 

Typically, we use Oracle in conjunction with Java and their mainframe systems, specifically their ERP systems. So, each has its own merits. It really depends on our specific needs and the features required for either the core government solution or our own custom wrapper. Honestly, it's tough to declare Db2 or Oracle inherently better based on features alone.

View full review »

We used and continue to use other RDBMS solutions other than Db2 Database. We use Microsoft Sequence Server, PostgreSQL and to a certain extent Oracle for different user systems. 

View full review »

I've used SQL Server for a very long time. Microsoft SQL Server is quite easy to use from a beginner’s perspective. Its user interface is very intuitive and quite easy to use.

View full review »

I am familiar with the Microsoft SQL Server, which is more user-friendly and has more user-friendly features. We're also exploring moving away from this solution to more cloud-based Azure services. 

View full review »

I have previously used Oracle.

View full review »

I'm also familiar with Oracle solutions. Oracle is more expensive.

View full review »

Before Db2, we used IMS. It was years ago, and currently, in addition to Db2, the same organization is using Oracle, MSSQL, MySQL, and even NoSQL databases, such as MongoDB. During the past five years or so, the NoSQL databases are getting in as well. So, we are using a few RDBMSs and NoSQL databases as well in parallel.

When I compare IBM's mainframe Db2 for z/OS with other relational database management systems, this one wins against almost each and every other database in terms of abilities and performance. Optimizing the scales or optimizer for creating the access process is probably the best in the world. In many aspects, Db2 wins against almost each and every other RDBMS, including Oracle, Microsoft, MySQL, and NoSQL ones. However, in the area of complexity and maintenance, probably the others are better.

View full review »

I have used MySQL and Oracle in my previous environments. We switched to IBM Db2 Database for auto-management features and reduced manual intervention.

View full review »

I have some experience with Terraform, from HashiCorp. 

It's a tool for infrastructure, for building automation similar to Jenkins, or Bamboo.

I worked with Bamboo a year ago.

I have worked with databases such as MySQL, IBM Db2, Oracle DB, and some NoSQL databases like MongoDB. We use the threat procedures when we used Oracle DB.

View full review »

Previously, we used COBOL with a database sold by Computer Associates. We didn't have lot of choices for mainframes at the time. The best database that can run on the mainframe is the IBM Db2 Database, and we have stayed with Db2 from 2000 to the present.

View full review »

Previously we were using SQL Server.

The main difference is the pricing and implementation.

View full review »

We previously used POWER5 and POWER7 so have been with the solution for some time. 

View full review »

We are a typical enterprise with the typical array of databases. Primarily we use Db2 and MS SQL, and some others. We have reporting tools like Business Objects, Power BI and Micro Strategy. We also have data warehouses. So we have ETL tools and then we need to have the backups, scheduling, and monitoring. We are using more than one database type for different reasons, so it is not exactly that we have switched away from something else to Db2.  

View full review »

Previously, we were using the WebSphere Application Server. Those applications are in maintenance mode.

We also worked with the Application Developer,m which is the Rational Application Developer for WebSphere software. It is running on legacy Java version 8.

No one is currently using this software because everyone has upgraded to the latest version, but our application is still running with an older version. I don't believe anyone is currently using the older version of Java and the Application Developer that we are.

It's an older version of Java, and I don't believe any developmental improvements will be made to the tool as of now. Because we are not using the most recent version of the tool and the most recent version of the WebSphere Application Server, the feedback I could provide may be ineffective.

We are in the process of migrating to the AWS Cloud.

Our design approach is to convert our monolithic applications to microservices.

We have not used Hadoop, High-Availability Clustering, or Backup and Recovery, we only use the Application Server to host our applications.

View full review »

I have used SQL Server, IBM Db2, and Oracle Database. Microsoft provides usability. SQL Server is very easy to use and adapt. The only problem is that it only lives within the Microsoft Windows operating system, whereas Db2 is available on Linux, Unix, Windows, and Linux for mainframes. 

When comparing IBM Db2 and Oracle Database, I would go for IBM Db2 because it has complete functionality. A lot of features available in IBM Db2 are not there in Oracle Database. IBM Db2 has time travel queries that are not available in any other solution. From the perspective of a software developer or a database developer, there are more functionalities in IBM Db2. It is more futuristic.

View full review »

From a performance perspective, I prefer SAP HANA for performance.

View full review »

I have previously used Teradata and I started my career on it as a developer. I was doing migrations from Db2 or different databases to Teradata. The database of Teradata is very useful and is performance-based when it comes to data warehouse solutions.

View full review »

We migrated from Oracle Database to Db2 Database because it was quite a good and cost-effective solution. Oracle Database was coming out to be expensive.

View full review »

I have used Oracle in the past. In Comparison, IBM provides better performance and scalability features.

View full review »

In my scenario, I have installed both Db2 and Oracle for different use cases. I have not personally found that much of a difference. But I think the difference between this Db2 is what the customer wants. Some want to work on Db2 and some want to work with Oracle.  

One feature I like in Db2 is the self-maintenance feature. That maintenance feature or something like it is not found in Oracle. With Db2, it is safe to use self-maintenance with any data and that is the main feature in Db2 that I like.  

View full review »

We used XDB (Micro Focus RDBMS equivalent to DB2) which used to have scalability and reliability issues in our development environments. We switched to IBM UDB DB2 in our DEV environments on account of its reliability and scalability.

View full review »

I also have experience with Oracle.

View full review »

I have not used other solutions in this category other than IBM Db2 Database.

View full review »

We have not used any external security managers other than RACF to safeguard the mainframe DB2 environment. At one point I was involved in looking at IBM’s zSecure product as an alternative RACF security and audit tool.

View full review »

N/A.

View full review »

I also have experience with Oracle databases. I find Oracle to be a bit better than Db2 if I'm honest. They have a lot of functionality, for example, and can handle backup and recovery of data. This is not possible on Db2.

View full review »

We previously used Oracle, Microsoft SQL Server, and MySQL which is an open-source database. 

View full review »

I have also worked with Microsoft SQL server. This product is easy to use. It is also smarter in optimizing the queries. Microsoft SQL serves is also easy to maintain on the operations side when compared to IBM Db2. 

View full review »

I have used a little bit of Oracle, SQL Server, PostgresSQL, and MySQL. They are good platforms, but they are not as easy to work with as DB2 is.

View full review »

No. I have previous experience extensive with Oracle, SQL Server and Sybase. It is a good product. Better than Sybase, but not as good as Oracle, and comparable to SQL Server. 

View full review »

Prior to using this solution I was using Oracle, although it was not for exactly the same purpose.

View full review »

We switched from VSAM to DB2. DB2 is much more sophisticated and advanced than VSAM and provides a number of features which make it easier to access the data and present it, as well as use it. View full review »

I used Oracle DB and am still using it with some of my customers, but Oracle administration is a nightmare compared to DB2.

View full review »

I did not use a different solution prior to IBM DB2.

View full review »

We also use SAP HANA. These are two different applications, however, and they have different use cases. HANA runs on memory. Db2 is a much more mature, older technology with its own platform. HANA is not that new but it's not that old either. It's much faster for sure. The difference is one is in-memory computing, while the other is a traditional database on hardware on the IBM platform.

View full review »

No, I selected DB2 based on previous experience with Oracle and after a brief look at MS SQL.

View full review »

See my answer to the 'Stability' question.

View full review »

I have used previously Cisco MySQL, SQL Server, SAP HANNA, and IBM DB2.

View full review »