Deleting a database server

Use this procedure to remove a database server completely, including its configuration file, the server entry in the sqlhosts file, and any of the server chunk files that are not raw devices. This operation removes the parameter file, the record of the specified server in the sqlhosts registry entry, and all chunk files.

When deleting a database server, the Informix® data portion of all Rational® Synergy databases under this database server are destroyed. However, the file system portion is not destroyed. Therefore, back up all the database server databases (for example, using ccmdb backup). Then, in most cases, delete the databases (for example, using ccmdb delete) one by one before deleting the database server. Deleting the databases before deleting the database server removes all parts (file system and metadata) of each database.

Windows

Procedure

  1. Ensure that you are an Informix-Admin group member and are working as local administrator.
  2. On the machine where the Informix server resides, run the ccmsrv delete command to delete the database server.

    > ccmsrv delete

UNIX

Before you begin

If you did not set up CCM_HOME and PATH for user informix during installation, set these environment variables now.

Procedure

  1. Log on the database server as user root.
  2. Set user to informix.
    root# su - informix
    Password: *****
  3. Remove all databases from the server.

    You must remove all databases from the server before deleting it.

  4. Delete the database server.

    For example, delete the hydra1 database server as follows:

    $ ccmsrv delete -s hydra1

  5. Exit from user informix.

Feedback