Scheduling shadow table history cleanup (confcleanupjob) v7

The confcleanupjob command creates a schedule for when to delete shadow table history.

Synopsis

-confcleanupjob pubdbid -repsvrfile pubsvrfile
{ -disable | -enable
  { -minutely no_of_minutes |
    -hourly no_of_hours |
    -daily hour |
    -weekly day_of_week hour |
    -cronexpr "cron_expression"
  }
}

Specifying the disable parameter deletes the schedule. In this case, specify only the pubdbid and pubsvrfile parameters. If you omit the disable parameter, then you must specify the enable parameter and one of parameters minutely, hourly, daily, weekly, or cronexpr along with the pubdbid and pubsvrfile parameters.

See Scheduling shadow table history cleanup for more information.

Parameters

pubdbid

Publication database ID of the publication database definition whose schedule for deleting shadow table history you want to enable or disable.

pubsvrfile

The file containing the publication server login information.

-disable

Specifying the disable paramter removes any existing shadow table history cleanup schedule from the publication database definition. If you don't spcify the disable parameter, then you must specify the enable parameter.

-enable

Establish a schedule for shadow table history cleanup.

no_of_minutes

The number of minutes between scheduled shadow table history cleanup jobs. Specify an integer from 1 through 59.

no_of_hours

The number of hours between scheduled shadow table history cleanup jobs. Specify an integer from 1 through 12.

hour

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

day_of_week

The day of the week. Specify any of the following values: SUNDAY, MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, or SATURDAY. This value is not case sensitive.

cron_expression

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

Examples

This example schedules shadow table history cleanup to run once every three hours on the shadow tables created in the publication database definition with ID 1.

$ java -jar edb-repcli.jar -confcleanupjob 1 \
>   -repsvrfile ~/pubsvrfile.prop \
>   -enable -hourly 3
Configuring cleanup job ...
Cleanup job configured.

This example schedules a shadow table history cleanup to run once a day at 6:00 p.m. on the shadow tables created in the publication database definition identified by ID 1.

$ java -jar edb-repcli.jar -confcleanupjob 1 \
>   -repsvrfile ~/pubsvrfile.prop \
>   -enable -daily 18
Configuring cleanup job ...
Cleanup job configured.

This example schedules the shadow table history cleanup to run every Wednesday at 8:00 a.m. on the shadow tables created in the publication database definition identified by ID 1.

$ java -jar edb-repcli.jar -confcleanupjob 1 \
>   -repsvrfile ~/pubsvrfile.prop \
>   -enable -weekly WEDNESDAY 8
Configuring cleanup job ...
Cleanup job configured.

This example disables the shadow table history cleanup job on the publication database definition identified by ID 1.

$ java -jar edb-repcli.jar -confcleanupjob 1 \
>   -repsvrfile ~/pubsvrfile.prop -disable
Configuring cleanup job ...
Cleanup job removed.