Installing Db2 Client On Windows

Posted on  by 

These are DB2 versions that are supported on Windows 10. DB2 Server and Client Packages: DB2 v11.1. IBM Data Server Driver Clients IBM Data Server Driver for ODBC and CLI (32-bit and 64-bit) IBM Data Server Driver Package IBM Data Server Driver for JDBC and SQLJ. These are the DB2 releases that will be supported on Windows 10. DB2 v10.1 FP6.

(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.

While installing DB2 for Windows on or prior to 10.5 Fix Pack 3, 10.1 Fix Pack 3 and 9.7 Fix Pack 9 on Windows 8.1 and Windows 2012 R2, you might receive GUI related errors, errors related to shortcuts created during the installation, and errors pertaining to the db2prereqcheck tool. Db2cae.cmd for DB2 Client Application Enabler db2sdk.cmd for DB2 Software Developer's Kit. For Windows 3.x, the BAT files are: e: clients windows db2caew.bat for DB2 Client Application Enabler e: clients windows db2sdkw.bat for DB2 Software Developer's Kit. Edit the command in the file, to fill in the information needed for the installation.


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...
Free db2 client downloadBut 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.

Comments below were made on a legacy Blog, before move to current Blog (February 2019)

Client

Db2 Client Installation On Windows

Hi, this helped me out a lot.

Installing Db2 Client On Windows

Db2 Client Tools For Windows

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.

Install Db2 On Windows 10

You need to run c:WindowsSysWOW64odbcad32.e

Unless otherwise specified, all content is licensed under Creative Commons by Attribution 3.0 (CC-BY).

Db2 Client Tool

Externally linked images and content are not included and are licensed and copyrighted separately.

Coments are closed