AutoSYNC Software User's Guide (Update 19)

One-time Synchronization
HP AutoSYNC User’s Guide—522580-020
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
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 than the creation time of the
source. Therefore, you should not specify TIMEEXACT on a file set that contains
shorthand views.
By default, a shorthand view, like a protection view, is synchronized whenever a table it
references is synchronized, regardless of whether the shorthand view is in the
syncfileset definition or not.
You can disable the automatic synchronization of shorthand views for a specific
syncfileset by setting the syncfileset attribute NO SYNCVIEWS.
If automatic shorthand view synchronization 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 list any associated shorthand view in the BACKUP
input list, because the view did not change. On the destination, the view is dropped
when RESTORE drops and replaces the referenced table, but the view is not
recreated. The view is eventually replaced at the next synchronization.
SYNC $DATA.SQLTBL.MYTBL TO \DEST.$DATA.SQLTBL.MYTBL*;!