1.0

Create a second gateway receiver on in the server group productionreceivers:
create productionreceiver (startport 1540 endport 1551) server
groups (productionreceivers);
0 rows inserted/updated/deleted
Query the GATEWAYRECEIVERS table to determine the port number that SQLFire
selected:
sqlf> select id, running_port, server_groups from
sys.gatewayreceivers;
ID |RUNNING_PORT |SERVER_GROUPS
|SERVER_GROUP
------------------------------------------------------------
TESTRECEIVER |1538 |TESTRECEIVERS
PRODUCTIONRECEIVER |1544 |PRODUCTIONRECEIVERS
2 rows selected
CREATE GATEWAYSENDER
Creates a gateway sender to replicate data to a remote SQLFire cluster.
Syntax
CREATE GATEWAYSENDER sender-name
(
REMOTEDSID integer-constant
[ SOCKETREADTIMEOUT integer-constant ]
[ MANUALSTART boolean-constant ]
[ ENABLEBATCHCONFLATION boolean-constant ]
[ BATCHSIZE integer-constant ]
[ BATCHTIMEINTERVAL integer-constant ]
[ ENABLEPERSISTENCE boolean-constant ]
[ DISKSTORENAME disk-name ]
[ MAXQUEUEMEMORY integer-constant ]
[ ALERTTHRESHOLD integer-constant ]
)
SERVER GROUPS ( server_group_name [, server_group_name] * )
sender-name
A unique identifier for the gateway sender.
REMOTEDSID
An integer that uniquely identifies the remote SQLFire cluster to which this gateway sender
will send table DML operations. You must associate this remote SQLFire cluster with the local
SQLFire cluster when you start the locator(s) for the local cluster. See Configure Locators for
WAN Member Discovery on page 224.
SOCKETREADTIMEOUT
The amount of time in milliseconds that this gateway sender blocks while waiting to receive
an acknowledgment from a remote site. The default value is 10000 milliseconds.
MANUALSTART
443
SQL Language Reference