ddm_save

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.
casp1032
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.
  •  
    -extension
    By default, ddm_save assigns a .tgz file extension to the file. When this argument is specified, the file is saved without a file extension
  •  
    -quiet
    Disables interactive/verbose mode
  •  
    <SAVE_FILE>
     
    Specifies the name of the destination file for the saved database
     The 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 
mysqlbackup
 client. 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.
  1. 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 
    -q 
    and
     -f
     option you are signed in as a spectrum user. 
  2. When prompted, '
    Are you running as
    CA Spectrum
    install user (y/n)
    ' if you say 'n' then you get the following message: 
    Please make sure you are running as
    DX NetOps Spectrum
    install user, otherwise DDMdb may get corrupted.
The 
OptionsArguments
 are as follows: 
  •  
    -quiet
    Disables interactive/verbose mode. 
  •  
    <SAVE_FILE>
     
    Specifies the name of the destination file for the saved database.