sqlf revoke-missing-disk-store

Instruct SQLFire members to stop waiting for a disk store to become available.

Syntax


sqlf revoke-missing-disk-store <host> <directory>
  [-mcast-port=<port>]
  [-mcast-address=<address>]
  [-locators=<addresses>] [-bind-address=<address>] [-<prop-name>=<prop-value>]*

The table describes options and arguments for sqlf revoke-missing-disk-store. 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.

Option Description
<host> Host-name of the SQLFire member that hosts the disk store that you want to revoke.
<directory> Path to the disk store (on the specified SQLFire member) to revoke. If the disk store is spread over multiple directories, specify only the first directory in the list. Use sqlf list-missing-disk-stores to display descriptions of missing disk stores.
-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

This command first lists the missing disk store:

sqlf list-missing-disk-stores -mcast-port=3000
Connecting to distributed system: mcast=/239.192.81.1:3000
DiskStore at hosta.vmware.com /home/dsmith/dir2/.

Next, sqlf revokes the missing disk store if more recent data is available:

sqlf revoke-missing-disk-store hosta.vmware.com /home/dsmith/dir2/. -mcast-port=3000
Connecting to distributed system: mcast=/239.192.81.1:3000
revocation was successful and no disk stores are now missing

Finally, sqlf verifies that no disk stores are missing:

sqlf list-missing-disk-stores -mcast-port=3000
Connecting to distributed system: mcast=/239.192.81.1:3000
The distributed system did not have any missing disk stores