Partitions (Create Table Space)

The Create Table Space: Define Partitions panel is optional, even for the definition of a partitioned table space. However, you might want to specify parameters for each partition of a partitioned table space, rather than relying on the values set at the table space level.

For a partitioned table space, there is an optional 'USING CLAUSE' for every partition of the table space. You can define the number of partitions on the Table Space Type panel before selecting this panel. The table at the bottom of the panel is pre-formatted with the required number of rows (one for each partition).

Alternatively, you can select the Define Partitions panels directly. The number of pre-formatted rows reflect the value specified for a number of partitions (the default value is 1). You can then adjust the values for this single partition to what is required. After this is done, you can use the R prefix command (optionally followed by an integer) to expand the number of partitions to the required number. The value specified for number of partitions on the Table space Type panel is updated accordingly.

Note: The individual partitions of a partitioned table space are typically defined with similar parameters. It is easier for you to define the values once, then repeat them, rather than type the same information in for each row repeatedly.

The Db2® default values for Free Pages, Percent Free, Data Compression and GBPCACHE are used.

Related references