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.