What is the difference between SQL Optimization script (DsmMsSqlOpt.bat database maintenance) and CORA cleanup?

Document ID : KB000022193
Last Modified Date : 14/02/2018
Show Technical Document Details

Question: 

What is the difference between SQL Optimization script (DsmMsSqlOpt.bat database maintenance) and CORA cleanup? Does CORA cleanup replace DsmMsSqlOpt.bat maintenance?

Environment:  

All versions of Client Automation

Answer: 

CORA Cleanup and DSMMSSqlOpt.bat maintenance are two different entities.

CORA (Common Object Registration API) Cleanup, is built to correct problems that exist in the CORA tables due to previous issues and environment related issues in which the MAIN MDB tables CO RA (ca_logical_asset, ca_asset, ca_asset_source etc...) have corrupted entries where the linkage using asset_uuids maybe corrupt or problematic. CORA cleanup goes through these tables looking for problematic entries and corrects them as required.

DSMMSSqlOpt.bat was created as a tool for optimizing the data within SQL Server in regards to Client Automation. DSMMSSqlOpt.bat is a CA Technologies written maintenance script for optimizing the MDB for performance improvement, (similar to normal MS SQL Server maintenance plan). You can run this periodically with a maintenance plan. This script reorganizes the data and rebuild indexes within the DB, so that SQL can find records faster.

Note: It is recommended to run the CORA cleanup and the SQL Optimization atleast once a month to optimize the performance of the server.

 

Additional Information:

Please contact CA Support for the CORA Cleanup utility.