To apply schema updates to the source replication enabled database:1. If the Replication Server is waiting to connect to the Agent or the Replication Server is running but the Target database or Replication Agent are not online:
- Wait until the connect-timeout server property expires
- If defer-agent-startup mode is in effect, then run "DSRUTIL -C canceldefer" once the connect-timeout has expired.
Online Schema changes can be applied to the source database once the Replication Server terminates (read: the replication server will no longer lock the schema).
Ensure sufficient AI extents to record the associated schema update transaction notes.
2. If the Target database and Replication Agent is online and synchronisation is being performed:
Wait until the databases have synchronised before applying schema updates online. The schema update will then be propogated to the target database.
3. Otherwise, schema updates can be applied
offline against the source database, ensuring sufficient AI extents to record the associated transaction notes.