7.7.2 Utility Work Tables

The Data Retention Manager uses the following 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.

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.

Table 7-20 BUSINESS.KDD_DR_JOB Table Contents

ColumnName 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.

Table 7-21 BUSINESS.KDD_DR_RUN Table Contents

ColumnName 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-ofprevious- month and end-of-weeks. Refer to Table 7-15e for contents of the KDD_CAL table.