Administration Guide

Definition of Initial Nodegroups

When a database is initially created, database partitions are created for all partitions specified in the db2nodes.cfg file. Other partitions can be added or removed with the ADD NODE and DROP NODE commands.

Three nodegroups are defined:

• IBMCATGROUP for the SYSCATSPACE table space, holding system catalog tables
• IBMTEMPGROUP for the TEMPSPACE1 table space, holding temporary tables created during database processing
• IBMDEFAULTGROUP for the USERSPACE1 table space, by default holding user tables and indexes.