Monday, 31 May 2010

DB2 client on Windows 7

(Unfortunetly) I have been trying to install DB2 on my Windows 7 laptop as my recent assignment is very Websphere/DB2 centric. And even the unit test rely on a DB2 database.

For some reason v9.5 of DB2 Enterprise server does not like my laptop. :(

But we have standardised VM images of the DB2/Websphere set up that I could use, which is a very good practice. However as we use the type2 jdbc driver you still need a local DB2 Client installed, which again did not work...

But my solution did work: I installed the simpler Runtime Client.

Here is the steps I took.

  1. Installed our pre configured VM image

  2. Downloaded our ready made DB2 profile configuration txt file for the VM

  3. Modified my host file to alias the hostname used in txt file correctly to my VM's IP

  4. I read "Which DB2 9.5 client connectivity option is right for you?",

  5. downloaded the DB2 v9.5 Runtime Client and installed it

  6. and applied the tips on howto import the profile configuration by command line via db2cfimp file.txt

Hope this is of use to others with DB2 + Windows 7 grievances.


Tim Poultney said...
This comment has been removed by the author.
Tim Poultney said...

Hi, this helped me out a lot.

If you're using Windows 7 64 bit, bear in mind that you need to use the 32 bit version of the ODBC Data Source Administrator which can then access the 32 bit DB2 driver.

You need to run c:\Windows\SysWOW64\odbcad32.exe