Creating and Editing Node Groups

From ER/Studio Data Architect
Jump to: navigation, search

Go Up to Creating and Editing Database Dependent Objects

A node group is a named set of one or more database partitions. A node group can have 2 to 32 nodes defined for it. The number of nodes that is defined for the node group determines the number of systems across which the database file is created.

You may need to create a node group when you want the database files to be visible across a set of System i models in a load sharing and balancing environment. Nodegroups enable workload to be processed in parallel across a partitioned database for large tables, while smaller tables can be stored on one partition or on a small number of partitions if desired.

The following database platforms support node groups:

  • IBM DB2 for LUW 5.x, 6.x, 7.x, 8.x, 9.x, 10.x

Notepad blue icon 2.pngNote: The DB2 Nodegroup Wizard and DB2 Nodegroup Editor share the same options, except for Attachment Bindings options which are defined in the editor only.

Create a Node Group

  1. In the Data Model Explorer, expand the physical Main Model, right-click the Node Groups node, and then click New Nodegroup.
  2. Complete the Node Groups Wizard and then click Finish to create the node group.

Tip: Once you have created the auxiliary table, you can edit it by right-clicking the node group you want to change, and then clicking Edit Node Group.

Name page/tab

  • What is the name of the NodeGroup? The name must not begin with SYS or IBM.
  • Enter the nodes (partitions) to include: Specify the partition number(s). This must be a valid partition number between 0 - 999

Definition page/tab

Enter or edit a definition for the node group. If the target database supports it, ER/Studio Data Architect adds this definition as a comment when generating SQL code.

DDL page/tab

Displays the CREATE NODEGROUP statement needed to build the node group. ER/Studio Data Architect uses the platform-specific parser of the model's selected database platform to generate the node group.

Attachment Bindings tab

Bind an external piece of information, or attachment to the node group. You can also remove an attachment from an object, override an attachment binding's default value, or change the position of a bound attachment. To override the value of the attachment you have moved to the Selected Attachments grid, double-click the Value field of the target attachment. ER/Studio Data Architect opens the Value Override Editor or a list depending on the attachment datatype. Attachments are created in the Attachments folder of the Data Dictionary. For more information, see Attaching External Documents to the Data Model.

See Also