Previous Topic: Add a Range Table PartitionNext Topic: Generate Code

Create a DB2 z/OS Table Partition › Add a Size Table Partition

Add a Size Table Partition

In a Size table partition, the table is divided into partitions of a specified size in gigabytes. The maximum size of a Size Table Partition is 256 GB.

You can create a table partition by specifying the size of the partition.

Follow these steps:

  1. Select the Size partition type from the CA Gen DB2 z/OS Table Partitioning Plug-in dialog.
  2. Specify the size of the partition in gigabytes in the text box.

    Note: The size can be any number from 0 through 256 GB. This size must match the value of DSSIZE set on the Tablespace Defaults for the DB2 z/OS Technical Design.

  3. (Optional) Select Append to indicate that the APPEND YES clause must be added to the generated DDL.
  4. Click OK.

    The changes are saved in the model and CA Gen DB2 z/OS Table Partitioning Plug-in is closed.

Note: Click Cancel to close the dialog without saving any changes in the data model. Clear All clears the table columns selected for a range table partition or the size specified for a size table partition.

Note: In Toolset, click Tools, Design, Data Structure List. The list of tables is diaplayed. Tables with partition are labeled as Has Partitioning.