beautypg.com

HP Integrity NonStop J-Series User Manual

Page 141

background image

Command Interpreter

HP AutoSYNC User’s Guide522580-017

8-47

ALTER SYNCFILESET

AUDITED | NO AUDITED

instructs AutoSYNC to synchronize (or skip) the audited files in the file set.

The default is NO AUDITED.

AUTOCREATECATALOG | NO AUTOCREATECATALOG

instructs AutoSYNC to create (or not to create) a SQL catalog when a SQL
object that requires a catalog is moved to a destination where the catalog does
not exist.

The catalog is created in the same location as the catalog on the source
system. If the source catalog volume does not exist on the destination system,
the catalog is placed on the volume of the destination tables.

The security of the newly created destination catalog is set to the syncuser's
default Guardian security.

If the catalog already exists, the option is ignored.

To register the object in a different catalog, use the CATALOG option in
addition to AUTOCREATECATALOG.

BACKUP backup-program | NO BACKUP

the name of the BACKUP object program to use on the source system when a
file set is synchronized.

This option overrides the BACKUP option specified in the

ADD SYNCUSER

or

ALTER SYNCUSER

command.

If BACKUP is omitted, $SYSTEM.SYSnn.BACKUP is used.

CATALOG SQL-catalog | NO CATALOG

where to register SQL objects that are synchronized. If CATALOG is omitted,
the source catalog name is used.

If the needed catalog does not exist and AUTOCREATECATALOG is not
specified, SQL table synchronization fails.

COMPRESS | NO COMPRESS

enables or disables compression of the file set prior to being sent to the
destination system.

This option overrides the global parameter [AUTO]SYNCCOMPRESS.

KEEPNOPURGEUNTIL | NO KEEPNOPURGEUNTIL

specifies that the NOPURGEUNTIL attribute of a source SQL table or
alternate index is preserved (or not preserved) on the destination. If

Note. Compression is CPU-intensive and can reduce total throughput unless the
connection between source and destination systems is slow.

This manual is related to the following products: