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

Nonstop Database, HiRDB Version 9 System Operation Guide

13.12.7 How to change partitioning storage conditions (in the case of storage condition 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" CHAR(10),"C2"...
 IN(("TA1")"C1"='Berkeley branch',("TA2")"C1"='Oakland branch',("TA3")"C1"='Sausalito branch',
    ("TA4")"C1"=('San Francisco branch','San Jose branch'),("TA5"))
CREATE INDEX "I1" ON "T1"("C1")
 IN(("IA1"),("IA2"),("IA3"),("IA4"),("IA5"))

[Figure]

(2) Combining partitioning storage conditions

The following example combines data from the Berkeley and Oakland branches into the same RDAREA:

ALTER TABLE "T1" CHANGE RDAREA PARTITIONED CONDITION (("TA1"),("TA2")) INTO ("TA1")
 FOR INDEX "I1" INTO "IA1"

[Figure]

(3) Splitting a partitioning storage condition

The following example splits the data for the San Francisco and San Jose branches into separate RDAREAs:

ALTER TABLE "T1" CHANGE RDAREA PARTITIONED CONDITION
 (("TA4")) INTO (("TA4")"C1"=('San Francisco branch'),("TA6")"C1"=('San Jose branch'))
 FOR INDEX "I1" INTO (("IA4"),("IA6"))

[Figure]