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.
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:
- 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)
- 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.)
- 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.