Running the Data Retention Manager

Verify that the Behavior Detection database is operational:

tnsping
                        <database instance name>

Verify that the

<OFSAAI Installed
                        Directory>/database/db_tools/mantas_cfg/ install.cfg

configuration file contains the correct source database connection information.

Access the directory where the shell script resides:

cd <OFSAAI
                        Installed Directory>/database/db_tools/bin

Start the batch shell script with the parameters in Data Retention Manager Processing Parameters:

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

7.6.1.1.1 Running the Data Retention Manager