By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,924 Members | 1,651 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,924 IT Pros & Developers. It's quick & easy.

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

P: 1
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.
  5.  
  6. db2inst1@acc-intranet2:~> db2 catalog database TBIPRODD at node nd1 authentication server
  7.  
  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: "10.48.1.7".  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
Share this question for a faster answer!
Share on Google+

Post your reply

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