Data sampling
Data sampling allows you specify that a subset of the rows in a Db2® object are loaded into the editor. This can be particularly useful when you are working with very large Db2® tables and require a representative sample of the data.
The Sampling type option on the Editor Options (2 of 8)
panel allows you to specify how you want FM/Db2 to select rows from
a Db2® object in order to provide
sample data:
- Clustered sampling
- A specified number of rows are loaded into the editor.
- Random sampling
- Each row of the object is considered for inclusion in the editor. A random number generator and a frequency are used to determine whether the row is actually loaded.
Each of these two methods of selecting sample data are discussed here in detail.