Editing existing partitions

Posted by Valeriy Bashkatov on 17-Jul-2014 08:15

It is possible to edit existing partitions?

For example, when the partition was created by mistake and now need to delete wrong partition.

Or if the wrong name was chosen for the partition - is it possible to change the name of a partition?

Or when an incorrect value was chosen for partition aligned field, can it be changed?,

How to split an existing partition into several partitions (for range partition)?

OpenEdge RDBMS - Forum
Posted by Richard Banville on 17-Jul-2014 08:45

  1. You can delete partitions, yes.
  2. Yes, rename will be supported but I'm not 100% sure if it is in 11.4 or will be in 11.5.
  3. The only way to change an incorrect value is to delete the partition and re-add it.  The issue here is that data for that incorrect value may have already been put into the partition and therefore the partition value cannot simply change without making the partition inconstant.
  4. Splitting a partition is supported with the split option or proutil partitionmanage
    1. You should refer to the documentation for the complete syntax.
    2. The process is that you create a new partition for the new "sub-range" and identify it as a split target type partition
    3. Then run the split option of proutil partition manage and split the data out of the existing partition into the new partition.
    4. Note that the data associated with the new partition is "locked" from local index access until the split operation completes (even if you cancel the split operation or restart the database - the split target data will remain locked until the split command completes.
    5. The transaction scope of the split is based on the number of records specified on the command line.  This allows the split operation to perform in smaller chunks without having the side effect of "blowing out" your .bi file.
    6. Full access to the non-split data in the original partition is available regardless of the status of the split

All Replies

Posted by Richard Banville on 17-Jul-2014 08:45

  1. You can delete partitions, yes.
  2. Yes, rename will be supported but I'm not 100% sure if it is in 11.4 or will be in 11.5.
  3. The only way to change an incorrect value is to delete the partition and re-add it.  The issue here is that data for that incorrect value may have already been put into the partition and therefore the partition value cannot simply change without making the partition inconstant.
  4. Splitting a partition is supported with the split option or proutil partitionmanage
    1. You should refer to the documentation for the complete syntax.
    2. The process is that you create a new partition for the new "sub-range" and identify it as a split target type partition
    3. Then run the split option of proutil partition manage and split the data out of the existing partition into the new partition.
    4. Note that the data associated with the new partition is "locked" from local index access until the split operation completes (even if you cancel the split operation or restart the database - the split target data will remain locked until the split command completes.
    5. The transaction scope of the split is based on the number of records specified on the command line.  This allows the split operation to perform in smaller chunks without having the side effect of "blowing out" your .bi file.
    6. Full access to the non-split data in the original partition is available regardless of the status of the split

Posted by Aidan Jeffery on 18-Jul-2014 15:20

(Question #2) Yes, renaming of partitions is supported in 11.4.

Posted by Brian Bowman on 21-Jul-2014 09:16

Actually, renaming a partition is part of the 11.5 planned release.

Posted by Jeff Ledbetter on 21-Jul-2014 12:54

When you guys are saying "partition name" and renaming it, are you referring to the partition policy name?

Posted by Jeff Ledbetter on 22-Jul-2014 22:47

Anyone?

Posted by Aidan Jeffery on 23-Jul-2014 08:18

We were referring to the "partition name" field, in the partition policy detail record.

Changing the "partition policy name" field is also likely to be supported, but I don't know when.

Posted by gus on 23-Jul-2014 08:34

what's the difference between a "partition name" and a "partition policy
name" ?

when would i use a "partition policy name" and for what?

This thread is closed