IBM has just released version 10.1 of DB2 Express-C for Linux, Unix, and Windows. This is a major upgrade that boasts a number of additions and improvements.
The already excellent performance has been improved further (including XML performance), and the free edition now takes advantage of up to 4 GB of RAM (but you can have as much RAM on the server as you wish). As usual, there are no limits on database size, number of users, etc — unlike other free versions of commercial databases that are offered by Microsoft and Oracle.
|FEATURE||DB2 Express-C 10.1||SQL Server 2012 Express||Oracle 11g Express Edition|
|Max CPUs||1 (Up to 2 Cores)||1 (Up to 4 Cores)||1|
|Max RAM||4 GB||1 GB||1 GB|
|Max DB Size||Unlimited||10 GB||11 GB|
|32/64 bit||32/64 bit||32/64 bit||32 bit|
|Supported OS||Windows/Linux/Unix & Mac*||Windows only||Windows/Linux only|
By buying a completely optional subscription for $2,150 a year, DB2 Express-C FTL (Fixed Term License) will use up to 8 GB of memory, 4 cores (as opposed to the 2 cores used by the free edition), adds 24/7 support, and a bunch of high-end features such as HADR (High-Availability and Disaster Recovery), row, column, and label access control, etcetera.
Among the numerous new features present within the free edition, you’ll find:
You can read a detailed list of what’s new in Leon Katsnelson’s article on developerWorks.
Before you ask, no DB2 Express-C 10.1 is not currently available for Mac OS X. (That’s why you see an * in the table above.) However, Mac users who reported issues with Lion, will be happy to know that a recent version aimed at addressing such issues has been released as well. It’s still DB2 Express-C 9.5.2, but it’s an out-of-beta release that should make things much smoother.
If you’d like to learn more about DB2, I invite you to check out the courses available for free on Big Data University.
I sincerely welcome and appreciate your comments, whether in agreement or dissenting with my article. However, trolling will not be tolerated. Comments are automatically closed 15 days after the publication of each article.