IPROC

Purpose

This function returns the local node number within the cluster. By that, you can visualize which rows are stored on which nodes.

Syntax

iproc::=

Usage Notes

  • The result value is an integer between 0 and NPROC-1.
  • Only active database nodes are counted, not reserve nodes.
  • In this context, please also note functions NPROC and VALUE2PROC.

Example

SELECT c1, IPROC() IPROC FROM t ORDER BY c1;
Result
C1 IPROC
1 0
2 1
3 2
4 3