Executor: HiRDB administrator and table owner (or user with DBA privilege)

This section explains how to change the partitioning definition of a table. The following partitioning definition changes are explained:

• Changing from key range partitioning to hash partitioning
• Changing the partitioning key column
• Changing from hash partitioning to key range partitioning
• Allocating a different RDAREA each month
  

  Reference note

  After the table partitioning method has been changed, execute the optimizing information collection utility (pdgetcst command) if necessary. For details about whether or not execution of the optimizing information collection utility is required, see the manual HiRDB Version 8 Command Reference.

Organization of this section

13.15.1 Example 1 (changing from key range partitioning to hash partitioning and changing the partitioning key column)

13.15.2 Example 2 (changing from hash partitioning to key range partitioning)

13.15.3 Example 3 (allocating a different RDAREA each month)