SQL/MX 3.2.1 Management Manual (H06.26+, J06.15+)

By using the syntax last partition in the example, you avoid the need to specify the last
partition by its location.
Example of Moving an Existing Hash Partition to a New Location
You need to use $DATA03 for other purposes. Use the MODIFY command to move the index
partition there to another volume:
MODIFY INDEX cat2.sch2.ordersr_via_ordernumber
move
where location $data03
to location $data05;
Using MODIFY to Change the Location of a Sequence Generator
Use MODIFY to change the location information of a sequence generator. Using MODIFY moves
an existing partition to a new location.
Example of Using MODIFY with a Sequence Generator
For this example, assume the sequence generator was created this way:
>>showddl s2;
CREATE SEQUENCE SGCAT.SGSCH.S2 NUMERIC(4, 0)
START WITH 10
INCREMENT BY 1
MINVALUE 1
MAXVALUE 9999
CYCLE
LOCATION \DMR15.$SYSTEM.ZSDFMQWQ.RQR6LM00
;
Use the following MODIFY command to move the partition to a new location:
MODIFY SEQUENCE s2 MOVE TO LOCATION $data02;
After this command is executed, the result displays as:
>>showddl s2;
CREATE SEQUENCE SGCAT.SGSCH.S2 NUMERIC(4, 0)
START WITH 10
INCREMENT BY 1
MINVALUE 1
MAXVALUE 9999
CYCLE
LOCATION \DMR15.$DATA02.ZSDFMQWQ.CXNPDC00
;
Managing System-Clustered Tables and Indexes
A system-clustered table or index has no primary key and no STORE BY clause. Its primary key
defaults to the SYSKEY.
You can use MODIFY to move the existing partition of a system-clustered table or index to a new
location. A system-clustered table can have only a single partition. Only offline partition operations
are supported.
For system-clustered partitions, MODIFY supports moving an entire system-clustered partition to a
new location.
Using MODIFY in a System-Clustered Partition
For this system-clustered partition example, suppose that the table ORDERSSC has been created
in this way:
CREATE TABLE cat4.sch4.orderssc
(location char(16) not null not droppable,
Using MODIFY to Manage Table and Index Partitions 193