IBM Db2 Review

​A lot of scalability can be done in DB2, it only depends on the money you want to invest in that and on the functions that you really need. It can go from a free database to a very big infrastructure


What is most valuable?

  • PureScale
  • Blu acceleration
  • XML and JSON datatypes
  • Autonomous computing (storage, memory, and maintenance)
  • HADR
  • NoSQL (RDF and MongoDB).

How has it helped my organization?

Due to the stability, the applications can have a very long uptime, even with modifications in the application.

I have never needed to install a fix pack because there is a problem on the engine where new functions are used. Users forget to know that a DB2 is supporting the data.

What needs improvement?

Monitoring. There are very few applications that really monitor DB2.
Marketing. IBMers from other IBM brands, do not rely on DB2.

For how long have I used the solution?

12 years.

What was my experience with deployment of the solution?

It is easier to administer and to use than other RDBMS; however, developers like complex things and they get into trouble when using DB2 for the first time.

What do I think about the stability of the solution?

Not at all.

What do I think about the scalability of the solution?

A lot of scalability can be done in DB2, it only depends on the money you want to invest in it and on the functions that you really need. It can go from a free database to a very big infrastructure.

How is customer service and technical support?

Customer Service:

In other countries, different to US or Canada, the support is not straightforward. This product has a small market share outside North America, and for this reason, experts outside that part of the world are very few, even inside IBM. Thus, the customer support is very basic, and any medium problem needs to go to Canada.

Technical Support:

A six out of 10.

Which solutions did we use previously?

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.

How was the initial setup?

DB2 is easy to install. You just need to run the installer, and that is all. In AIX, it runs smoothly.

In Linux, it requires some libraries. Sometimes in 32 bits they are not easy to get, but once you got them, the installation is normal.

In Windows, it is just next, next. Once the binaries are installed, the instance is created in less than a minute, and it is only necessary to know what an instance means in DB2.

Finally, the database is just a command, that in some very specific cases it need extra parameters. If not, it creates a database in two minutes, and then, you have a powerful database ready to receive your data.

What other advice do I have?

If you are creating a small budget project, DB2 could be your first option. You have almost no limits with the Community-C edition (the free one), and then you can scale up to a supported version. Instead, when you have a very big infrastructure, I recommend you to check what you need, then DB2 could be a very good option.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
1 visitor found this review helpful
1 Comment
Abdel Moneim EmadReal UserLEADERBOARD

You can use also the Advanced Workgroup Server Edition (AWSE) to encrypt specific columns in your databases in a PCI-DSS compliant way, this is a hugh benefit specially for banking

05 September 17
Guest
Sign Up with Email