If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > Does modifying a replicated schema requires quiescing?

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 06-11-03, 21:20
wmkalvin wmkalvin is offline
Registered User
 
Join Date: Jun 2003
Posts: 1
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.
Reply With Quote
  #2 (permalink)  
Old 06-12-03, 15:25
eherber eherber is offline
Registered User
 
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
***********************************************
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On