db2 remote access? 1

[nchordiya]

I am trying to access db2 remotely via IP address,
but it is not connecting.If anybody knows a way to do.
Please reply me at nchordiya2000@yahoo.com

 

[sathyarams]

Have a look at the quick beginnings guide for information on how to configure clients ...

In short, at the client end you need a db2 client software installed ... Then catalog node and database ...

db2 catalog tcpip node <nodename> remote <ipaddress> server <server-port>

db2 catalog database <dbname> as <aliasname> at node <nodename>

You can find the server port using
On the server
db2 get dbm cfg

and see the value for the SVCENAME parameter ... If is a number, that is the port ... If it is a service name, refer /etc/services for the corresponding port number of the service

Cheers
Sathyaram

More DB2 questions answered at

http://www.dbforums.com/f8

 

[Faroon]

Is there a way to connect to a remote db2 server without the client? Anyone with experience on either UnixODBC or iODBC?

 

[sathyarams]

If I understand right, both UnixODBC and iODBC require DB2 Client Installation ...

http://www.unixodbc.org/doc/db2.html

http://www.iodbc.org/wwwboard/messages/1416.html

I do not know if this is relevent, but you can use JDBC Type 3 (support will be ending soon) and JDBC 4(support started with V8.1)

HTH

Sathyaram

More DB2 questions answered at

http://www.dbforums.com/f8

 

[Faroon]

So in other words there is no other way to connect to a remote db2 server without the DB2 client? If I have the DB2 Client (using the trial version right now) then I don't need both UnixODBC and iODBC, I just go straight to the client from perl module. I just don't want to buy the client, and also, my os is not supported by the client. Does anyone have any suggestion?

 

[ThJ]

What do you mean with connect?
running DB2 commands line ?
Use the conneciton with a language?
Perl? Cobol? Java? ....

For Java the solution is to use JDBC and the JDBC connector is coming with the DB2 server (no needs to buy something else)

HH,

Thierry

 

[Faroon]

Yes, connection with a language, preferably perl so I can query the database using sql commands. I'm willing to try any way possible to import data from the db2 server into my box. I will try JDBC. Thanks.