Online Documentation for SQL Manager for DB2

Managing distribution


This tab is available only for database server version 9.7.

 

It can be used to define partitioning or the way the data is distributed across multiple database partitions.

 

CheckBox Replicated across database partitions

If the option is enabled, the data stored in the table is physically replicated on each database partition of the database partition group for the table spaces in which the table is defined. This means that a copy of all of the data in the table exists on each database partition.

 

Disable the option to distribute data by fields (distribute by hash method will be used). 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.

 

New MQ table - Managing distribution