Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2008
    Location
    Toronto, Canada
    Posts
    399

    Unanswered: how to catalog db on another server

    our application server is devxxxx2 with instance db2v8c1, our db server is devdb2 and I created a new db db1 on devdb2 in new instance db2v8s1. There are other instances on devdb2 server - db2v8i1, db2v8q1, etc.

    How do I catalog this new db db1 on the application server if we have 3 other instances on the db server? Catalog db command does not specify where remote instance/server is. Pls help (ask more questions if not enough info)
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Catalog the node first.

    Andy

  3. #3
    Join Date
    Dec 2008
    Location
    Toronto, Canada
    Posts
    399
    there are 4 nodes on devxxxx2 appl server:

    devxxxx2: db2 list node directory
    Node 1 entry:
    Node name = D1DEVDB2
    Comment =
    Directory entry type = LOCAL
    Protocol = TCPIP
    Hostname = devdb2
    Service name = 60012
    Node 2 entry:
    Node name = I1DEVDB2
    Comment =
    Directory entry type = LOCAL
    Protocol = TCPIP
    Hostname = devdb2
    Service name = 50000
    Node 3 entry:
    Node name = PFDEVDB2
    Comment =
    Directory entry type = LOCAL
    Protocol = TCPIP
    Hostname = devdb2
    Service name = 50004

    Which one should I catalog? Aren't they already cataloged?
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    You need to catalog this node : db2v8s1. Then catalog the DB at that node.

    Andy

  5. #5
    Join Date
    Dec 2008
    Location
    Toronto, Canada
    Posts
    399
    Quote Originally Posted by ARWinner
    You need to catalog this node : db2v8s1. Then catalog the DB at that node.

    Andy
    I got it - 'instance' is 'node' in this case, right?
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

  6. #6
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    That would be a correct statement.

    Andy

Posting Permissions

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