sqlf list-missing-disk-stores

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

Syntax

sqlf list-missing-disk-stores [-mcast-port=<port>]
  [-mcast-address=<address>]
  [-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 sqlfire.properties 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
-mcast-port

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.

-mcast-address

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 239.192.81.1.

-locators

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.
-prop-name

Any other SQLFire distributed system property.

Description

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

Example

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