Summary information |
|
---|---|
Default value |
1000 |
Range of values |
0 to 2147483647 |
Status |
Dynamic |
Display level |
N/A |
Required role |
ASE Replicator system user |
truncate_numops specifies the minimum number of replicated operations that must be in the Distribution Database stable queue before truncation occurs. A value of 0 specifies no truncation.
Larger truncate_numops values keep more data in the stable queue, taking up more space, even though the operations have been successfully replicated. If the truncate_numops value is too small, truncation occurs more often and it may cause lock contention with ASE Replicator components that read from and write to the stable queue.