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.

• Example of NODENUMBER with DB2 Multisystem
  Here is an example of how to use the NODENUMBER function.

 

Parent topic:

Scalar functions available with DB2 Multisystem