NODENUMBER with DB2® Multisystem

Through the NODENUMBER function, you can determine the node number where a specific row of the distributed relational database is stored.

The node number is the unique number assigned to each node within a node group when the node group was created. Knowing the node number allows you to determine the system name that contains the row. This can be useful in determining if you want to redistribute certain rows to a specific node.