1.1

DescriptionOption
Specifying -sync=false (the default for locators) causes the
sqlf command to return control after the member reaches
"waiting" state. With -sync=true (the default for servers), the
sqlf command does not return control until after all dependent
members have booted and the member has finished synchronizing
disk stores.
Always use -sync=false when starting multiple members
on the same machine, especially when executing sqlf commands
from a shell script or batch file, so that the script file does not hang
while waiting for a particular SQLFire member to start. You can use
the sqlf locator wait and/or sqlf server
wait later in the script to verify that each server has finished
synchronizing and has reached the "running" state. For example:
#!/bin/bash
# Start all local SQLFire members to
waiting state, regardless of which
member holds the most recent
# disk store files:
sqlf locator start -dir=/locator1
-sync=false
sqlf server start -client-port=1528
-locators=localhost[10334]
-dir=/server1 -sync=false
sqlf server start -client-port=1529
-locators=localhost[10334]
-dir=/server2 -sync=false
# Wait until all members have
finished synchronizing and starting:
sqlf locator wait -dir=/locator1
sqlf server wait -dir=/server1
sqlf server wait -dir=/server2
# Continue any additional tasks that
require access to the SQLFire
members...
[...]
Causes the new member to trigger a rebalancing operation for all
partitioned tables in the system. The system always tries to satisfy
-rebalance
the redundancy of all partitioned tables on new member startup
regardless of this option.
Comma-separated list of files containing initial SQL commands to
be executed by this member prior to executing any other commands.
-config-scripts
The format of these files is same as that required by the SQLFire
command shell.
The scripts in "-config-scripts" should include configuration and
other options, or initial DDL statements to be executed before any
383
sqlf Launcher Commands