| Author |
Message
|
| sap3 |
 Posted: Fri Jun 05, 2015 7:20 am Post subject: Remote DB2 Database connection without DB2Client |
 |
|
Newbie
Joined: 11 Aug 2011
Posts: 9
|
Hi,
Is it possible to connect to a remote DB2 database without DB2 Client?
We are using IIB10 and the remote DB2 database for our interface to connect is DB2 V9.5 to update some of the tables
As client asked us to see other options of not installing DB2 client in server(if it is mandatory then he will approve to install client but asking for reason why db2 client is needed) where message broker is running(which is windows)Currently we are planning to use JDBC connection to access the remote database and we are using mapping node to update the database.
I did a small poc to update in my local machine where i have db2 server installed and i could able to successfully update the database by using jdbc configurable but when iam trying to connect to remote database using jdbc can i connect without installing db2 client by taking the type 4 drivers from DBA and put in a local drive and give that path to jarsURL and do the necessary update or is it mandatory to install db2 client?
Thanks, |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Fri Jun 05, 2015 7:28 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
What is the job of the db2 client?
What is the job of the type4 jdbc classes? |
|
| Back to top |
|
|
| sap3 |
| Posted: Fri Jun 05, 2015 7:40 am Post subject: |
|
|
Newbie
Joined: 11 Aug 2011
Posts: 9
|
Hi ,
for odbc connection we need to have db2 client installed in our broker server to establish connection to remote db2 database and coming to type4 driver as it will comuunicates directly with remote database using socket connection
But while going through some of the posts it was mentioned as
"you need the version of DB2 client that is known to work with the database you are trying to connect to this is true regardless of whether you are using odbc or jdbc "given by expert
Thanks |
|
| Back to top |
|
|
| mqjeff |
| Posted: Fri Jun 05, 2015 7:55 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
What is your question about the version of the driver?
What have your own answers told you about your original question?
What is your client actually asking you to do? |
|
| Back to top |
|
|
| sap3 |
| Posted: Fri Jun 05, 2015 8:07 am Post subject: |
|
|
Newbie
Joined: 11 Aug 2011
Posts: 9
|
Hi,
We need to update some of the tables in a remote DB2 database running on another server.
Our main question is if we are planning to use JDBC connection do we still need DB2 client to be installed in our broker.
Thanks, |
|
| Back to top |
|
|
| sap3 |
| Posted: Mon Jun 08, 2015 5:23 am Post subject: |
|
|
Newbie
Joined: 11 Aug 2011
Posts: 9
|
Hi,
Can anyone suggest on this request...
Thanks, |
|
| Back to top |
|
|
| mqjeff |
| Posted: Mon Jun 08, 2015 5:25 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
You've really got the answers you need.
To be more clear, you can't in general access a database without the appropriate database client or libraries.
You should really spend time asking your client what the real reason is that they're trying to do this. |
|
| Back to top |
|
|
| ganesh |
| Posted: Mon Jun 08, 2015 9:06 am Post subject: |
|
|
Master
Joined: 18 Jul 2010
Posts: 294
|
| sap3 wrote: |
Hi,
Can anyone suggest on this request...
Thanks, |
Certain data types and database functions are not supported by default driver for db2 so you would need a db2 client like db2connect to make a odbc connection.
For JDBC you can use the type 4 jdbc driver. |
|
| Back to top |
|
|
|
|
