Replication Agent recommended configuration

Sybase recommends the values for Replication Agent configuration parameters listed in Table 3-1.

There are no recommended values for the configuration parameters not listed in the following table.

Table 3-1: Recommended configuration parameters

Configuration Parameter

Recommended Value

column_compression

true

compress_ltl_syntax

true

dump_batch_timeout

5

log_wrap

500

lr_update_trunc_point

1000

lti_batch_mode

true

lti_max_buffer_size

5000

lti_update_trunc_point

1000

ltl_origin_time_required

false

maint_cmds_to_skip_before_update

1000

max_ops_per_scan

1000

pdb_convert_datetime

false

pds_retry_count

5

pds_retry_timeout

10

ra_retry_count

2

ra_retry_timeout

10

rs_retry_count

5

rs_retry_timeout

10

scan_sleep_increment

5

scan_sleep_max

60

skip_ltl_errors

false

structured_tokens

false

truncation_type

locator_update

use_rssd

true

NoteLog truncation is not available with log-based Replication Agents (for DB2 Universal Database). Therefore, the truncation_type parameter recommendation in Table 3-1 does not apply to log-based Replication Agents.