Defining the partitioning key when creating a table

Use the Partitioning Key page of the Create Table notebook to define the partitioning key for the table.

The partitioning key can only be changed later if this table resides in a single-node nodegroup.

To define the partitioning key:

1. Click on the Partitioning Key tab.

2. In the Available columns box, select the column or columns that you want to define as partitioning key columns.

3. Click on the > push button to move the selected column or columns to the Partitioning key columns box.

4. If you do not want to add foreign keys or check constraints, click on OK to create your table and close the Create Table notebook. Otherwise, continue on to one or more of the optional tasks.

Related information

• Partitioning key -- See the SQL Reference

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]