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.
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 |
Log 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.