Tuesday, March 02, 2010

DB2 Express-C downloads restored

We had a day's outage last week during which the DB2 Express-C database server was unavailable for download. The error was on our end, and we've put processes in place to make sure it does not happen again. All the downloads are back online.

Database server

DB2 Express-C is a free relational database server. It's exactly the same code as industrial strength servers like DB2 Enterprise. You can create databases of any size with DB2 Express-C and use many advanced features.

Administrative tools

Data Studio Standalone lets you create and edit tables, views, triggers, SQL and XQuery queries, and other related goodness. It replaces the Control Center (but not the Health Center or the Task Center, which are staying around).

Developer tools

Data Studio IDE includes all the administrative functionality of Data Studio Standalone plus the ability to develop Java stored procedures. DB2 also integrates with .NET development thanks to DB2 Add-Ins for Visual Studio.

Free books

These free books are aimed to get anyone started with DB2. We've had lots of positive feedback from both university students and industry professionals who used them to learn the technology.


Leons Petrazickis
DB2 Express-C Community Team


  1. I thought Oracle compatibility was enabled in DB2 Express C 9.7.1. But
    when I did 'db2set db2_compatibility_vector=ORA' it errored out asking
    me to check the possible values.
    Is it that it isn' tenabled in Express-C yet?

  2. Hi Arun,

    Sorry for the late response. Google changed the spam filter setup and it caught your post for no reason.

    Oracle compatibility is enabled in DB2 Express-C 9.7+ with the exception of PL/SQL support. This means you can't use the ORA value, but there are numeric values you can use for the db2_compatibility_vector:


    The values are hexadecimal flags. To enable the outer join operator, you set it to 04. To enable hierarchical queries, you set it to 08.

    If you want both on, you have to do a bit of hexadecimal math. 0x04 + 0x08 = 0x0A, so you set it to 0A.


    Leons Petrazickis
    DB2 Express-C Community Team


Note: Only a member of this blog may post a comment.

Google Analytics Alternative