Creating Partitions

You use the transaction Manage Partitions (DAGPTM) to create partitions for your tables.

To execute a data aging run, at least two partitions must always be available: A current partition and a historical partition. Without these partitions you cannot move any data in a data aging run.

A partitioning object created by using the Customizing for Partitioning (transaction DAGPTC) is visible in Manage Partitioning (transaction DAGPTM) only if it has one or more tables associated with it. If a partitioning object is a super partitioning object then it can be displayed in Manage Partitioning (transaction DAGPTM) provided the child partitioning object has tables associated with it. When you click a super partitioning object, all of the tables associated with it and tables associated with the child partitioning objects are displayed under the Existing Partition section. The tables that are not partitioned are displayed at the top of the list.

For each system, you need to define the partitions for the corresponding tables of a data aging object. A transport is not possible. Create the partitions as follows:

Execute the transaction DAGPTM to open the report.

Note

The report displays the partition objects and partition groups on the left panel.
Expand the partition objects to view the associated tables or partition objects if the partition object is a super partition object.
Expand the tables to view the associated partition ranges.
Select a table.
Choose Display Current and Historical Data for Partitions. This button is enabled only for table selection. The Display Current and Historical Data for Partitions of Table window is displayed. You can view the partitions and the number of records associated with each partition. You can also view the graphical representation of current and historical data in the partition ranges.

Note

If the table does not have any partition ranges associated with it, a message is displayed.
Select a partition object to view detailed information, such as the associated data aging objects and partition ranges.
Create new partition ranges for the existing partition object by specifying the Start Date and End Date and choose Partition in Background.

Note

The partition ranges can only be created at the root level. The execution is a background process. You need to choose Refresh to see the partition ranges that were created for the partition object.
If changes, such as adding a new table, are made to the existing partitioning object then the existing partitions need to be added to the new table. Choose Execute at root level.

Note

Execution is a background process. You need to choose Refresh to see the partition ranges that were created for the new table.
If changes are made to the super partitioning object like new table added or partition object added then the existing partitions need to be added to the new table or partition object. Choose Execute at the root level.

Note

Execution is a background process. You need to choose Refresh to see the partition ranges that were created for the new table.
Choose Create Partitioning Object/ Group to display the Customizing for Partitioning window (DAGPTC).

In the transaction DAGPTM, it is only possible to partition all tables of a partitioning object or all tables of a partitioning group at one time. You can also create new intervals only if the start date is after the latest end date of all existing intervals. Report RDAAG_PARTITIONING_FOR_JOB is available so that you can partition individual tables and, if necessary, close existing gaps. For more information, see SAP Note 1954012 Information published on SAP site .

Note that intervals are created differently from database to database. Make sure that you have familiarized yourself with the conditions of the intervals for the database you use, so that there are no gaps between the partitions for data aging and that the intervals do not overlap.