DLDB – Delete Dimensions Base Database

Use this command to delete a base database.

IMPORTANT! To be able to use this command, you must issue it while connected to another base database; that is, it is not possible to delete a base database while any Dimensions users are connected to it.

CAUTION! You (dmsys) must first check that the contents of the base database are no longer needed as the deletion operation cannot be to a backup copy of the database files or a full export of the RDBMS database taken before deletion). The DLDB operation must only be run when no other users are accessing the base database to be deleted.

All information contained in the base database will be deleted and all the Dimensions users who were registered to use it will also be dropped. Note, however, that the product item libraries (which are operating-system directories) associated with the base database are not deleted).

The syntax is as follows:

dldb <basedb>

[/confirm=yes]

[/droplogin]

where:

Parameter | Description
<basedb> | Is the name of the base database to be deleted.
/confirm=yes | By default DLDB will prompt you to confirm that you want to proceed with the deletion of <basedb>. Specifying /confirm=yes will disable this prompt and DLDB will begin immediately.
/droplogin | (SQL Server only). If there is an SQL Server login account with the same name as the Dimensions database that is being deleted, the login ID is also deleted.

NOTES

- DLDB deletes the base database and any database objects owned by that base database.

- DLDB can take several minutes to complete.

- If DLDB fails because users are still connected to the schema, you can—in an emergency—disconnect such users by shutting down the Dimensions CM Listener Service and then resubmit the command. To shut down the Dimensions CM Listener Service:

1. Confirm that the "-dsn <base_db>@dsn" entry in the listener.dat file is pointing to the base database that you want to delete. The listener.dat file is located in the dfs sub-directory of the Dimensions CM root directory.

2. Windows: To shut down the Dimensions CM Listener service:

- Start | Control Panel | Administrative Tools Services

- (Right-click) Dimensions CM Listener | Stop

UNIX: To shut down the Dimensions CM Listener service:

- Log in as user root.

- Change directory to $DM_ROOT/prog

- Run the command ./dmshutdown