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

always gives the time of day in 24-hour time. For example, 19:30 is 7:30 P.M. always gives time as the local time, unless the TZ environment variable is set. However, 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. 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.