7.7.1.1 Executing the Data Retention Manager

Before you execute the Data Retention Manager, ensure that users are not working on the system. To avoid conflicts, Oracle recommends that you use this utility as part of the end-of-day activities.

The Data Retention Manager should be executed nightly for Daily partitioned and Mixed-date partitioned tables, after the calendar has been set for the next business day. For weekly and monthly partitioned tables, the Data Retention Manager should be executed prior to the end of the current processing period.

Note:

Oracle recommends running the Data Retention Manager on Thursday or Friday for weekly partitioned tables and on or about the 23rd of each month for monthly partitioned tables.

Set the system date with the Calendar Manager Utility prior to running the Data Retention Manager (refer to Managing Calendar Manager Utility for more information).

Running the Data Retention Manager

To run the Data Retention Manager manually, follow these steps:

1. Verify that the TBAML database is operational: tnsping <database instance name>
2. Verify that the <OFSAAI Installed Directory>/database/db_tools/mantas_cfg/ install.cfg configuration file contains the correct source database connection information.
3. Access the directory where the shell script resides: cd <OFSAAI Installed Directory>/database/db_tools/bin
4. Start the batch shell script with the parameters in the Table 7-17 table: run_drm_utility.sh <drm_operation> <drm_partition_type> <drm_owner> <drm_object_name> <drm_weekly_proc_fl>

The following are examples of running the script:

• To run the utility for all daily tables in the ATOMIC schema, execute the script: run_drm_utility.sh P D BUSINESS A N
• To run the utility to drop a monthly partition of the BUSINESS table ACCT_SMRY_MNTH, execute the script as follows (using the same parameters as in the previous example): run_drm_utility.sh DM M BUSINESS ACCT_SMRY_MNTH N