1.0

Manual compaction can be done for online and offline disk stores. For the online disk store, the current operation
log is not available for compaction, no matter how much garbage it contains.
Offline compaction runs essentially in the same way, but without the incoming CRUD operations. Also, because
there is no current open log, the compaction creates a new one to get started.
Note:
You must provide all of the directories in the disk store. If no oplog max size is specified, SQLFire uses
the system default.
Offline compaction can consume a large amount of memory. If you get a java.lang.OutOfMemory error
while running this command, you made need to increase the heap size by setting the -Xmx and -Xms
options in the JAVA_ARGS environment variable. sqlf Launcher Commands on page 339 provides more
information about setting Java options.
Example
sqlf compact-disk-store myDiskStoreName /firstDir /secondDir
maxOplogSize=maxMegabytesForOplog
The output of this command is similar to:
Offline compaction removed 12 records.
Total number of region entries in this disk store is: 7
sqlf encrypt-password
Generates an encrypted password string for use in the sqlfire.properties file when configuring BUILTIN
authentication.
Syntax
sqlf encrypt-password
Description
The command takes no arguments, but prompts for the password and then displays the encrypted password on
the console. If a console is not available, an exception is thrown.
Example
sqlf encrypt-password
Enter password: test_encryption (not echoed on screen)
Re-enter password: test_encryption (not echoed on screen)
Encrypted to 3b609a3eac42eee9f99e9b8c158b216df438755810ea
sqlf install-jar
Installs a JAR file and automatically loads the JAR file classes into the SQLFire class loader. This makes the
JAR classes available to all members of the distributed system (including members that join the system at a later
time).
• page 508
• Description on page 508
• Examples on page 396
345
sqlf Launcher Commands