<model name>_NODES table
This table contains all tree nodes in the model, the parent node for every node, and explanatory information.
Note: This feature is available starting from Db2®
version 11.5.4.
The table contains one line for each tree node.The following table shows the table columns:
| Column | Data type | Description |
|---|---|---|
| NODEID | BIGINT | Index value of the node in the tree model The root node has the NODEID 1. |
| NAME | VARCHAR(100) | Name of the node The default value is NODEID. |
| DESCRIPTION | VARCHAR(10000) | Textual node description The default value is NULL. |
| SIZE | DOUBLE | Number of data records in the node |
| RELSIZE | DOUBLE | Relative size of the node, that is,the size of the current node divided by the size of the root node (NODEID 1) |
| ISLEAF | SMALLINT | Indicates whether the node is a leaf node |
| PARENT | BIGINT | NODEID of the parent node |
| CLASS | VARCHAR(<longest class size in the target column>) | Prediction for records in this node |
| IMPURITY | DOUBLE | Class impurity measure of this node |
| DEFAULTCHILD | BIGINT | NODEID of default child node If the predicate cannot be evaluated, this node is used as the successor. If the MISSINGVALUESTRATEGY parameter is not DEFAULTCHILD, this value is NULL. |