SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
D-70
DUP Command
error. If source-file-list implicitly specifies secondary partitions, DUP ignores
the secondary partitions.
If SMF is installed on your node, source-fileset-list must not specify an
object or file on a $*.ZYS*. subvolume.
Duplication of views and indexes depends on the INDEXES and VIEWS options
described later in this entry.
target-fileset
is a fileset that specifies names and locations for the new objects and files.
An asterisk (*) in the fileset specification indicates that the portion of the name in
which the asterisk appears should be the same as the corresponding portion of the
name of the object or file being duplicated. (The meaning of the asterisk differs
from the usual meaning of an asterisk in a fileset specification. The ? (question
mark) normally allowed in a fileset specification is not allowed.)
DUP $VOL1.SALES.*, $VOL2.*.*
duplicates each table and its dependent objects on $VOL1.SALES, creating the
duplicates on $VOL2.SALES with the same names as the original tables and
dependent objects.
For information, see the target-fileset specification Considerations item on
page D-76.
MAP NAME[S] { map-spec }
{ (map-spec [, map-spec] ... ) }
is a clause that specifies names and locations for the new objects or files.
map-spec is:
simple-fileset-list TO fileset
simple-fileset-list
is a simple fileset list that specifies the objects or files being duplicated for
which names and locations are being specified.
A fileset in the list that does not specify a node matches any node. Specifying
the local node for a fileset is equivalent to not specifying any node for the
fileset. For example, if \LOCAL is the local node name, both the node
specifications *.*.* and \LOCAL.*.*.* match all files on all nodes, both local and
remote.
fileset
is a fileset that specifies names and locations for the new objects and files.