- Blu acceleration
- XML and JSON datatypes
- Autonomous computing (storage, memory, and maintenance)
- NoSQL (RDF and MongoDB).
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.
Monitoring. There are very few applications that really monitor DB2.
Marketing. IBMers from other IBM brands, do not rely on DB2.
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.
Not at all.
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.
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.
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.
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.
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.