Dropping IBM Databases

With the IBM^® Database Add-Ins for Visual Studio, you can drop an IBM database. Dropping a database deletes all its objects, containers, and associated files. The dropped database is removed (uncataloged) from the database directories.

Requirements:

To drop a database, you must have SYSADM or SYSCTRL authority.
Before you drop a database, you must delete all of the connections to the database.

To drop an IBM database:

In the Server Explorer right-click the Data Connections node, and then select Drop IBM Database on the shortcut menu.
The Drop Database window opens.
Type the name of the server that contains the database that you want to drop.
Type your user name and password.
Type the name of the database that you want to drop.
Click OK.
The IBM Output Message Pane displays the following messages:

Dropping database - <database_name>. Database <database_name> dropped successfully.

If the following messages are displayed in the IBM Output Message Pane, not enough time has elapsed since you closed the last remaining connection to the database.

Database <database_name> not dropped. Error occurred: -1035 [57019] SQL1035N The database is currently in use. SQLSTATE=57019 : -2147467259: IBM.Data.<data_server>

Wait a few minutes, and then try dropping the database again.

See Also