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?
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.