Creating Models › Target Servers for Physical Models › Database Property Editors › DB2 LUW Property Editors › Define DB2 LUW Database Partition Groups

Define DB2 LUW Database Partition Groups

text Use the options in the DB2 for LUW Database Partition Group Editor to set properties for a database partition group. You create a database partition group when you define a subset of one or more database partitions in a database.

To define a DB2 LUW database partition group

1. Right-click a Database Partition Group in the Model Explorer and select Properties.

   The DB2 for LUW Database Partition Groups Editor opens.

2. Select a database partition group name and work with the following options:

   Note: Click New on the toolbar to create a database partition group. Use the Enter filter text text box to filter a large list of names to locate the one you want to work with.

   Name

   Specifies the name of the database partition group.

   Generate

   Specifies whether or not to generate DDL for this object during Forward Engineering.

3. Click the Database Partitions tab to work with the following properties:

   Name

   Specifies a database partition. Select the check box next to the name to include it in the database partition group. You can open the database partition editor to include available database partitions.

   Partition Number

   Specifies the partition number.

4. Click the Where Used tab to review where the selected database partition group is used.
5. Click the Comment tab and enter any comments you want to associate with the database partition group.
6. Click the UDP tab to work with user-defined properties for the database partition group.
7. Click Close.

   The new database partition group is saved and the DB2 for LUW Database Partition Group Editor closes.

More Information:

Define a DB2 LUW Database Partition

Define a DB2 LUW Bufferpool

Add a Comment in a Property Editor

Add a UDP in a Physical Property Editor