Cleaning up existing database

This procedure describes how to clean up an existing Sybase database.

To clean up an existing database:

1. Log on to the Sybase database server as the sa user.
2. Use the sp_helpdb command to determine if the database exists.
3. If the database exists, use the following command to drop (remove) the database and database owner (DBO):

   drop database <databaseName>

   sp_droplogin <dboName>

4. Use the following command to check which devices were dropped from the server:

   sp_helpdevice

   go

5. If data or log devices associated with the Control-M database are still listed, drop them using the following command:

   sp_dropdevice <deviceName>

   go

6. Delete the files, if any, that are associated with the dropped elements.

   Creating a Sybase database on an existing database server

7. Prepare the information you will need for running the build_db utility. Parameters for this utility are listed in the table below.
8. From the command line of the account on which the existing Sybase database server resides, enter the command: build_db/build_db.sh
9. When asked to select the "Control-M component for which you want to install the Sybase component", select Control-M/Enterprise Manager.
10. Select the Existing build database mode to create an empty Control-M/EM database on an existing Sybase database server. The name and location of the existing Sybase database server and the system administrator’s name and password must be specified.
11. Follow the instructions on the screen, filling in the prompts as necessary. Upon completion, the following message is displayed:

    Installation of Control-M Sybase database component completed successfully.

    For more detail about Control-M Sybase database server parameters, see: Sybase database server parameters.