Database Backup

You can back up the contents of a single database table, multiple database tables, or your entire CA SDM database, using the database backup utility, pdm_backup. The output of the backup utility is an ASCII file that the pdm_restore utility can use.
casm1401
You can back up the contents of a single database table, multiple database tables, or your entire CA SDM database, using the database backup utility, pdm_backup
.
The output of the backup utility is an ASCII file that the pdm_restore utility can use.
As part of its processing, pdm_backup first shuts down the daemons (UNIX) or services (Windows). pdm_backup stops CA SDM and then writes one or more tables from a CA SDM database to an ASCII file. You can use this output file as the input file to pdm_restore. In addition to the contents of the database, pdm_backup backs up application configuration files.
If you have operating environment-specific backup tools, we recommend that you use them instead of pdm_backup. Because pdm_backup is a generic tool, it can be slow on some operating environment combinations.
As part of its processing, pdm_backup first shuts down the daemons (UNIX) or services (Windows).
Syntax
This command has the following format:
pdm_backup [-d] [-g] [-v] -f filename [ALL | table1...tableN]
-d
Specifies to back up the database data only.
-g
Specifies that only non-database data be backed up. This means only windows (forms) and other non-database data is backed up.
-v
Specifies verbose mode, which writes comments about command progress to stdout.
-f
filename
Specifies an output file.
ALL|table1...tableN
Specifies ALL files or the table or tables to write. If more than one table is specified, separate each with spaces.
  • You can find table names in the CA SDM database schema file, ddict.sch, located in $NX_ROOT/site (UNIX) or
    installation-directory
    \site (Windows). $NX_ROOT or
    installation-directory
    is the directory where you installed CA SDM.
  • If no table is specified, the entire CA SDM database is written, including window groups and menu registration files.
Restrictions
pdm_backup cannot be run while CA SDM is active.
On UNIX, the LIBPATH must be set before running several CA SDM utilities. Use
pdm_task
to set the LIBPATH before running a utility. For example, input "pdm_task pdm_clean_attachments ...".