SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
M-39
MODIFY LABEL with REPLACE VOLUME and
Partitioned Objects
FILENAME PARTITIONNAME CATALOGNAME
-------------- -------------- ---------------
\C.$DC1.SQL.T1 \A.$DA1.SQL.T1 \A.$DA1.CATSUBV
\C.$DC1.SQL.T1 \A.$DB1.SQL.T1 \A.$DB1.CATSUBV
\C.$DC1.SQL.T1 \C.$DC1.SQL.T1 \C.$DC1.CATSUBV
Now suppose that the $DB1 volume on \A node is renamed to $XYZ. The MODIFY
DICTIONARY commands needed to make the NonStop SQL/MP database consistent
after the move are shown:
On node \A, to modify the references to the partition moved from \$DB1 to $XYZ:
>> MODIFY LABEL \A.$DA1.*.*
+> REPLACE VOLUME $DB1 WITH $XYZ;
>> MODIFY LABEL \A.$XYZ.*.*
+> REPLACE VOLUME $DB1 WITH $XYZ;
>> MODIFY CATALOG \A.$DA1.CATSUBV
+> REPLACE VOLUME $DB1 WITH $XYZ;
On node \C, to modify the references to the partition moved from $DB1 to $XYZ:
>> MODIFY LABEL \C.$DC1.*.*
+> REPLACE VOLUME $DB1 WITH $XYZ;
>> MODIFY CATALOG $DC1.CATSUBV
+> REPLACE VOLUME $DB1 WITH $XYZ;