SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
M-30
MODIFY LABEL with REPLACE VOLUME
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 run, 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
\C.$DC1.SQL.T1 \B.$DB1.SQL.T1 \B.$DB1.CATSUBV
\C.$DC1.SQL.T1 \C.$DC1.SQL.T1 \C.$DC1.CATSUBV
MODIFY LABEL with REPLACE VOLUME
The MODIFY LABEL with REPLACE VOLUME command modifies volume names
stored in file labels of SQL objects and SQL object programs on the local node. The file
label of an SQL object or object program contains names in internal network form and
therefore always contains one or more volume names. This command is used when
physically moving a disk from one node in your network to another node which has a
similar disk volume name, or when system loading a disk with a new disk volume
name. When this happens, changes are not automatically reflected in the catalogs and
file labels. The internal consistency of the database is lost; catalogs (and objects they
describe) cannot be accessed. The MODIFY commands (LABEL, CATALOG) enable
you to change the database to reflect the new information.
SQL objects include SQL catalog tables, user-defined tables, table partitions, indexes,
index partitions, views, and collations.
Note. The MODIFY LABEL with REPLACE VOLUME command is supported on systems
running J06.04 and later J-series RVUs and H06.15 and later H-series RVUs only.