Friday, August 10, 2012

Installing DB2 Express 10.1

I accidentally installed DB2 Express-C 10.1, mistakenly thinking it would work for MDM Workbench.  It will not!  Not in Workbench 10.0, at least.  However, I didn't want to dispose of the data so here is another article.


Ok, let's prepare to install DB2.  First, we must create the users.  Let's create a user, db2admin, as an Administrator.  I am assuming a basic, non-AD install (on my local network I use AD and will detail its usage in a later article).

Adding db2admin with a simple password
 Add the user to the administrators group by right-clicking the user, selecting properties, then adding to a group.  Type "Administrator" in the box and select "Check Names".  It should create something like the below image.

Adding the user to the local Administrators group
Ok, that's about it.  Since we're dealing with Windows instead of *nix, we don't have to set any kernel parameters (although this would be the time for it), so we can proceed with the install.  I am using DB2 Express-C Windows X64 since I haven't done that before.  It's a free download from IBM's external web site.  The version as of this writing is 10.1.  One thing I try to do is install every IBM program to C:\IBM instead of C:\Program Files\IBM (or whatever the default is).  This will be reflected in every step including this one.  Note: ALWAYS run this as Administrator (which may require you to do a right click-> Run as Administrator).

Downloading DB2 Express-C from the IBM Website using DownloadDirector

Starting installation 

Using the db2admin local user (no AD) 

It installed successfully, but I saw no need to capture that screen shot.  Don't do anything further at this point.