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", "*".
The db2diag.log file shows:
2004-08-10-188.8.131.52725 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?