Online Documentation for SQL Manager for DB2

Managing distribution


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.

 

Global Temporary Table - Managing distribution