1.0

Example
The following code adds an example writer implementation to a table. Example Writer
Implementation on page 184 shows the writer code.
Connection conn = getConnection();
CallableStatement cs = conn
.prepareCall("CALL SYS.ATTACH_WRITER(?,?,?,?,?)");
cs.setString(1, “test”);
cs.setString(2, “table”);
cs.setString(3, “testpackage.EventCallBackWriterImpl”);
cs.setString(4, “emp.ftable:3”);
cs.setString(5, null);
cs.execute();
SYS.REBALANCE_ALL_BUCKETS
Rebalance partitioned table data on available SQLFire members.
Syntax
SYS.REBALANCE_ALL_BUCKETS()
Rebalancing is a SQLFire member operation that affects partitioned tables created created in the cluster.
Rebalancing performs two tasks:
1. If the a partitioned table's redundancy setting is not satisfied, rebalancing does what it can to recover
redundancy. See Making a Partitioned Table Highly Available on page 58.
2. Rebalancing moves the partitioned table's data buckets between host members as needed to establish the best
balance of data across the distributed system.
For efficiency, when starting multiple members, trigger the rebalance a single time, after you have added all
members.
Rebalancing Partitioned Data on SQLFire Members on page 59 provides additional information about the
rebalancing operation.
Example
sqlf> call sys.rebalance_all_buckets();
SYS.REMOVE_LISTENER
Remove a listener implementation that you previously added to a table.
Syntax
SYS.REMOVE_LISTENER
(
IN ID VARCHAR(128),
IN SCHEMA VARCHAR(128),
IN TABLE VARCHAR(128)
)
ID
The unique identifier of the listener that you want to remove.
SCHEMA
The schema of the table that has the specified listener.
TABLE
The name of the table that has the specified listener.
569
SQL Language Reference