Scheduling Servers
You can control when Ingres Replicator propagates changes to the target databases. If it is not critical to have the CDDS synchronized, you can turn on the servers at slow or no usage times. The main benefit of this strategy is that it conserves processing capacity at critical times; Ingres Replicator consumes resources.
You control replication timing through the servers. If the Replicator Server for a given CDDS is started and active, it is continually propagating changes to the target databases. If the Replicator Server is stopped or started but quiet, changes to the CDDS accumulate in the distribution queue until the Replicator Server is started or activated.
You can use the following methods to schedule Ingres Replicator by starting the replication cycle:
• At specific times using the -SGL flag
• At specific times using the -QIT flag and raising an event from an application
• At given intervals using the -QIT and -EVT flags
Note: To stop a server to perform maintenance on your system, see the online help topic Status Page [Performance Monitor window, Replication branch] for details. You can also stop servers in a terminal monitor or through your own customized shut down script by issuing the correct event to the server. For more information, see
Database Events.