Online Documentation for SQL Manager for DB2

Partition Groups


A Partition group is a set of database partitions that can be created within the database.

 

 

Creating Partition Groups

 

To create a new partition group:

Hint: To create a new partition group, you can also right-click the Partition Groups node of the DB Explorer tree and select the New Partition Group... context menu item.

 

To create a new partition group with the same properties as one of existing partition groups has:

Alternatively, you can right-click a partition group in the DB Explorer tree and select the Duplicate Partition Group <partition_group_name>... context menu item.

 

Duplicate Object Wizard allows you to select the database to create a new partition group in, and to edit the result SQL statement for creating the partition group.

 

 

Editing Partition Groups

 

To edit an existing partition group:

  • select the partition group for editing in the DB Explorer tree (type the first letters of the partition group name for quick search);
  • right-click the object and select the Edit Partition Group <partition_group_name>... context menu item, or simply double-click the partition group;
  • edit partition group definition using the appropriate tabs of Partition Group Editor.

 

Dropping Partition Groups

 

To drop a partition group:

  • select the partition group to drop in the DB Explorer tree;
  • right-click the object and select the Drop Partition Group <partition_group_name>... context menu item;
  • confirm dropping in the dialog window.

 

Note: If more convenient, you can also use the following shortcuts:

Ctrl+N to create a new partition group;

Ctrl+O to edit the selected partition group;

Shift+Del to drop the object from the database.