DSMSERV REMOVEDB (Remove a database)
Use the DSMSERV REMOVEDB utility to remove an IBM Spectrum Protect server database.
When you run this utility, you delete the server database, active log files, and active log mirror files. However, the archive log files and archive log failover log files are deleted only after you start a point-in-time database restore.
You must halt the IBM Spectrum Protect server before you issue this command.
Syntax
Parameters
- -u user_name
- Specifies a user name to switch to before initializing the server.
- -i instance_dir
- Specifies an instance directory to use. This becomes the current working directory of the server.
- -k key_name
- Specifies the name of the Windows registry key from which to retrieve information about the server. The default is SERVER1.
- -o options_file
- Specifies an options file to use.
- -noexpire
- Specifies that expiration processing is suppressed when starting.
- -quiet
- Specifies that messages to the console are suppressed.
- database_name
- The database name that was entered during installation. If the database was formatted manually, then this is the database name parameter in the DSMSERV FORMAT or DSMSERV LOADFORMAT utility. This database name can also be found in dsmserv.opt file. This parameter is required.
- -force
- Specifies whether the database is removed when there are open connections. The default is No. This parameter is optional. The values are as follows:
- Yes
- Specifies that the database is removed regardless of open connections
- No
- Specifies that the database is removed only when all connections are closed.
Example: Remove a database
Remove the IBM Spectrum Protect server database TSMDB1 and all of its references.dsmserv removedb TSMDB1
Example: Remove a database with force parameter
Remove the IBM Spectrum Protect server database TSMDB1 and all of its references, even if it has open connections:dsmserv removedb TSMDB1 force=yes