8.6.5.1 KDD_DR_MAINT_OPRTN Table

The KDD_DR_MAINT_OPRTN table contains the processing information that manages Data Retention Manager activities.Table 58 describes the table’s contents.

Table 8-17 BUSINESS.KDD_DR_MAINT_OPRTN Table Contents

Column Name Description
PROC_ID Identifies the sequence ID for the operation to perform.
ACTN_TYPE_CD

Indicates the activity that the utility is to perform on the table:

  • l A: Analyze
  • l RI:Rebuild Indexes
  • l P:Partition
  • l RV:Recompile Views
OWNER Identifies an owner or user of the utility.
TABLE_NM Identifies a database table.
PARTN_TYPE_CD

Indicates the partition type:

  • l D:Daily
  • l W:Weekly
  • l M: Monthly
  • l X:Mixed Date
TOTAL_PARTN_CT

Specifies the total number of partitions to be created, including the current partition.

For example, for a daily partitioning scheme of four previous days and the current day, the value of this field is five (5).
BUFFER_PARTN_CT

Specifies the number of buffer partitions the utility is to maintain, excluding the current partition.

For example, a two-day buffer has a value of two (2).
CNSTR_ACTN_FL Determines whether to enable or disable constraints on the table during processing.
WEEKLY_ADD_FL

Indicates whether daily partitions are added for a week at a time. If set to Y, creates Daily Partitions for the next week.

For example, if run on a Thursday, the DRM creates the five (5) partitions for the next week beginning with Monday.

Note:

For weekly partitioned tables, do not set the value to Y.