To specify a round-robin distribution scheme, use the FRAGMENT BY ROUND ROBIN clause of the CREATE TABLE statement. The following statement illustrates a fragmented table with a round-robin distribution scheme:
CREATE TABLE account_2 ... ... FRAGMENT BY ROUND ROBIN IN dbspace1, dbspace2, dbspace3
When the database server receives a request to insert a number of rows into a table that uses round-robin distribution, it distributes the rows in such a way that the number of rows in each of the fragments remains approximately the same. Round-robin distributions are also called even distributions because information is distributed evenly among the fragments. The rule for distributing rows to tables that use round-robin distribution is internal to the database server.