DX NetOps Manager

CA Spectrum mandates to convert Archive Manager Distributed Data Manager (DDM) database engine from MyISAM to InnoDB before upgrading to 10.4 for better performance. CA Spectrum 10.3 and above supports InnoDB engine for DDM database.

Refer the doc for converting DDM database engine from  MyISAM to InnoDB  https://docops.ca.com/ca-spectrum/10-3-0/en/installing-and-upgrading/upgrading#Upgrading-PostUpgradeTasks 

After conversion use ddm_save.pl & ddm_load.pl which uses MySQL Enterprise Backup solution to take backup and restore DDM database for better performance. These utilities are supported from CA Spectrum 10.3.1 and above.

•        Take a backup of DDM database to refer “Save the DDM Db when Archive Manager is running” section   https://docops.ca.com/ca-spectrum/10-3-1/en/administrating/database-management/ddm-database-maintenance/database-backup/ddm_save  
•        To restore DDM database refer “Loading the DDM Db” sectionhttps://docops.ca.com/ca-spectrum/10-3-1/en/administrating/database-management/ddm-database-maintenance/database-restoration/ddm_load
•        In post_olb_script  useddm_save.pl  to schedule  backup of InnoDB DDM database 

Note: Classic utilities for saving /restoring DDM DB (ddm_save, ddm_load & ddm_backup ) will not be supported from CA  Spectrum 10.4

 References :

MySQL Enterprise Backup performs hot backup operations for MySQL databases. The product is architected for efficient and reliable backups of tables created by the InnoDB storage engine: https://dev.mysql.com/doc/refman/5.7/en/mysql-enterprise-backup.html

MySQL Enterprise Backup performance results: https://www.mysql.com/products/enterprise/backup.html 

Thanks,

Spectrum Product Management