Hi All,

Follow below steps to install IBM DB2 Drivers.

/wp-content/uploads/2015/11/db2_824747.png

The double click v9.7fp4_ntx64_rtcl_EN


/wp-content/uploads/2015/11/db2_824747.png

Select yes

/wp-content/uploads/2015/11/db2_824747.png

Preparation installation screen allow to run though


/wp-content/uploads/2015/11/db2_824747.png


Select next

/wp-content/uploads/2015/11/db2_824747.png

accept the terms in the license agreement and then next

/wp-content/uploads/2015/11/db2_824747.png

Leave the  default typical and then select next

/wp-content/uploads/2015/11/db2_824747.png


Select install


/wp-content/uploads/2015/11/db2_824747.png

Review the installation screen

/wp-content/uploads/2015/11/db2_824747.png


Select finish to complete installation


You have now the software installed

To review your software you can Select all programs >  control panel >  uninstall software and you can see the software installed as screen shot below

/wp-content/uploads/2015/11/db2_824747.png

once we successfully install DB2 then  Create of DB2 ODBC connection:

Here are the steps for creating DB2 ODBC connection:

Navigate to start button and select Data Sources (ODBC) from Administrative tools.

/wp-content/uploads/2015/11/db2_824747.png

/wp-content/uploads/2015/11/db2_824747.png

Select System DSN and Add button and select IBM DB2 Driver

/wp-content/uploads/2015/11/db2_824747.png

And enter all require details

/wp-content/uploads/2015/11/db2_824747.png

/wp-content/uploads/2015/11/db2_824747.png

Once you fill all the details then click on test connection whether connection is working fine or not.

/wp-content/uploads/2015/11/db2_824747.png

If connection details are wrong you cant delete entry directly from system DSN.

we should follow below steps to delete the entry from installed folder

/wp-content/uploads/2015/11/db2_824747.png

If connection is working fine please navigate to designer and create new data store

/wp-content/uploads/2015/11/db2_824747.png

And click on apply button.

And test by running the job which pulls data from DB2 source.

Cheers

Sagar T

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply