SAP ASE RepAgent Parameter max writetext groups
Use the max writetext groups parameter of sp_config_rep_agent to specify the maximum number of off-row LOB data chunks that RepAgent sends in a single writetext LTL command.
Use this parameter for non-compressible off-row LOB
data:
.
sp_config_rep_agent [<dbname>[,'max writetext groups',{'<max writetext groups value>'} ]
The default value depends on the SAP ASE page size:
| SAP ASE Page Size (kilobytes) | Maximum textinsert Size (bytes) | <max writetext groups> default (kilobytes) | Maximum rs_writetext Size (bytes) | Replication Server Block Size (kilobytes) |
|---|---|---|---|---|
| 2 | 450 | 9 | 4500 | 16 |
| 4 | 900 | 5 | 4500 | 16 |
| 8 | 1800 | 3 | 5400 | 16 |
| 16 | 3600 | 1 | 3600 | 16 |
Whenever a system replicates large amount of off-row LOB data, increasing the value of max writetext groups may help the performance with replication. When you increase the max writetext groups value in SAP ASE, SAP recommends that you also increase the SAP Replication Server block size.