Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Posts
    60

    Unanswered: Partitioned Instance and Dataabse

    Hi all.

    We are trying to set up partitioned database server on 4 nodes and installed database server on all nodes. We want to create a partitioned instance and database on these nodes.

    Do we need to run db2icrt on all 4 nodes? How does this differ from non partitioned instance creation?

    Do we need to run CREATE DATABASE on all 4 nodes? How does this differ from non partitioned DATABASE creation?

    thanks
    j

  2. #2
    Join Date
    Mar 2004
    Posts
    448

    Re: Partitioned Instance and Dataabse

    Originally posted by jfkuser
    Hi all.

    We are trying to set up partitioned database server on 4 nodes and installed database server on all nodes. We want to create a partitioned instance and database on these nodes.

    Do we need to run db2icrt on all 4 nodes? How does this differ from non partitioned instance creation?

    Do we need to run CREATE DATABASE on all 4 nodes? How does this differ from non partitioned DATABASE creation?

    thanks
    j
    The instance home directory is on the NFS in a partitioned databases,
    so each machine has the same users,but sharing the same directory.
    db2icrt will be run on one node.
    Similarly create database can be run on any node, the node it runs
    will be your catalog node.contains the system tables,consider this relevant to perfamance too.
    I recommend that you should the installation manual before installing the DPS.

    Regards,

    Mujeeb

Posting Permissions

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