1.1.1

Syntax
SYS.diskstore_fsync (
IN DISKSTORENAME VARCHAR(128)
)
DISKSTORENAME
The name of the disk store, as specified in the CREATE DISKSTORE statement. (Default or
system-generated disk store names can be queried from the SYSDISKSTORES table.)
Example
Performs an fsync of the the data dictionary disk store file:
sqlf> call sys.diskstore_fsync('SQLF-DD-DISKSTORE');
Statement executed.
SYS.INCREMENT_TABLE_VERSION
Increments the data dictionary version of a table by a specified amount. Use this procedure in WAN deployments
to manually set the version of a table to match an identical table in another SQLFire distributed system.
A table must have identical column definitions in each cluster in order for SQLFire to replicate it between
clusters. As a best practice, use the same DDL command in each cluster to create the table. If you achieve identical
column definitions using different DDL commands (for example, by using ALTER TABLE to change one table
to match another), then you may need to use SYS.INCREMENT_TABLE_VERSION to ensure that both tables
have the same version in each cluster. Use the SYS.GET_TABLE_VERSION FunctionDisplays the data dictionary
version of a table. Use this procedure in WAN deployments to verify that the version of a table matches an
identical table in another SQLFire distributed system. to determine the data dictionary version of individual
tables.
Syntax
SYS.INCREMENT_TABLE_VERSION (
IN SCHEMANAME VARCHAR(128),
IN TABLENAME VARCHAR(128),
IN INCREMENT INTEGER
)
SCHEMANAME
The schema in which the table resides. Specify the schema in all uppercase letters.
TABLENAME
The name of the table to increment. Specify the table name in all uppercase letters.
INCREMENT
An integer value by which to increment the current table version.
Example
For this example, assume that the data dictionary in SQLFire distributed system 1 stores
table FLIGHTS at version 1:
sqlf> values sys.get_table_version('APP','FLIGHTS');
1
-----------
1
vFabric SQLFire User's Guide620
vFabric SQLFire Reference