CL Command Reference - CRTNODGRP
CL Command List > CRTNODGRP Reference
Description:
The Create Node Group (CRTNODGRP) command creates a node group to be used for creating distributed database files.
Examples:
Example 1: Creating a Group with Default Partitioning
CRTNODGRP NODGRP(LIB1/GROUP1)
RDB(SYSTEMA SYSTEMB SYSTEMC SYSTEMD)
TEXT(¡¯Node group for test files¡¯)
This command creates a node group containing four nodes. The partitioning attributes default to assigning one-fourth of the partitions to each node number. This node group can be used on the NODGRP parameter of the Create Physical File (CRTPF) CL command to create a distributed file. Distributed files created specifying this node group will have their data spread across the four node systems. If the records in the distributed file contain a uniform distribution of values for those fields which comprise the partition key, the records will be spread evenly between the node systems.
Example 2: Creating a Group with Specific Partitioning
CRTNODGRP NODGRP(LIB1/GROUP2) RDB(SYSTEMA SYSTEMB SYSTEMC)
PTNFILE(LIB1/PTN1)
TEXT(¡¯Partition most of the data to SYSTEMA¡¯)
This command creates a node group containing three nodes. The partitioning attributes are taken from the file called PTN1. This file can be set up to force a higher percentage of the records (or rows) to be located on a particular system.