Catalog mapping – HP Integrity NonStop J-Series User Manual

Page 49

Advertising
background image

One-time Synchronization

HP AutoSYNC User’s Guide522580-018

3-11

Partitioned Files and Tables

are equivalent to:

By default, name mapping is performed by RESTORE with the assistance of the
default MAP NAMES clause provided by AutoSYNC. The default clause is:

which says that everything in the source file set will be mapped to the same destination
file set. Therefore, if you synchronize files and tables to the same location on the
destination, you do not need to supply a mapnames-file.

The mapnames-file is used by AutoSYNC for RENAMEOPEN and recovery processing
and by RESTORE to map file names such as partitions that are not in the same
location on the destination or SQL indexes and protection view names that are not in
the same location as the base table, as described in the paragraphs above in this
chapter.

The mapnames-file is not used by AutoSYNC to select the files to synchronize, which
means that Autosync does not use the mapnames entries to map the basic source and
destination file sets. For example, to synchronize volumes $data1.*.* TO
\dest.$back1.*.* and $data2.*.*.* to \dest.$back2.*.*, the following is INCORRECT:

The correct way is to synchronize each source volume as follows:

Catalog mapping

The information supplied by MAPNAMES is also used to perform SQL catalog volume
mapping. You should include mapnames-file entries if catalogs are located on different
volumes or subvolumes on the destination system.

Note that SQL catalogs are never synchronized by AutoSYNC, but synchronized SQL
objects have references to SQL catalogs that might require name mapping.

AutoSYNC default catalog mapping is designed to select a valid volume where a
catalog can be created with AUTOCREATECATALOG and CATALOG options. If you
have a more specific requirement, specify explicit catalogs for the SQL objects being
synchronized by adding catalog mapping entries in mapnames-file. The catalog

\SOURCE.$DATA.*.* TO \DEST.$BACK.*.*

\NEWYORK.$DATA*.DB.* TO \DEST.$BACK.BACKUPDB.*

\SOURCE.$DATA*.DB.PARTFILE TO \TOKYO.*.*.*

MAP NAMES ( source-file-set TO dest-file-set,

source-system.*.*.* TO dest-file-set )

SYNC $data*.*.* TO \dest.*.*.*,MAPNAMES mapdata...;

where mapdata contains entries:

$DATA1 TO $BACK1

$DATA2 TO $BACK2

SYNC $data1.*.* TO \dest.$back1.*.*...;

SYNC $data2.*.* TO \dest.$back2.*.*...;

Advertising
This manual is related to the following products: