Database partition groups

Chapter 12 DBMS-Specific Features

Database partition groups

Database partition groups are supported for DB2 v9.x and higher for Common Server.

A partition group is a logical layer that provides for the grouping of one or more database partitions. A partition can belong to more than one partition group. When a database is created, DB2 creates three default partition groups, which cannot be dropped.

Creating a database partition group

You can create a database partition group in any of the following ways:

Select Model→Database Partition Groups to access the List of Database Partition Groups, and click the Add a Row tool.
Right-click the model or package in the Browser, and select New→Database Partition Group.

Database partition group properties

You can modify an object's properties from its property sheet. To open a database partition group property sheet, double-click its diagram symbol or its Browser entry in the Database Partition Groups folder.

The following extended attributes are available on the DB2 tab:

Property	Description
Database partitions	Specifies the database partitions that are in the partition group. When empty, the group includes all database partitions defined in the database at the time of its creation. Scripting name: DBPartitionNumList