mxdbs db-delete

Syntax

mxdbs db-delete [-h | --help] database_name

Description

The mxdbs db-delete sub-command deletes a database from the system.

Parameters

database_name
Specifies the name of the database to be deleted.

Options

-h | --help
Displays the help message and exits.

Considerations

  • All the schemas in the database are deleted. The delete operation cannot be rolled back after the operation completes.
  • HPE recommends you to close all the applications accessing the database before deleting the database.
  • If the database objects are in use or opened by the applications, deleting the database may fail.
  • The MXCS datasource associated with the database is stopped even if applications are connected to the database. The application connections to the database are broken and further use of connection by the application will result in error.
  • The Safeguard file-sharing group associated with the database is removed from all the volume ACLs that were assigned to the database.
  • Members of the Safeguard file-sharing group associated with the database are deleted.
  • The implicit privilege groups created at the time of database creation and user created privilege groups are dropped.
  • If users of the database are not associated with any other database, all the External Usernames of the users of the database are dropped from the system.

  • The OSS directory and the files in the directory associated with the database is deleted. However, the Guardian users associated with the External Usernames will not be used for creating users by DBS operations.

Example input and output

The following command deletes a database. 

mxdbs db-delete DB1
Hewlett Packard Enterprise NonStop(TM) SQL/MX DBS Client 3.5
(c) Copyright 2016 Hewlett Packard Enterprise Development LP.

db-delete command started.

---  mxdbs operation complete.