1.1.1

1 row selected
However, in SQLFire distributed system 2, the data dictinoary stores table FLGITHS at
version 2:
sqlf> values sys.get_table_version('APP','FLIGHTS');
1
-----------
2
1 row selected
The above situation can occur if, for example, ALTER TABLE was used on the FLIGHTS
table in distributed system 2. If the tables are otherwise equal (having identical column
definitions), you can use SYS.INCREMENT_TABLE_VERSION to make the version of
FLIGHTS in distributed system 1 equivalent for WAN replication purposes. In distributed
system 1:
sqlf> call sys.increment_table_version('APP','FLIGHTS',1);
Statement executed.
sqlf> values sys.get_table_version('APP','FLIGHTS');
1
-----------
2
1 row selected
See Create Tables with Gateway Senders on page 238.
SYS.SET_GLOBAL_STATEMENT_STATISTICS
Configures statement statistics collection for all members and client connections in a SQLFire distributed system.
This procedure enables or disables statement statistics collection for the distributed system as a whole. You can
optionally gather time statistics along with statement statistics. See Collecting System Statistics on page 283.
Syntax
SYS.SET_GLOBAL_STATEMENT_STATISTICS (
IN ENABLESTATS BOOLEAN NOT NULL,
IN ENABLETIMESTATS BOOLEAN NOT NULL
)
ENABLESTATS
Specifies whether the system should collect statement statistics.
ENABLETIMESTATS
Specifies whether the system should also collect time-based statement statistics.
Example
This command enables time-based statement statistics for the entire SQLFire distributed
system:
call sys.set_global_statement_statistics (true, true);
SYS.SET_TRACE_FLAG
Enables a sqlfire.debug.true trace flag on all members of the distributed system, including locators.
621
SQL Language Reference