Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to connect to remote Database Using IPAddress

 
vikram nalagampalli
Ranch Hand
Posts: 91
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello all,
I am trying to connect to a Remote DB2 dtaabase. I have the following information
ServerName: INDIA
IP Address:1.95.23.817
username:gpdb2user
password:gpdb2user
InstanceB2
Database:REG
I am currently using the following fromat
url= "jdbc b2:@1.95.23.817:INDIA:REG"
I really doubt if this right, Can some one tell me if i am doing it right , if not the best way to call in this situations.
Thanks in advance, I am in stake mate at this point, unless some one helps me i cant go further, So pls suggest me asap.
Thank you
Regards
Vikram
 
Bruce Jin
Ranch Hand
Posts: 672
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I think you need to have a driver that supports remote database access. For example, IBM tollbox (http://www-1.ibm.com/servers/eserver/iseries/toolbox/ ) has a jdbc driver that allow people to connect to remote DB2. (this remote db2 maybe limited to AS400 db2).
 
Bruce Jin
Ranch Hand
Posts: 672
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The toolbox driver (for remote access as400 db2) is:
com.ibm.as400.access.AS400JDBCDriver
if you have an as400, the toolbox should be installed. its name is jt400.zip.
 
Monty Ireland
Ranch Hand
Posts: 161
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
There may be another way to solve your problem.
If you are using a UDB version of DB2.
You can use Client Confifurations Assitant (cca)
to help you.
I can help ... if you are using a UDB version of DB2.
I need to know few things first:
1. OS of client
2. OS of database server
3. version of java on client, web server, and/or database server
4. need to know how many machines.
FYI, if you are using a UDB version of DB2. Connectivity should take about 15 minutes to setup and run from scratch
!@# usiing CCA odbc and/or CLI 1st for about an hour will help you define IP address and/or db alias names
[ December 27, 2002: Message edited by: Monty Ireland ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic