8.6.4.1 Configuring the Data Retention Manager

The <INSTALL_DIR>/database/db_tools/mantas_cfg/install.cfg file contains common configuration information that Data Retention Manager and other utilities require for processing (See Figure 15 for a sample install.cfg file).

Note:

The configuration parameters in the install.cfg are only used if command line parameters are not provided. It is strongly recommended that you provide command line parameters instead of using the install.cfg parameters.

The Data Retention Manager automatically performs system checks for any activity that may result in an error (for example, insufficient space in the tablespace). If it discovers any such activity, it logs a Warning message that identifies the potential problem. If Data Retention Manager fails to run successfully, you can configure the utility so that the ingestion process for the following day still proceeds.

The following sample section from the install.cfg file provides other configuration information specific to this utility, including required and optional parameters.

#########DATA RETENTION MANAGER CONFIGURATION ###################
Set the Data Retention Manager input variables here.
##drm_operation=P
drm_partition_type=A
drm_owner=${schema.mantas.owner}
drm_object_name=A
drm_weekly_proc_fl=Y

This example shows default values that the system uses only when calling the utility with no command line parameters.

Table 8-15 Data Retention Manager Processing Parameters

Parameter	Description
drm_operation	Operation type: P: Partition AM: Add Monthly Partition DM:Drop Monthly Partition RI: Rebuild Indexes RV:Recompile Views T: Truncate Current Partition
drm_partition_type	Partition type: D: DailyW: Weekly M: Monthly X:Mixed-Date A:All Partitions (Daily, Weekly, Monthly)
drm_owner	Owner of the object (database schema owner).
drm_object_name	Object name. If performing an operation on all objects, the object name is A.
drm_weekly_proc_fl	Flag that determines whether partitioning occurs weekly (Y and N).

Note:

The system processes Daily partitioned tables (drm_partition_type=D) and Mixed-date partitioned tables (drm_partition_type=X) simultaneously. Therefore, you need only specify D or X to process these tables.

An example for the Mixed-date partition, for the present date 20050711, is:

P20050711 (Current Day)
P20050708 (Previous Day and End of week #1) 
P20050701 (End of previous week #2) 
P20050630 (End of previous Month #1) 
P20050624 (End of previous week #3) 
P20050617 (End of previous week #4) 
P20050531 (End of previous Month #2)