467,209 Members | 1,356 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,209 developers. It's quick & easy.

Need help getting DB2 Connect to catalog a remote AS400 DB2 server

Here's the situation:

I'm trying to get DB2 Connect, running on a linux web server, to connect to a backend DB2 database, running on an iSeries AS400.

I am 100% green when it comes to AS400s and DB2... so keep that in mind.

Here's what I've tried:

Expand|Select|Wrap|Line Numbers
  1. db2inst1@acc-intranet2:~> db2 catalog tcpip node nd1 remote rochester.atlascopco.net server 50000
  2. DB20000I  The CATALOG TCPIP NODE command completed successfully.
  3. DB21056W  Directory changes may not be effective until the directory cache is 
  4. refreshed.
  6. db2inst1@acc-intranet2:~> db2 catalog database TBIPRODD at node nd1 authentication server
  8. db2inst1@acc-intranet2:~> db2 connect to TBIPRODD user tbiweb using ********
  9. SQL30081N  A communication error has been detected.  Communication protocol 
  10. being used: "TCP/IP".  Communication API being used: "SOCKETS".  Location 
  11. where the error was detected: "".  Communication function detecting 
  12. the error: "connect".  Protocol specific error code(s): "111", "*", "*".  
  13. SQLSTATE=08001
Now I figure that error means that it failed to connect via port 50000 (which I read somewhere is the default port). I can't telnet to that port either, so it's definitely not open.
What do I have to do to prepare the AS400 to receive connections from DB2 Connect?
Aug 3 '07 #1
  • viewed: 3285

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by banz@glion.ch | last post: by
16 posts views Thread by peshekeedweller | last post: by
3 posts views Thread by hkappleorange | last post: by
11 posts views Thread by Mikael Arhelger | last post: by
10 posts views Thread by blurryimage@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.