7.6.1.2 Utility Work Tables

The Data Retention Manager uses the KDD_DR_MAINT_OPRTN and KDD_DR_JOB work tables during database partitioning.

KDD_DR_MAINT_OPRTN Table

The KDD_DR_MAINT_OPRTN table contains the processing information that manages Data Retention Manager activities. The following table provides these details.

Table 7-19 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:
  • A:Analyze
  • RI: Rebuild Indexes
  • P:Partition
  • 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:
  • D:Daily
  • W:Weekly
  • M:Monthly
  • 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.
NEXT_PARTN_DATE Indicates starting date of the next partition that may get created, based on the current partitioned date.

Note:

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

KDD_DR_JOB Table

The KDD_DR_JOB table stores the start and end date and time and the status of each process that the Data Retention Manager calls. The following table provides these details.

Table 7-20 BUSINESS.KDD_DR_JOB Table Contents

Column Name Description
JOB_ID Unique sequence ID.
START_DT Start date of the process.
END_DT End date of the process.
STATUS_CD Status of the process:
  • RUN:Running
  • FIN: Finished successfully
  • ERR: An error occurred
  • WRN: Finished with a warning

KDD_DR_RUN Table

The KDD_DR_RUN table stores the start and end date and time and status of individual process runs that are associated with a table. The following table provides these details.

Table 7-21 BUSINESS.KDD_DR_RUN Table Contents

Column Name Description
JOB_ID Unique sequence ID.
PROC_ID Process ID.
START_DT Start date of the process.
END_DT End date of the process.
RSULT_CD Result of the process:
  • FIN: Finished successfully
  • ERR: An error occurred
  • WRN: Finished with a warning
ERROR_DESC_TX Description of a resulting error or warning.

The system also uses the KDD_CAL table to obtain information such as the dates of the last-day-of-previous-month and end-of-weeks. Refer to KDD_CAL table contents.