Note: Documentation for Pivotal SQLFire 1.1.x is now available at Please reference the site for the latest and most up-to-date documentation on SQLFire. The vFabric SQLFire documentation site will no longer be updated.

sqlf list-missing-disk-stores

Lists all disk stores with the most recent data for which other members are waiting.


sqlf list-missing-disk-stores [-mcast-port=<port>]
  [-locators=<addresses>] [-bind-address=<address>] [-<prop-name>=<prop-value>]*

If no multicast or locator options are specified on the command-line, the command uses the file (if available) to determine the distributed system to which it should connect.

The table describes options for sqlf list-missing-disk-stores.

Option Description

Multicast port used to communicate with other members of the distributed system. If zero, multicast is not used for member discovery (specify -locators instead).

Valid values are in the range 0–65535, with a default value of 10334.


Multicast address used to discover other members of the distributed system. This value is used only if the -locators option is not specified.

The default multicast address is


List of locators used to discover members of the distributed system. Supply all locators as comma-separated host:port values.

-bind-address The address to which this peer binds for receiving peer-to-peer messages. By default sqlf uses the hostname, or localhost if the hostname points to a local loopback address.

Any other SQLFire distributed system property.


Handling Missing Disk Stores provides more details about listing and revoking missing disk stores.


sqlf list-missing-disk-stores -mcast-port=10334
Connecting to distributed system: mcast=/
1f811502-f126-4ce4-9839-9549335b734d [curwen.local:/Users/yozie/vmware/sqlf/vFabric_SQLFire_11_bNNNNN/server2/./datadictionary]