Command Line Utilities
Use the snappy command-line utility to launch TIBCO ComputeDB utilities.
To display a full list of Snappy commands and options:
The command form to display a particular utility's usage is:
./bin/snappy <utility> --help
With no arguments,
snappy starts an interactive SQL command shell:
./bin/snappy To specify a system property for an interactive `snappy` session, you must define the JAVA_ARGS environment variable before starting `snappy`. For example, `snappy` uses the `snappy.history` system property to define the file that stores a list of the commands that are executed during an interactive session. To change this property, you would define it as part of the JAVA_ARGS variable: ```pre $ export JAVA_ARGS="-Dsnappy.history=/Users/user1/snappystore-history.sql" $ snappy
To launch and exit a
snappy utility (rather than start an interactive Snappy shell) use the syntax:
./bin/snappy <utility> <arguments for specified utility>
To specify a system property when launching a
snappy utility, use -J-Dproperty_name=property_value argument.
In addition to launching various utilities provided with TIBCO ComputeDB, when launched without any arguments,
snappy starts an interactive command shell that you can use to connect to a TIBCO ComputeDB system and execute various commands, including SQL statements.
backup and restore Creates a backup of operational disk stores for all members running in the distributed system. Each member with persistent data creates a backup of its own configuration and disk stores.
compact-all-disk-stores Performs online compaction of TIBCO ComputeDB disk stores.
compact-disk-store Performs offline compaction of a single TIBCO ComputeDB disk store.
revoke-missing-disk-store Instruct TIBCO ComputeDB members to stop waiting for a disk store to become available.
run Connects to a TIBCO ComputeDB distributed system and executes the contents of a SQL command file. All commands in the specified file must be compatible with the interactive Snappy Shell.
version Prints information about the TIBCO ComputeDB product version