How to change partitioning storage conditions (in the case of boundary value specification)

Nonstop Database, HiRDB Version 9 System Operation Guide

13.12.4 How to change partitioning storage conditions (in the case of boundary value specification)

To change the partitioning storage conditions, specify CHANGE RDAREA in the ALTER TABLE statement. Splitting and combining cannot be executed at the same time. To execute both splitting and combining, use two separate ALTER TABLE statements.

Organization of this subsection: (1) Partitioning storage conditions before combining; (2) Combining partitioning storage conditions; (3) Splitting a partitioning storage condition

(1) Partitioning storage conditions before combining

The following shows an example of partitioning storage conditions before combining or splitting:

 
CREATE FIX TABLE "T1"("C1" INT,"C2" CHAR(10)) PARTITIONED BY "C1"
 IN(("TA1")100,("TA2")200,("TA3")400,("TA4")500,("TA5")600,("TA6"))
CREATE INDEX "I1" ON "T1"("C1")
 IN(("IA1"),("IA2"),("IA3"),("IA4"),("IA5"),("IA6"))

[Figure]

(2) Combining partitioning storage conditions

The following example combines boundary values 100 and 200 into 200:

 
ALTER TABLE "T1" CHANGE RDAREA
 ((100),(200)) INTO "TA2"
 FOR INDEX "I1" INTO "IA2"

[Figure]

(3) Splitting a partitioning storage condition

The following example splits the storage range of 600 (& above) into 600 and 700 (& above):

 
ALTER TABLE "T1" CHANGE RDAREA
 ((MAX)) INTO (("TA6")700,("TA1"))
 FOR INDEX "I1" INTO (("IA6"),("IA1"))

[Figure]