IIS-CONN-DB2-00708E Node Node specified in the node map constraint is not valid for table. When running on Db2 nodes, only nodes corresponding to physical Db2 nodes that host table partitions can be specified. Note that the table may not span all available partitions in the database

Explanation

The Node node specified in the node map constraint is not valid for the table. When running on Db2 nodes, you can specify only the nodes that correspond to the physical Db2 nodes that host table partitions. The table cannot span all available partitions in the database.

Typically this error occurs when the specified node is a Db2 node that is not used by the table that you are reading from or writing to, but the environment is constrained to run on the specified node. In other words, the environment specifies through a constraint that the specified Db2 node must be used even though it is not used by the table.

User response

Do one of the following actions:
  • Remove the node constraint that requires the specified node to be used
  • Modify the table so that it spans the specified node.