NODENAME with DB2 Multisystem

Through the NODENAME function, you can determine the name of the relational database (RDB) where a specific row of the distributed relational database is stored.

Knowing the node name 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.