Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003

    Unanswered: Need help - getting SQL30081N error

    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- 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?

  2. #2
    Join Date
    Aug 2001
    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

    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts