Increasing Queue Block Size in a Replication System with an Intermediate Route

Learn to set the queue block size of the primary Replication Server in this example of a replication system with an intermediate route.

The replication system consists of:

primary database – pdb
replicate database – rdb
primary Replication Server – PRS
RSSD of primary Replication Server – pRSSD
replicate Replication Server – RRS
RSSD of replicate Replication Server – rRSSD
intermediate Replication Server – IRS
RSSD of intermediate Replication Server – iRSSD

pRSSD iRSSD rRSSD

| | |

pdb -----> PRS -----> IRS -----> RRS -----> rdb

In this example, RSSD refers to both Adaptive Server as the Replication Server System Database (RSSD) and SQL Anywhere as the Embedded Replication Server System Database (ERSSD). See the Replication Server Reference Manual for the full syntax, examples, and usage information for all commands.

Suspend log transfer from all Replication Agents. At the primary Replication Server, execute:
```
suspend log transfer from all
```
Quiesce PRS:
```
admin quiesce_force_rsi
```
Set the block size at the primary Replication Server to 64KB:
```
configure replication server
set block_size to ‘64’
```
(Optional) Use the with shutdown option to set the block size and shut down the primary Replication Server. For example:
```
configure replication server
set block_size to ‘64’ with shutdown
```
Look at the transaction log to verify that the primary Replication Server is not materializing, that log transfer and routes are suspended, and that the primary Replication Server is quiesced.
Restart the primary Replication Server if you have shut it down. See “Starting Replication Server,” in Chapter 4, “Managing a Replication System” in the Replication Server Administration Guide Volume 1.
Look at the primary Replication Server transaction log to verify that the block size is changed.
Resume log transfer to allow Replication Agents to connect to the primary Replication Server. At the primary Replication Server execute:
```
resume log transfer from all
```
Check the intermediate and replicate Replication Server log files for information about data losses. Ignore data loss occurring from the primary Replication Server RSSD to the replicate Replication Server and from the primary RSSD to the intermediate RSSD by executing the ignore loss command twice on the intermediate Replication Serve:
```
ignore loss from PRS.pRSSD to RRS
go
ignore loss from PRS.pRSSD to IRS.iRSSD
```
See "Ignoring a loss," in Chapter 7, "Replication System Recovery" in the Replication Server Administration Guide Volume 2.