The ddm_save utility, which is located in the $SPECROOT/SS/DDM directory, performs a full save of the historical database to the file you specify. Use the Control Panel to shut down the Archive Manager before executing the command, and then restart it when the save is completed.
The ddm_save utility, which is located in the
$SPECROOT/SS/DDM directory, performs a full save of the historical database to the file you specify. Use the Control Panel to shut down the Archive Manager before executing the command, and then restart it when the save is completed.
The ddm_save binary coming with the previous releases has been deprecated in 10.4.1. From 10.4.1 onward, use ddm_save.pl.
The ddm_save utility does not remove any data from the DDM database; it copies it to the designated file.
The utility has the following format:
ddm_save [-extension] [-quiet] <SAVE_FILE>
Where the first letter of an argument name appears in bold type, you can use the letter only, rather than entering the whole name.
- -extensionBy default, ddm_save assigns a .tgz file extension to the file. When this argument is specified, the file is saved without a file extension
- -quietDisables interactive/verbose mode
- <SAVE_FILE>Specifies the name of the destination file for the saved databaseThe ddm_save command saves the necessary database files to a gzipped tar file format with a default file extension of .tgz.
Support for InnoDB Database
The 10.3 release supports saving/exporting the InnoDB database files into the Archive Manager database. The exporting procedure requires a temporary directory to compress the InnoDB database files.
The space required to save/export the InnoDB database files is two times greater than the event table size.
While saving/exporting the InnoDB database files, ensure that the Archive Manager database is running on the InnoDB database. The save/export database format depends on the current running database.
Save the DDM Db when Archive Manager is running
All MySQL Enterprise Backup functions are executed with the
mysqlbackupclient. It is used for performing different types of backup and restore operations, as well as other related tasks like backup compression, decompression and validation. With 10.3.1, ensure improved performance with the MySQL backup and save the DDM Db without having to stop the Archive Manager.
- To save the DDM db and create a <filename.mbi> file which to be used for loading the db, ensure you are signed in as a spectrum user and run the following script:./ddm_save.pl -f <filename>Ensure that with both the-qand-foption you are signed in as a spectrum user.
- When prompted, 'Are you running as' if you say 'n' then you get the following message:CA Spectruminstall user (y/n)Please make sure you are running asDX NetOps Spectruminstall user, otherwise DDMdb may get corrupted.
OptionsArgumentsare as follows:
- -quietDisables interactive/verbose mode.
- <SAVE_FILE>Specifies the name of the destination file for the saved database.