Increasing Queue Block Size in a Simple Replication System

Learn to set the queue block size of the primary and replicate Replication Servers in this example of a simple replication system.

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

pRSSD rRSSD

| |

pdb -----> PRS -----> 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.

Configure the primary Replication Server:
1. Suspend log transfer from all Replication Agents. At the primary Replication Server, execute:
```
suspend log transfer from all
```
2. Quiesce the primary Replication Server:
```
admin quiesce_force_rsi
```
3. Set the queue 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
```
4. 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.
5. 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.
6. Look at the primary Replication Server transaction log to verify that the block size is changed.
7. 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
```
8. Check the replicate Replication Server log file for information about data losses. Ignore data loss occurring from the primary Replication Server RSSD to the replicate Replication Server RSSD by executing the ignore loss command on the replicate Replication Server:
```
ignore loss from PRS.pRSSD to RRS.rRSSD
```
  See "Ignoring a loss," in Chapter 7, "Replication System Recovery" in the Replication Server Administration Guide Volume 2.
Configure the replicate Replication Server:
1. Suspend log transfer from all Replication Agents. At the primary Replication Server and at the replicate Replication Server, execute:
```
suspend log transfer from all
```
2. Quiesce the primary Replication Server:
```
admin quiesce_force_rsi
```
3. At all Replication Servers that originate routes to the replicate Replication Server, suspend the routes:
```
suspend route to RRS
```
4. Quiesce the replicate Replication Server:
```
admin quiesce_force_rsi
```
5. Set the block size at the replicate Replication Server to 64KB:
```
configure replication server
set block_size to ‘64’
```
  (Optional) Use the with shutdown option to shut down the replicate Replication Server. For example:
```
configure replication server
set block_size to ‘64’ with shutdown
```
6. Look at the transaction log to verify that the replicate Replication Server is not materializing, that log transfer and routes are suspended, and that the replicate Replication Server is quiesced.
7. Restart the replicate Replication Server if you have shut it down.
8. Look at the the replicate Replication Server transaction log to verify that the block size is changed.
9. Resume log transfer to allow Replication Agents to connect to the replicate Replication Server. At the replicate Replication Server, execute:
```
resume log transfer from all
```
10. 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
```
11. Resume the routes you suspended:
```
resume route to RRS
```
12. Check the the primary and replicate Replication Server log files for information about data losses. Ignore data loss occurring between the primary RSSD and the replicate RSSD if the replicate RSSD is replicated to the primary RSSD by executing the ignore loss command on the primary Replication Server.
```
ignore loss from RRS.rRSSD to PRS.pRSSD
```