Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Posts
    1

    Unanswered: Does modifying a replicated schema requires quiescing?

    Hi,

    Does anyone knows if in peer-to-peer, update-anywhere replication configuration, when I need to modify the schema, say add a new table or add/modify a column of an existing table, do I have to put the replicated systems or environment into a quiescient state (whereby only select is allowed and insert/delete/update are not allowed)?

    Also, does anyone know how I can to put the replicated systems into the quiescient state? Do I do a suspend or stop?

    Thanks.

  2. #2
    Join Date
    Aug 2002
    Location
    Bonn/Germany
    Posts
    152
    If you add a new table, you don't have to stop ER (Enterprise Replication).

    The new table is not known to any existing replication
    definitions. You can also define a replicate on this
    new table afterwards without stopping ER.

    Modifying the schema of an existing table is not allowed
    as long as a replicate is defined on that table.
    You need to stop that replicate, modify your table and
    re-start the replicate. However you don't need to stop
    the whole ER.

    You will find more information in the "IDS Enterprise Replication
    Guide".

    Best regards

    Eric
    --
    IT-Consulting Herber
    WWW: http://www.herber-consulting.de
    Email: eric@herber-consulting.de

    ***********************************************
    Download the IFMX Database-Monitor for free at:
    http://www.herber-consulting.de/BusyBee
    ***********************************************

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •