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, such as moving the database server to a replicated server running on a different computer. This option modifies the database connection data in the configuration files (such as DBU_params.dat file), enabling Control-M/EM processes to connect to the new server. The script also updates the data stored in the Control-M/EM database if you executed a data import to the new database storing the old server connection data. The script supports all database server vendor types (PostgreSQL, Oracle, and MSSQL) that can connect to Control-M/EM.
To reconfigure the database server connection data:
From a command line type one of the following:
UNIX: em restore_host_config -reconf_db [-silent] [-host <new db host name>] [-port <new db port number>] [-service <new db service name>] [-dbname <new db schemaname>] [-pg_existing_server <y/n>] [-owner <new db owner name>] [[-password <dbo password>] or [-password_file [<file_path>]]]
Windows: restore_host_config -reconf_db [-silent] [-host <new db host name>] [-port <new db port number>] [-service <new db service name>] [-dbname <new db schema name>] [-pg_existing_server <y/n>] [-owner <new db owner name>] [[-password <dbo password>] or [-password_file [<file_path>]]]
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).
If the -silent flag is not specified and optional parameters are not defined in the command line, the script asks for the relevant input interactively.
The script must run on all High Availability and Distributed installations connected to the same database.