473,246 Members | 1,350 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,246 software developers and data experts.

Linux DB2 Client Hangs when Connecting to Remote Host


I'm having a problem connecting to DB2 on a remote iSeries host from a Linux server, both of which reside on my company's internal network. I'm using the IBM Linux Client V9.1. When I try to connect to the remote host using a simple connect statement, DB2 hangs.

The connection statement I'm using (I've obviously obscured the parameter names):

Expand|Select|Wrap|Line Numbers
  1. $ ./db2 connect to DATABASENAME user USERNAME using PASSWORD;
The user name and password that I am using are correct. I can login to the iSeries directly using the iSeries Navigator utility. There is also a WebSphere server on the network that is able to access the same iSeries host remotely using the same login and password via JDBC.

DB2DIAG.LOG does not show any errors when the application hangs when attempting to connect to this port (8471) or other open ports (8470, 8472, etc.). When I attempt to connect to a closed port (50000), DB2 connect returns an error and the error does show up in DB2DIAG.LOG (DIA3202C The TCP/IP call "connect" returned an errno="111".).

Here are the commands I typed to create the db directory and node directory listings:

Expand|Select|Wrap|Line Numbers
  1. $ ./db2 catalog db DATABASENAME at node xxxx
  2. $ ./db2 catalog tcpip4 node xxxx remote server 8471
Here is what the db directory and node directory listings look like:

Expand|Select|Wrap|Line Numbers
  1. $ ./db2 list db directory
  3.  System Database Directory
  5.  Number of entries in the directory = 1
  7. Database 1 entry:
  9.  Database alias                       = DATABASENAME
  10.  Database name                          = DATABASENAME
  11.  Node name                            = XXXX
  12.  Database release level               = b.00
  13.  Comment                              =
  14.  Directory entry type                 = Remote
  15.  Catalog database partition number    = -1
  16.  Alternate server hostname            =
  17.  Alternate server port number         =
  20. $ ./db2 list node directory
  22.  Node Directory
  24.  Number of entries in the directory = 1
  26. Node 1 entry:
  28.  Node name                      = XXXX
  29.  Comment                        =
  30.  Directory entry type           = LOCAL
  31.  Protocol                       = TCPIP4
  32.  Hostname                       =
  33.  Service name                   = 8471
Any ideas of what could be wrong here? Thanks in advance!
Feb 1 '08 #1
1 9146
127 Expert 100+
Actually DB2 might not have hanged but was trying for the connection. If there is anything wrong with the configuration, then DB2 will keep on retrying untill Number Of Retries exceeds certain number.

1. Ensure that you are using correct IP address. (Looks find from the details that you have sent)
2. Check the port numbers; (DBM cfg parameter)

3. set DB2COMM=tcpip

Let me know if you still have problems or if the solution was something else.

-- Sanjay
Feb 27 '08 #2

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

Similar topics

by: Google Mike | last post by:
After a lot of thought and research, and playing with FreeTDS and InlineTDS, as well as various ODBC connections, I have determined that the fastest and cheapest way to get up and going with PHP on...
by: Chris | last post by:
A weird issue...though hopefully not for everyone... I am trying to connect to a 10g database on a Red Hat Linux server from my 9i client on a XP pc. Both are on my local home network, behind...
by: Prince Kumar | last post by:
I joined a company recently and they have a java program which hangs (does nothing) after a while. This is no way consistent. It could succeed quite a few times and can fail a few other times....
by: Timothy Shih | last post by:
Hi, I am having a freezing issue with my application. My application serves several remotable objects, all of which must be initialized before their use. Furthermore, some of them depend on each...
by: Morten | last post by:
How do I detect if a client socket is no longer connected to the listen tcp socket ? I have tried with (just an example): --------------------- Socket tcpSocket; ...
by: Russ | last post by:
I have set up a C# web application that runs on my test Web Server (Windows 2003 Server, Web Edition). It in turn calls a web service running on the internal network. Now I want to issue a...
by: Sharon | last post by:
Hi, I'm using the remoting, and I have a remoting object that has a public event that other processes should register to it. But when the client process is registering to the remote event, it...
by: The D0ct0r | last post by:
Hi People, I am working on a tcp client/server, using this tutorial: http://tldp.org/ LDP/LG/issue74/tougher.html Everything works fine, as long as I connect to my own machine (localhost) When...
by: nevviin | last post by:
Hi, I have developed a VB.NET windows application to read mails from the server. I am using tcpclient object to read mail from mail server. I am uisng the IMAP and POP protocols for reading...
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.