AutoSYNC Software User's Guide (Update 16)

One-time Synchronization
HP AutoSYNC User’s Guide—522580-017
3-8
SQL Views
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 Partitioned Files and Tables 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.
PARTONLY synchronization of single partitions is not supported. An error message is
generated if a secondary partition is specifically selected to be synchronized.
When selecting a partitioned file for synchronization, AutoSYNC retrieves the
aggregate modification time to compare source and destination modification times. If
any partition of the source file is newer than the equivalent partition of the destination
file, the entire partitioned file is synchronized.