AutoSYNC Software User's Guide (Update 18)

One-time Synchronization
HP AutoSYNC User’s Guide—522580-019
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.
The creation time of the destination is always different from than the creation time of
the source. Therefore, you should not specify TIMEEXACT on a file set that contains
shorthand views.
Synchronizing Shorthand Views with the Tables they Reference
A shorthand view, like a protection view, is synchronized whenever a table it references
is synchronized, if the shorthand view is in the syncfileset definition. This behavior is
controlled by the global parameter and by the syncfileset attribute and SYNCHRONIZE
command option SYNCVIEWS. By default, SYNCVIEWS is enabled.
If SYNCVIEWS is disabled, a shorthand view is not automatically synchronized with its
referenced tables. When the data in a SQL table changes or when the SQL DDL
changes and SQLREDEF is configured, Autosync synchronizes the table but does not
SYNC $DATA.SQLTBL.MYTBL TO \DEST.$DATA.SQLTBL.MYTBL*;!