Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2011
    Posts
    11

    Unanswered: Nodes of partitioned database!

    As we know ,we can add a new node to instance without adding it to the database by editing the "db2nodes.cfg" when the instance is down and bringing up the instance. At this point the new partition is only added to the instance and it is not added to the databases in the instance.

    My Question:
    How to find the current nodes of a partitioned database?

  2. #2
    Join Date
    Oct 2007
    Posts
    246
    "db2 values current dbpartitionnum"
    to find the current node

    db2 list dbpartitionnums which will give u the number of partition

    and if you new partition is add to a partition group then this will also appear in list

    regds
    Paul
    Last edited by Mathew_paul; 03-05-11 at 13:43.

  3. #3
    Join Date
    Mar 2011
    Posts
    11
    It works. Thank you, Paul.

Posting Permissions

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