1.1.1

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 68.
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 69 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.
Example
Connection conn = getConnection();
CallableStatement cs = conn
.prepareCall("CALL SYS.REMOVE_LISTENER(?,?,?)");
cs.setString(1, "id");
cs.setString(2, "test");
cs.setString(3, "table");
cs.execute();
SYS.REMOVE_LOADER
Remove a loader from a table given the schema and table name.
Syntax
SYS.REMOVE_LOADER
(
IN SCHEMA VARCHAR(128),
IN TABLE VARCHAR(128)
)
SCHEMA
The schema of the table that has the loader that you want to remove.
615
SQL Language Reference