emprepsync

EMPREPSYNC(1)                                       EMPREPSYNC(1)


NAME
       emprepsync - performs replication synchronization

SYNOPSIS
       emprepsync  [-fv] replicate_database replicate_table [
       replicate_table]...



DESCRIPTION
       emprepsync  is  the  Replication  Synchronization  Utility
       which  synchronizes  the  data  of  one  or more replicate
       tables indicated by replicate_table in replicate_database,
       with  the  data  of their corresponding Replication Master
       Tables. More than one  replicate_table  belonging  to  the
       same replicate_database can be synchronized using one call
       of emprepsync Replication Synchronization Utility.

       For each replicate table replicate_table, there is defined
       an  ordered Replication Master List of one or more associ-
       ated Replication Master Tables. emprepsync  "chooses"  a
       Replication  Master  Table  that  is "enabled" and has the
       smallest Replication Master Order in a Replication  Master
       List  and  attempts  to  connect to the Replication Master
       Server assigned to the "chosen" Replication Master  Table.
       If a connection with the Replication Master Server serving
       a "chosen" Replication Master  Table  can  not  be  estab-
       lished,  emprepsync will try to choose another Replication
       Master Table which has a larger Replication  Master  Order
       until either a successful connection is established, or no
       other Replication Master Table is remained in the list  to
       be  tried.  If  no  connection with any of the Replication
       Master  Tables  in  Replication  Master  List  of   repli-
       cate_table  can  be  established, emprepsync exits with an
       error message.

       After the first successful  connection  to  a  Replication
       Master  Server,  emprepsync will try to synchronize repli-
       cate_table with the chosen Replication  Master  Table.  If
       this  synchronization  fails,  the  partial effects of the
       synchronization will be rolled back, and the other  Repli-
       cation Master Tables will not be tried.

       If  used  without -f (force) option, emprepsync refuses to
       synchronize a replicate_table more  recent  data,  with  a
       Replication Master Table having less recent data.


       -v    This option causes emprepsync to show verbose on
             synchronization progress  status,  so that the user  would
             know whether the synchronization is in progress or not.

       -f    This option forces emprepsync to synchronize repli-
              cate_table   with   the  Replication  Master  Table
              accessed by the successfully connected  Replication
              Master Server assigned by chosen Replication Master
              Entry, even if the contents of replicate_table  are
              more  recent  than  that  of its Replication Master
              Table.  Note  that  [-f]  option  works  only  when
              Current  Master  Table  Start  Timestamp  (CMTS) of
              replicate_table is equal to CMTS of its Replication
              Master  Table participating in the Replication Syn-
              chronization.  

	   
FILES
       EMPRESS database files.

SEE ALSO
       empsvadm(1)

       Empress: Replication Server


HISTORY
       Written by Empress Software Inc.  All  material  is  copy-
       righted and licensed.  Use on non-licensed CPUs is prohib-
       ited.