IBM Db2 Review

Stability, scalability and security with high performance.


What is our primary use case?

Internet & Mobile banking database

E-Payroll & E-Statement solutions

Website database

What is most valuable?

A) The command set is almost the same in Windows and AIX operating systems, which greatly minimize the administration efforts to manage DB2 in both environments. Needless to say that working with the banking sector (which is my default playground) I need the ability to deal with many operating systems.

B) The ability to understand and interpret PL/SQL queries, with ease switching from Oracle to DB2.

C) Stability, scalability and security with high performance.

How has it helped my organization?

Our software products have to be PCI-DSS compliant, so encryption of customers' credit card numbers is a must-have feature. Using DB2 AWSE v11 enables us to do out-of-the-box encryption with ease.

What needs improvement?

Backing up databases from Windows and restoring them on AIX and vise-versa.

Support for migrating DB2 v9.7 to 11 in a single process with no intermediate versions jumping

For how long have I used the solution?

More than five years.

What do I think about the stability of the solution?

No.

What do I think about the scalability of the solution?

No.

How is customer service and technical support?

IBM Knowledge Base is more than enough, I never asked them for support.

Which solutions did we use previously?

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

How was the initial setup?

The initial setup is straightforward, but securing your environment is a bit more complex.

What's my experience with pricing, setup cost, and licensing?

Use DB2 Express for your development environment, but consider using Workgroup Server Edition if you need to federate two databases together or need to server a huge amount of data. If you plan to be PCI-DSS compliant, use AWSE.

Which other solutions did I evaluate?

MS SQL Server 2014 and Oracle 12g.

What other advice do I have?

I recommend it to medium-to-large enterprise applications

Disclosure: I am a real user, and this review is based on my own experience and opinions.
2 visitors found this review helpful
Add a Comment
Guest
Sign Up with Email