3.7.1.1 Create Drop Partition Policy

This section provides the details on dropping the partition data from selected tables based on user defined criteria.

To create Drop Partition Policy, follow these steps:

1. Navigate to New Policy page.
2. Follow the steps mentioned in below sections:
   1. Step 1: Policy Definition
   2. Step 2: Selection
   3. Step 3: Condition

      Note:

      This section is not applicable to Drop Partition policy type.
   4. Step 4: Preview and Submit

Step 1: Policy Definition section

1. From Policy Details tab, click Start. The Policy Definition page is displayed.

   Figure 3-25 Policy Definition section

   
   

   

   
   
2. Enter the following details:
   • Name: Name of Policy
   • Description: Description of Policy
   • Type: Type of Policy as Drop Partition
   • Policy Execution Date: Select the execution date and time of policy using calendar
3. Click Continue.

Step 2: Selection section

1. Navigate to the Selection section. The Selection window is displayed to define the partitions.
2. Select the Partition type as Drop Partition or Truncate Subpartition.
   1. If Partition type is selected as Drop Partition, then following window is displayed:

      Figure 3-26 Partition type as Drop Partition

      
      

      

      
      
   2. Select the table(s) for which you want to do the partitions. The list of available partitions is displayed that contain data.
   3. Select the Partition Name. Partition Name shows the partition of the selected table from the database.

      The Partition details will be displayed in Partition Details section. This shows the Table Name, Partition Name, column name and metdata on which partition is created. This doesn’t show empty partitions.

   4. Click Continue.
   1. If Partition type is selected as Truncate Subpartition, then following window is displayed:

      Figure 3-27 Partition type as Truncate Subpartition

      
      

      

      
      
   2. Select the table(s) for which you want to do the sub partitions. The list of available sub partitions is displayed that contain data.
   3. Select the Sub Partition Name. Sub Partition Name shows the columns and metadata on which sub-partition has been created.

      The Sub Partition details will be displayed in Subpartition Details section. This shows the Table Name, Subpartition Name, column name and metdata on which partition is created. This doesn’t show empty partitions.

   4. Click Continue.

      Note:

      If only sub-partition is selected to remove then only data from it will deleted. Sub-partition is not dropped to enable customer re-load data in it, if needed. Sub-partitions in PBSM data model is created with a pre-defined list.

3. Click Continue.

Step 3: Preview and Submit section

1. Navigate to Preview and Submit section. Review the policy details.

   Figure 3-28 Preview and Submit section

   
   

   

   
   
2. Click Submit to create the policy. The created policy will be displayed on Data Housekeeping Summary page.