Frequency Options

You can specify the interval between replications or the time of day when replication occurs for a replicate.

Frequency Options

1!   --immed
1  --every=interval
1  --at=time
Element Purpose Restrictions
interval Time interval for replication The smallest interval in minutes, in one of the following formats:
  • The number of minutes, as an integer value 1 - 1966020, inclusive.
  • The number of hours and minutes separated by a colon. The minimum value is 0:01. The maximum value is 32767:59
time Specific time for replication Time is given as a 24-hour clock.
The following table describes the frequency options.
Long Form Short Form Meaning
--immed -i Default. Replication occurs immediately.
--every= -e Replication occurs immediately and repeats at the frequency that is specified by interval.
--at= -a Replication occurs at the specified day and time.

Usage

The frequency of replication is a property of a replicate. You can set the frequency of replication for a replicate when you define it or modify it. You can reset the frequency of all replicates in a replicate set when you define or modify a replicate set or define a template. For non-exclusive replicate sets, you can update the frequency of individual replicates separately.

If you do not specify a time, replication occurs immediately.

Important: When you use time-based replication by including the --every or the --at option, replicated transactions are split into multiple transactions and referential integrity is not supported. If you want to replicate data intermittently, you can specify the --immed and then disconnect the servers until you want to replicate the data.

Intervals

The --every=interval option specifies the interval between actions. The interval of time between replications can be either of the following formats:
  • The number of minutes

    To specify the number of minutes, specify an integer value greater than 0. For example, -e 60 indicates 60 minutes between replications.

    If you specify the interval of time between replications in minutes, the longest interval is 1966020.

  • The number of hours and minutes

    To specify hours and minutes, give the number of hours, followed by a colon, and then the number of minutes. For example, -e 5:45 indicates 5 hours and 45 minutes between replications.

If you specify the length of time in hours and minutes, the longest interval is 32767:59.

Time of Day

Enterprise Replication always gives the time of day in 24-hour time. For example, 19:30 is 7:30 P.M. Enterprise Replication always gives time as the local time, unless the TZ environment variable is set. However, Enterprise Replication stores times in the global catalog in Greenwich Mean Time (GMT).

The --at=time option specifies the day on which replication occurs. The string time can have the following formats:
  • Day of week

    To specify a specific day of the week, give either the long or short form of the day, followed by a period and then the time. For example, --at=Sunday.18:40 or -a Sun.18:40 specifies that replication occurs every Sunday at 6:40 P.M.

    The day of the week is given in the locale of the client. For example, with a French locale, you might have --at=Lundi.3:30 or -a Lun.3:30. The time and day are in the time zone of the server.

  • Day of month

    To specify a specific day in the month, give the date, followed by a period, and then the time. For example, 1.3:00 specifies that replication occurs at 3:00 A.M. on the first day of every month.

    The special character L represents the last day of the month. For example, L.17:00 is 5:00 P.M. on the last day of the month.

  • Daily

    To specify that replication occurs each day, give only the time. For example, 4:40 specifies that replication occurs every day at 4:40 A.M.