After you disable BAM or the Data Mart, you can drop the
respective database. You can use Process Administrator to either drop the
database directly, or to generate an SQL statement for execution by a database
administrator.
Bear in mind that dropping the database only executes a
DROP DATABASE SQL statement on the BAM or Data Mart
database. It does not remove the external resource.
- Click on
Process Monitoring.
The
Process Monitoring page appears.
- Select the
BAM or
Data Mart tab.
- In the
Advanced Properties section, click
Manage Database.
The
Manage Database page appears.
- Select the
Drop the database.
- If you have administrator access to the database, enter the
database administrator user and password, and click
OK.
If Process Administrator reports that the database has been
dropped successfully, you are done. The instructions below are for users
without administrator access to the database.
- If you do not have administrator access, click
Show SQL Statements.
Your web browser will ask you if you want to save the
sql.txt file.
- Save the file to any location, and send it to the database
administrator, who will run the SQL statement in the file, creating the
database.
Note that this file will contain a single statement in the form:
DROP DATABASE database_name
You may simply be able to ask your DBA to drop the database by
name. The advantage of sending an SQL file is to prevent dropping a similarly
named database.