AutoSYNC Software User's Guide (Update 17)

One-time Synchronization
HP AutoSYNC User’s Guide—522580-018
3-8
SQL Views

If the index tables reside in a different subvolume than the base table in the source
file set, use the MAPNAMES option to specify the mapping of the source names to
the destination names.
The destination file set must be defined using a filename that has the wild-card
character asterisk (*); otherwise SQL tries to restore indexes and base table to the
same filename.
SQL index tables cannot be synchronized by themselves. AutoSYNC does not
synchronize an index that is created after the table has been synchronized, unless the
SQLREDEF option is specified (see Synchronizing based on REDEFINITION
timestamp below); otherwise, the table must be modified or purged at the destination to
cause the table and indexes to be resynchronized as a unit.
SQL Views
Protection Views
If you synchronize a SQL table, protection views are implicitly synchronized.
You cannot synchronize a protection view explicitly.
Shorthand Views
Shorthand views are synchronized automatically if they are in the file set list. You can
synchronize shorthand views explicitly, but they will be marked as corrupted if the
underlying tables are not present at the destination system. This can create a problem
if the view name alphabetically precedes the name(s) of the base tables.
A SQL view does not have a modification timestamp. Instead, AutoSYNC compares
source and destination creation timestamps to determine if the view should be
synchronized. This prevents the view from being synchronized every time the file set is
synchronized. However if TIMEEXACT is specified, the view will always be
synchronized because the creation time of the destination is always newer than the
creation time of the source.
SQL Collations
SQL collations are backed up as a combination of a collation file label and an
immediately-following temporary edit file. AutoSYNC treats this pair of items as a
single unit for recovery, OPENUPDATE and trigger processing.
Partitioned Files and Tables
AutoSYNC synchronizes entire partitioned files and tables when the primary partition is
specified in the source file set.
SYNC $DATA.SQLTBL.MYTBL TO \DEST.$DATA.SQLTBL.MYTBL*;!