I'm trying to catalog a client connection using the following commands:

db2 catalog tcpip node node remote <ip_address> server 50001
db2 catalog database MPP as PQA_MPP at node node authentication client


When I try to connect to the db (PQA_MPP) i get the following error:


db2 connect to PQA_MPP

SQL30081N A communication error has been detected. Communication protocol
being used: "TCP/IP". Communication API being used: "SOCKETS". Location
where the error was detected: "". Communication function detecting the error:
"gethostbyname". Protocol specific error code(s): "*", "2", "*".
SQLSTATE=08001


The db2diag.log file shows:

2004-08-10-22.38.11.241725 Instance:db2adm Node:000
PID:9382(db2bp) TID:8192 Appid:none
common communication sqlcctcpconnr Probe:42

DIA3207E The TCP/IP call "gethostbyname" returned h_errno="2".



I can't find any info on this "gethostname" error. What am i missing here?

Have you defined the node using hostname ? Looks like there is no DNS entry for the name in your network ...

Get your network admin to create a DNS entry or define locally in /etc/hosts or redefine the node using ip-adress

Cheers
Sathyaram