Database Partition Groups (DB2)

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

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 a 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