CLEANER_DAYS_TO_KEEP and CLEANER_STAGES_TO_KEEP

The CLEANER_DAYS_TO_KEEP and CLEANER_STAGES_TO_KEEP options control the behaviour of the job for cleaning stale replicator tables.

If both options are specified, the particular materialized table is deleted if it is older than the number of days to keep and the stage number is older then the number of last stages to keep.

Materialized tables in state INCOMPLETE will never be kept.

CLEANER_DAYS_TO_KEEP

Any stale materialized tables in Analytical Storage that were created less than the specified number of days ago will be kept by the clean stale replicator tables task. The default behaviour is to keep nothing redundant.

The default value is NULL. By providing -1 as value, the CData Virtuality Server can be reset to default behaviour.

To get the current value set for this option, you can use this statement:

SQL

SELECT * FROM (CALL "SYSADMIN.getDefaultOptionValue"('CLEANER_DAYS_TO_KEEP')) AS a;;

Examples

1. Setting the number of days to keep to 3:

SQL

CALL "SYSADMIN.setDefaultOptionValue"('CLEANER_DAYS_TO_KEEP', '3');;

2. Resetting the system behaviour to default (keep nothing redundant):

SQL

CALL "SYSADMIN.setDefaultOptionValue"('CLEANER_DAYS_TO_KEEP', '-1');;

CLEANER_STAGES_TO_KEEP

Any stale materialized tables in Analytical Storage that have a number lesser than the recent stage number will be kept by the clean stale replicator tables task. The default behaviour is to keep nothing redundant.

The default value is NULL. By providing -1 as value, the CData Virtuality Server can be reset to default behaviour.

To get the current value set for this option, you can use this statement:

SQL

SELECT * FROM (CALL "SYSADMIN.getDefaultOptionValue"('CLEANER_STAGES_TO_KEEP')) AS a;;

Examples

1. Setting the number of stages to keep to 3:

SQL

CALL "SYSADMIN.setDefaultOptionValue"('CLEANER_STAGES_TO_KEEP', '3');;

2. Resetting the system behaviour to default (keep nothing redundant):

SQL

CALL "SYSADMIN.setDefaultOptionValue"('CLEANER_STAGES_TO_KEEP', '-1');;