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.