Online Documentation for SQL Manager for DB2

Managing distribution

This tab is available only for database server version 9.7.

Use this tab to define parameters for data distribution across database partitions.

Move the needed fields from Available fields to the Distribute by fields list to form distribution key.

Note that no BLOB, CLOB, DBCLOB, XML and ROW CHANGE TIMESTAMP containing fields can be used as a distribution key.