Propose Partition Ranges

The Propose Partition Ranges function proposes the partition ranges after taking the constraints of the databases with regards to the partitions into consideration.

The partitions are proposed based on following criteria:

  • Different databases have a different limitation on the number of records each partition can hold. For example, for SAP HANA it is 2 billion records per partition.

  • The partitioning is done based on a Date Field (column) in the database table. Once the user identifies the partitioning column in the database table the data load in the database table is analyzed and partition ranges are proposed. It is possible for the user to change the proposed ranges for the partitions. When the user changes the proposed ranges, automatic calculation takes place for the number of records available in the new range and adjustments are made to other ranges as well.

You can view the following details:

  • Data load of the database tables for different years and months in the form of a tree

  • Proposed partition ranges based on the existing data load

  • Existing partition ranges of the table

Settings in DAGPTC (Base Table and Date Field)

To make settings in DAGPTC, perform the following steps:

  1. Select the transaction Customizing for Partitioning (transaction DAGPTC).
  2. Choose the Edit Partitioning Objects. The Display View “Partitioning Object”: Overview window displays.
  3. Select the partitioning object.
  4. Choose Tables under Dialog Structure. The Change View Tables: Overview window displays.
  5. Select the table to be used as a base table for proposing partitions by checking the Base Table checkbox.
  6. Select the Date Field for the base table used for proposing partitions.
  7. Choose Save.

Propose Partition Ranges when Settings Are Maintained in DAGPTC (Base Table and Date Field)

The application delivers the partitioning objects with the following settings, such as Base Table and Date Field.

You can propose partition ranges for the tables associated with a partitioning object:

  1. To do so, select the transaction Manage Partitions (transaction DAGPTM).
  2. Select the partitioning object for which you want to propose partition ranges.
  3. Choose Propose Partition Range.
  4. Choose Generate Partition Ranges.
  5. In the Schedule Job window, choose Execute to schedule a job.

The partition ranges are created for all the tables associated with the partitioning object based on the selected proposed partition ranges.

Propose Partition Ranges when Settings Are not Maintained in DAGPTC

The application does not deliver the partitioning objects with settings such as Base Table and Date Field.

You can propose partition ranges for the tables associated with a partitioning object:

  1. To do so, select the transaction Manage Partitions (transaction DAGPTM).
  2. Select the partitioning object for which you want to propose partition ranges.
  3. Choose Propose Partition Range.
  4. Select the Date Field. This is used as a reference for distributing the data into multiple partitions in the database table. The data load in the database table is analyzed and partition ranges are proposed.
  5. Choose Propose Partition Ranges. You can view details such as data load for the table for which the Date Field was selected (Annual), existing partition ranges for the tables associated with the partitioning object, and proposed partition ranges.
  6. Select a proposed partition range.
  7. Choose Generate Partition Ranges.
  8. In the Schedule Job window, Choose Execute to schedule a job.

The partition ranges are created for all of the tables associated with the partitioning object based on the selected proposed partition ranges.