ddm_load

This utility, which is located in the $SPECROOT/SS/DDM directory, lets you restore the DDM database. First, it initializes (removes all data from) the DDM directory, and then it loads the save file that you specify. Initialization occurs automatically if you are loading a save file or directory. The -initialize option is only required if you want to clean out the DDM directory and start from nothing. With that option, the landscape handle for the associated SpectroSERVER is also required.
casp1032
This utility, which is located in the
$SPECROOT
/SS/DDM directory, lets you restore the DDM database. First, it initializes (removes all data from) the DDM directory, and then it loads the save file that you specify. Initialization occurs automatically if you are loading a save file or directory. The -initialize option is only required if you want to clean out the DDM directory and start from nothing. With that option, the landscape handle for the associated SpectroSERVER is also required.
Before you execute the command, shut down the Archive Manager from the Control Panel. Then restart it when the restoration has completed.
This command has the following format:
ddm_load [-quiet] [-initialize <LANDSCAPE_HANDLE>] [-events_init] [-stats_init][<SAVE_FILE>]
Where the first letter of an argument name appears in bold type, you can use the letter only, rather than entering the full string.
  • -quiet
    Disables prompts (interactive mode). Useful for running load commands from within a script.
  • -initialize
    Removes all data from the DDM database. Used only with the LANDSCAPE_HANDLE argument.
  • <LANDSCAPE_HANDLE>
    Specifies the landscape handle of the SpectroSERVER whose database is being initialized.
  • -events_init
    Initializes (removes)
    only
    the event records in the DDM database.
  • -stats_init
    Initializes (removes)
    only
    the statistical records in the DDM database.
  • <SAVE_FILE>
    Specifies the name of the backup file to load. The ddm_load utility supports both the new gzipped tar file format and the legacy, proprietary file format.
Support for InnoDB Database
From 10.3 release, CA Spectrum supports importing the InnoDB database files in to Archive Manager database. The importing procedure requires a temporary directory to uncompress the InnoDB database files.
The space required to import the InnoDB database files is two times greater than the event table size.
The DDM load supports importing both MyISAM and InnoDB database files based on the current running database engine (MyISAM or InnoDB). For example, if the Archive Manager database is running on the MyISAM database, you can import only the MyISAM database files.
Convert Saved MyISAM Database Files to InnoDB Database Files
From CA Spectrum 10.3 release, you can convert your saved Archive Manager database file from MyISAM to InnoDB.
Prerequisite
  • Ensure that there is enough free disk space. The space required is three times greater than the event table size.
Follow these
:
  1. Open any bash-shell and navigate to $SPECROOT/SS/DDM/scripts.
  2. Run the following script as
    Spectrum installation user
    :
    For example, when you run the script for the tgz file, you get the following message:
    This utility converts the saved MyISAM database file to InnoDB database
    -f: path to the dump file
    -h: print this message
    Example: ./convert_myisam_to_innodb.pl -f db.tgz
    xxxx03-w2k8vm2%/d/builds/Spectrum/Armgr.a/buildfiles > ./convert_saved_myisam_to_innodb.pl -f /c/db.tgz 
Loading the DDM Db 
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 Spectrum 10.3.1, ensure improved performance with the MySQL backup and save the DDM Db.
1. To load the DDM db, ensure you are signed in as a spectrum user to run the following script: 
./ddm_load.pl  -f  <filename.mbi> 
The
OptionsArguments
are as follows: 
  •  -quiet
     Disables prompts (interactive mode). Useful for running load commands from within a script.
  •  -initialize: 
     Initializes the database. Removes all data from the DDM database. Used only with the LANDSCAPE_HANDLE argument
  • -landscape <LANDSCAPE_HANDLE>
       
     Specifies the landscape handle of the SpectroSERVER whose database is being initialized.
  • -events_init 
     Initializes the events database only. Initializes (removes) 
    only
     the event records in the DDM database.
  •  
    -stats_init   
                                                     
     Initializes only the statistical database records in the DDM database.
  •  -f <SAVE_FILE> 
                                         
      Specifies the name of the backup file to load.