Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2015
    Posts
    4

    Unanswered: How to check this kind of DB info?

    When I run db2 list DB directory on server1, the only one information for DB01, there are not any "Indirect" info for DB01,

    Database alias = DB01
    Database name = DB01
    Node name = DB201
    Database release level = d.00
    Comment =
    Directory entry type = Remote
    Catalog database partition number = -1
    Alternate server hostname =
    Alternate server port number =




    and db2 list node directory on server1,

    Node name = DB201
    Comment =
    Directory entry type = LOCAL
    Protocol = TCPIP
    Hostname = server1
    Service name = 60009

    When I run: connect to DB01 and values current server, it shows:

    DB03.

    On DB2 list db directory, there is one item for DB03, that means DB03 is the local DB on server1,

    Database alias = DB03
    Database name = DB03
    Local database directory = /databaseserver1
    Database release level = d.00
    Comment =
    Directory entry type = Indirect
    Catalog database partition number = 0
    Alternate server hostname =
    Alternate server port number =

    But I cannot find any relations from list DB directory between DB01 and DB03. How DB01 created?

    And for some other DB, like DB04, what's different DB04 and DB01?

    Database alias = DB04
    Database name = DB03
    Node name = DB201
    Database release level = b.00
    Comment =
    Directory entry type = Remote
    Authentication = SERVER
    Catalog database partition number = -1
    Alternate server hostname =
    Alternate server port number =

    Thanks a lot!

  2. #2
    Join Date
    May 2012
    Location
    Canberra, Australia
    Posts
    176
    Provided Answers: 6
    I guess an initial question is ... "why do you have a loopback node?"
    Andy

    "All parts should go together without forcing. You must remember that the parts you are reassembling were disassembled by you. Therefore, if you can’t get them together again, there must be a reason. By all means, do not use hammer.” — IBM maintenance manual, 1975 "

Posting Permissions

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