Reconfiguring the database server connection data

This procedure describes how to reconfigure the database server connection data in the configuration files and the database, when the database server connection parameters are changed.

Before you begin

• Shut down Control-M/Server and Control-M/Server Configuration Agent

To reconfigure the database server connection data:

1. Navigate to the following directory:

   <Control-M/Server_home>\ctm_server\scripts\

2. Type the following command:

   restore_host_config -reconf_db [-host <new db host name>] [-port <new db port number>] [-dbname <new db schema name>] [-service <new db service name>] [-owner <new db owner name>] [[-password <dbo password>] [-pg_existing_server <y/n>]

   NOTE:

   • The-pg_existing_server must be used for PostgreSQL databases.
   • The y value defines that the database server cannot be administered by the installation (Existing mode).
   • The n value defines that the database server can be administered by the installation (Dedicated mode).
3. Start the Control-M/Server Configuration Agent and Control-M/Server

   NOTE: (UNIX only) The reconfigure steps make changes to the environment and for the changes to take effect, you must execute the start commands on a new shell.