Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2008
    Location
    Chennai
    Posts
    111

    Unanswered: Unable to connect to DB

    Hello,
    DB2 V8.2 WIN2003.

    I am trying to connect to the database and getting the following error.

    SQL1097N The node name was not found in the node directory. SQLSTATE=42720

    The DB2 LIST NODE DIRECTORY shows the following now. But always we had only one entry which is PRIMENODE only. I dont know that how and where the NODE name NDE40582 came from.

    Node 1 entry:

    Node name = NDE40582
    Comment =
    Directory entry type = LOCAL
    Protocol = TCPIP
    Hostname = GB-MKN-DBM11DR
    Service name = 50000

    Node 2 entry:

    Node name = PRIMNODE
    Comment =
    Directory entry type = LOCAL
    Protocol = TCPIP
    Hostname = GB-NOR-DBM11LI
    Service name = 50000


    ALSO
    DB2 LIST ADMIN NODE DIRECTORY SHOWS again two entry. but always only one entry which is Node 2 entry 'GENERATE'. and no idea of the Node 1 entry.

    Node 1 entry:

    Node name = DAS36064
    Comment =
    Directory entry type = LOCAL
    Protocol = TCPIP
    Hostname = GB-MKN-DBM11DR
    Service name = 523

    Node 2 entry:

    Node name = GENERATE
    Comment = Local workstation
    Directory entry type = LOCAL
    Protocol = LOCAL
    Instance name = DB2DAS00


    How can I resolve this please? I think something to do with catalog. But still i could not understand the catalog concept. can someone help me out?
    Thanks, Gunas.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    You should probably show us the database directory listing, not the node directory.
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Dec 2008
    Location
    Chennai
    Posts
    111

    database directory

    System Database Directory



    Number of entries in the directory = 3



    Database 1 entry:



    Database alias = DRDBASE

    Database name = DRDBASE

    Node name = DRINST

    Database release level = a.00

    Comment =

    Directory entry type = Remote

    Catalog database partition number = -1

    Alternate server hostname =

    Alternate server port number =



    Database 2 entry:



    Database alias = SIGNPLUS

    Database name = SIGNPLUS

    Node name = NDE40582

    Database release level = a.00

    Comment =

    Directory entry type = Remote

    Catalog database partition number = -1

    Alternate server hostname =

    Alternate server port number =



    Database 3 entry:



    Database alias = PRIMEDB

    Database name = SIGNPLUS

    Node name = PRIMNODE

    Database release level = a.00

    Comment =

    Directory entry type = Remote

    Catalog database partition number = -1

    Alternate server hostname =

    Alternate server port number =



    Also I am getting SQL30081N error. SQLSTATE- 08001

    thanks

Posting Permissions

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