Previous Topic: Add Columns to a Range Table PartitionNext Topic: Add a Size Table Partition

Create a DB2 z/OS Table Partition › Add Columns to a Range Table Partition › Add a Range Table Partition

Add a Range Table Partition

CA Gen automatically generates a number for the partition while adding the range partition. Set the ending values for each of the table columns of the partition.

Follow these steps:

  1. Click Edit, Add Partition.

    The Add Range Table Partition dialog opens.

  2. Specify the following field information:
    Partition Number

    Displays the count of the partitions for the table column. This number is automatically generated.

    Columns

    Displays the name of the table columns and an enterable drop-down list box beside each of the table column names. You can specify the ending values for each of the table columns in their respective text boxes. These values are designed as mixed text, that is, they can accept single byte and double byte characters regardless of the domain type of the column for which the values are being defined. For example, a column whose domain is set to DBCS in the ERD, you can enter single-byte characters into the value field for any range partitions defined on that column. Similarly, a column whose domain is set to TEXT in the ERD, you can enter double byte characters into the value field for any range partitions defined on that column. If you type values of incorrect data type, the values are not accepted. This field is case insensitive. If you change AM to am, the plug-in does not recognize the change. MINVALUE or MAXVALUE selects are available for all columns in the drop-down. For columns that have discreet permitted values (not ranges), those permitted values are available for selection from the drop-down list as well.

    Note: Click Date Data Type, Numeric Data Type, Text Data Type, Time Data Type, or Timestamp Data Type to view the rules for each data type.

  3. Click Add.

    Note: Verify that the data in the columns of range partitions are sorted and that the data in two or more rows is not identical.

  4. Click Cancel to close the dialog.

    The values are added in the CA Gen DB2 z/OS Table Partitioning Plug-in window under the Range option of the Partition Type area.

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