How to schedule the DDMDB maintenance and optimization scripts.

book

Article ID: 50780

calendar_today

Updated On:

Products

CA Spectrum

Issue/Introduction

Description:

Sometimes user needs to schedule the DDMDB scripts instead of running it manually every time when the DDMDB size increases to a large amount. This can be done using the post_olb_script or using the Windows scheduler.

Solution:

In order to schedule the DDMDB maintenance and optimization scripts to have them run after a certain time period, we need to do some custom coding in the post_olb_script so that when the ddmdb is backed up after a SSDB backup, these scripts will run and optimize the ddm database. Attached is a sample post_olb script which runs the ddmdb scripts after every ddmdb backup. You can also use Windows scheduler to schedule the scripts. following is the process required:

  1. Create a bat file with the below code
    perl C:\win32app\SPECTRUM\SS\DDM\scripts\db_optimize.pl -q (Make sure you have the perl package on the window machine to execute the .pl scripts)

  2. Now create a schedule task for the batch file using the windows scheduled tasks option to run the batch file at your convenient time (i.e. every day or every week etc.)

  3. Make sure you check the schedule logs to ensure that the configured scheduled task has run successfully or not.

Note: CA Support is not responsible for any customization done by the client. Also make sure you stop the Archive Manager when you schedule the DDmDB Maintenance script.

Environment

Release:
Component: SPCCSS

Attachments

1558535281915TEC538204.zip get_app