Configuring a single-master schedule (confschedule) v7

Suggest edits

For SMR only: The confschedule command creates a schedule for when to start recurring replications for a single-master replication system.

Synopsis

-confschedule subname –repsvrfile subsvrfile
{ -remove | -jobtype { s | t }
  { -realtime no_of_sec |
    -daily hour minute |
    -weekly day_of_week hour minute |
    -monthly month day_of_month hour minute |
    -cronexpr "cron_expression"
  }
}

Specifying the remove parameter deletes the schedule from the subscription. In this case, you can specify only the subname and repsvrfile parameters.

If you omit the remove parameter, then you must specify the jobtype parameter and one of the parameters realtime, daily, weekly, monthly, or cronexpr. You must also specify the subname and repsvrfile parameters. The new schedule replaces any existing schedule for subscription subname. See Performing synchronization replication for more information on creating a schedule.

Parameters

subname

The name of the subscription whose replication schedule you want to create.

subsvrfile

The file containing the subscription server login information.

-remove

Specifying the remove parameter removes any existing schedule from the subscription. If you don't specify the remove parameter, then a schedule is created for the subscription.

-jobtype

Specify s to perform the scheduled replication by snapshot. Specify t to perform the scheduled replication by synchronization. If the associated publication is a snapshot-only publication, then you must specify -jobtype s.

no_of_sec

The number of seconds between scheduled replications. Specify an integer greater than 0.

hour

The hour of the day based on a 24-hour clock. Specify an integer from 0 to 23.

minute

The minute of the hour. Specify an integer from 0 to 59.

day_of_week

The day of the week. Specify any of the following values: SUN, MON, TUE, WED, THU, FRI, or SAT. This value is not case sensitive.

month

The month of the year. Specify any of the following values: JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, or DEC. This value is not case sensitive.

day_of_month

The day of the month. Specify an integer 1 or greater up to and including the number of days in month.

cron_expression

A cron expression. See Writing a cron expression for details.

Examples

This example creates a schedule to perform synchronization replication on subscription dept_emp_sub once every five minutes.

$ java -jar edb-repcli.jar -confschedule dept_emp_sub \
>   -repsvrfile ~/subsvrfile.prop \
>   -jobtype t \
>   -realtime 300
Configuring scheduler ...
Job is successfully scheduled.

This example removes the schedule from subscription dept_emp_sub.

$ java -jar edb-repcli.jar -confschedule dept_emp_sub \
>   -repsvrfile ~/subsvrfile.prop \
>   -remove
Configuring scheduler ...
Scheduled job is removed.
← Prev

Performing a synchronization (dosynchronize)

Next →

Configuring a multi-master schedule (confschedulemmr)