Maintaining Node Groups (DB2 UDB for UNIX and
Windows) 
Use
Using the node group list on the Configuration: Node Groups screen, you can maintain node group entries as follows:
· Change node groups, that is add or remove partitions
· Add new node groups
· Delete node groups
Procedure
Changing Node Groups
...
1.
On the Configuration: Node Groups screen, choose
Edit.
The Configuration: Node Group Maintenance – Change Node Group screen appears.
The following information is displayed:
Partitions
This tabstrip contains a list of all partitions of the node group.
|
Field |
Description |
|
Partition |
Number of the partition |
|
Status |
Current status of the partition. The following values are possible: · Status information not available Displayed for node group IBMTEMPGROUP or if the status cannot be determined. · Partition not in partitioning map; containers not yet created Partition has been created without containers and is not yet referenced in the partitioning map. · Partition not in partitioning map; containers created Partition and containers have been created, but partition is not yet referenced in the partitioning map. · Partition in partitioning map; containers created · Partition will be dropped after next redistribution For more information, see the DB2 Administration Guide. |
Buffer Pools
This tabstrip contains a list of all buffer pools that have been defined for the selected node group.
|
Column |
Description |
|
Buffer Pool Name |
Total space in KB. If you create tablespaces, this information is not displayed. |
|
Buffer Pool Size (KB) |
Size of the buffer pool in KB. A value of –1 indicates that the default buffer pool size parameter from the database configuration is used (parameter BUFFPAGE). |
|
Page Size |
Size of one buffer pool page in bytes |
For detailed information on buffer pools, double-click the corresponding buffer pool.
Tablespaces
This tabstrip contains a list of all tablespaces that have been defined for the selected node group.
|
Field |
Description |
|
Tablespace Name |
Name of the tablespace |
|
Page Size |
Size of one tablespace page in bytes |
For detailed information on tablespaces, double-click the corresponding tablespace.
2. To apply changes, choose Partitions.
3. You can now add or delete partitions:
¡
To add partitions, choose
Add
Partition.
The system automatically suggests a new partition that has not yet been defined in the node group. You can modify this suggestion by manually selecting another partition.
¡
To delete partitions,
select one or more lines in the table and choose 
Delete
Partition.
4.
To confirm your entries,
choose 
Execute.
Adding Node Groups
...
1.
On the Configuration: Node Groups screen, choose
Add.
The Configuration: Node Group Maintenance – Add Node Group screen appears.
By default, all
available partitions are listed to be part of the new node group. Choose
Delete
Partition if you want to
reduce this list.
2. Specify a name for the new node group.
We recommend that you use uppercase letters for the node group name. Using lowercase letters or special characters makes accessing the selected node group with the DB2 command line processor less comfortable.
3.
To confirm your entries,
choose Add.
Deleting Node Groups
...
1. On the Configuration: Node Groups screen, select a node group.
2.
Choose Delete.
The Configuration: Node Group Maintenance – Delete Node Group screen appears.
3.
To delete the selected
node group, choose Delete.
You cannot delete node groups that contain tablespaces that are still being used by the SAP system.
You must delete the tablespaces first.
SQL Statements
In the lower half of the Configuration: Node Group Maintenance screen, an editor is displayed that shows the generated SQL statement(s) that will be executed. This area is automatically filled and refreshed if any changes were applied correctly.