DSMSERV REMOVEDB (Remove a database)

Edit online

Use the DSMSERV REMOVEDB utility to remove an IBM® Storage Protect server database.

Attention: When you run this utility, you delete the server database, active log files, active log mirror files, and the backup and restore history of the database. However, the archive log files and archive log failover log files are deleted only after you start a point-in-time database restore.

If you plan to restore a database to its latest state, save the active log files before you run the DSMSERV REMOVEDB utility. The active log files are required to restore the database to its latest state.

You must halt the IBM Storage Protect server before you issue this command.

Syntax

Read syntax diagramSkip visual syntax diagram DSMSERV 1-uuser_name1-iinstance_dir-kServer12-kkey_name-ooptions_file-noexpire-quiet REMOVEDB database_name -force=No-force=NoYes
Notes:
  • 1 This parameter applies to AIX® and Linux® servers only.
  • 2 This parameter applies only to Windows servers.

Parameters

Linux operating systemsAIX operating systems-u user_name
Linux operating systemsAIX operating systemsSpecifies a user name to switch to before initializing the server.
Linux operating systemsAIX operating systems-i instance_dir
Linux operating systemsAIX operating systemsSpecifies an instance directory to use. This directory becomes the current working directory of the server.
Windows operating systems-k key_name
Windows operating systemsSpecifies 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 Storage Protect server database TSMDB1 and all of its references. 
dsmserv removedb TSMDB1

Example: Remove a database with force parameter

Remove the IBM Storage Protect server database TSMDB1 and all of its references, even if it has open connections:
dsmserv removedb TSMDB1 force=yes