7.12.1 Running Scenario Tuning

To run the scenario tuning utility, follow these steps:

1. Go to ATOMIC schema and execute the following query:

   select distinct (creat_ts)
   from kdd_review t
   where t.review_type_cd = 'AL'
   and SCNRO_DISPL_NM <> 'User Defined'
   and PRCSNG_BATCH_NM = 'DLY';

2. Set date as per dates returned from above SQL.
   For example, if CREATE_TS is 05/21/2013 in the kdd_review table, then a date of 05/17/2013 (Friday of last week) is set from the $FICHOME/database/ db_tools/bin folder.
3. Execute the following command:

   start_mantas_batch.sh DLY
   set_mantas_date.sh 20130517 --(Friday of last week)

4. Execute DRM utility to create partitions, refer to Data Retention Manager Processing Parameters for parameter values:

   run_drm_utility.sh <Partition> <Weekly> <schema> <Table name> <drm_weekly_proc_fl>

   There should be different variations for each Oracle product. For example:

   run_drm_utility.sh P W ATOMIC KDD_TA_ML_DATA N
   run_drm_utility.sh P W ATOMIC KDD_TA_BC_DATA N
   run_drm_utility.sh P W ATOMIC KDD_TA_TC_DATA N

5. Execute the following Insert and Update Scenario Tuning scripts from the $FICHOME/database/ db_tools/bin folder:

   run_insert_ta_utility.sh
   run_update_ta_utility.sh

6. Repeat the process if you have more than one date returned from the query in Step 1.