Fragmenting by ROUND ROBIN

In a round-robin distribution scheme, specify at least two dbspaces (in Extended Parallel Server) or partitions (in Dynamic Server) where you want the fragments to be placed. As records are inserted into the table, they are placed in the first available fragment. The database server balances the load among the specified fragments as you insert records and distributes the rows in such a way that the fragments always maintain approximately the same number of rows. In this distribution scheme, the database server must scan all fragments when it searches for a row.

With Extended Parallel Server, you can specify a dbslice to fragment a table across a group of dbspaces that share the same naming convention. For a syntax alternative to FRAGMENT BY ROUND ROBIN IN dbslice that achieves the same results, see Storing Data in a dbslice (XPS).

With Dynamic Server, you can use the PUT clause to specify round-robin fragmentation for smart large objects. For more information, see the PUT Clause (IDS).