sqlf Launcher Commands

Use the sqlf command-line utility to launch SQLFire utilities.


To display a full list of sqlf commands and options:

sqlf --help

The command form to display a particular utility's usage is:

sqlf <utility> --help

With no arguments, sqlf starts an interactive SQL command shell:


With no arguments, specify the following options to run an SQLF script file and immediately exit the utility:

sqlf  [-p propertyfile] [-ca connectionAttributePropertyFile] [inputfile]

To launch and exit all other utilities, use the syntax:

sqlf <utility> <arguments for specified utility>

In this command form, <utility> is one of the following.

Utility name Description

Starts and stops a SQLFire Server member, and provides status of a running one.


Starts and stops a SQLFire Locator member, and provides status of a running one.


Starts and stops a GemFire JMX Agent, and provides status of a running one.


Prints SQLFire product version information.


Prints statistic values from a statistic archive.


Merges multiple logs files into a single log.


Prints any current SQLFire licenses and information needed to obtain a new license.


Encrypts a password for use in the sqlfire.properties file when using BUILTIN authentication.


Confirms whether files of a disk store are valid.


Displays SQLFire product version information.


Compacts an offline disk store to remove all unneeded records from the persistent files.


Asks all the distributed system members to compact their disk stores.


Asks the distributed system members to stop waiting for the specified disk store.


Prints disk stores that are currently missing from the distributed system.


Asks all the distributed system members to shut down.


Asks all the distributed system members to back up their persistent data.


In addition to launching various utilities provided with SQLFire, when launched without any arguments, sqlf starts an interactive command shell that you can use to connect to a SQLFire system and execute various commands, including SQL statements.

The launcher honors the current CLASSPATH environment variable and adds it to the CLASSPATH of the utility or command shell being launched. To pass additional arguments to the JVM, set the JAVA_ARGS environment variable when invoking the sqlf script.

Note: The JAVA_ARGS environment variable does not apply to the sqlf server, sqlf locator, and sqlf agent tools that launch a separate background process. To pass Java properties to those tools, use the -J option as described in the help for those tools.

The launcher uses the java executable that is found in the PATH. To override this behavior, set the SQLF_JAVA environment variable to point to the desired Java executable. (note the supported JRE versions in Supported Configurations and System Requirements).