NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
M-21
Examples—MODIFY LABEL
On node \B, to modify the volume moved from \A to \B:
>> MODIFY LABEL $DB1.*.*
+> REPLACE NODENUMBER 101 ($DB1) WITH 102;
>> MODIFY CATALOG $DB1.CATSUBV
+> REPLACE NODENAME \A ($DB1) WITH \B;
>> MODIFY REGISTER CATALOG $DB1.CATSUBV;
On node \A, to modify the references to the partition moved from \A to \B:
>> MODIFY LABEL $DA1.*.*
+> REPLACE NODENUMBER 101 ($DB1) WITH 102;
>> MODIFY CATALOG $DA1.CATSUBV
+> REPLACE NODENAME \A ($DB1) WITH \B;
On node \C, to modify the references to the partition moved from \A to \B:
>> MODIFY LABEL $DC1.*.*
+> REPLACE NODENUMBER 101 ($DB1) WITH 102;
>> MODIFY CATALOG $DC1.CATSUBV
+> REPLACE NODENAME \A ($DB1) WITH \B;
Notice that the REPLACE clauses are specified as:
REPLACE NODENUMBER 101 ($DB1)
REPLACE NODENAME \A ($DB1).
The ($DB1) part is necessary to change all references from \A.$DB1.SQL.T1 to
\B.$DB1.SQL.T1 while leaving intact all references to the \A.$DA1.SQL.T1 partition
that remains on \A.
After the MODIFY commands are executed, the information in the PARTNS catalog
tables looks like this:
>> SELECT FILENAME,PARTITIONNAME,CATALOGNAME
+> FROM \A.$DA1.CATSUBV.PARTNS;
FILENAME PARTITIONNAME CATALOGNAME
-------------- -------------- ---------------
\A.$DA1.SQL.T1 \A.$DA1.SQL.T1 \A.$DA1.CATSUBV
\A.$DA1.SQL.T1 \B.$DB1.SQL.T1 \B.$DB1.CATSUBV
\A.$DA1.SQL.T1 \C.$DC1.SQL.T1 \C.$DC1.CATSUBV
>> SELECT FILENAME,PARTITIONNAME,CATALOGNAME
+> FROM \B.$DB1.CATSUBV.PARTNS;
FILENAME PARTITIONNAME CATALOGNAME
-------------- -------------- ---------------
\B.$DB1.SQL.T1 \A.$DA1.SQL.T1 \A.$DA1.CATSUBV
\B.$DB1.SQL.T1 \B.$DB1.SQL.T1 \B.$DB1.CATSUBV
\B.$DB1.SQL.T1 \C.$DC1.SQL.T1 \C.$DC1.CATSUBV
>> SELECT FILENAME,PARTITIONNAME,CATALOGNAME
+> FROM \C.$DC1.CATSUBV.PARTNS;
FILENAME PARTITIONNAME CATALOGNAME
-------------- -------------- ---------------
\C.$DC1.SQL.T1 \A.$DA1.SQL.T1 \A.$DA1.CATSUBV