How to change database server host for WCC and Autosys

Document ID : KB000011483
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

Question:  

Need Database Server changed on EEM WCC WAAE Servers.

 

 

 

 

 

Environment:
Workload Automation AE 11.3.6Workload Control Center 11.4Embedded Entitlements Manager 12.5.1
Answer:

The EEM uses internal database (CA Directory) and cannot be changed.

 

The WAAE (autosys) can be pointed to single database when there is a downtime required for any database  in dual event server.

In order to change the database server name in AutoSys, you need to modify the config.$AUTOSERV in the $AUTOUSER folder

EventServer_1=SYBASE_SVR:SYBASE_DB,DBPORT,DBHOST | ORACLE_SVR,DBPORT,DBHOST | MSSQL_SVR:MSSQL_DB,DBPORT,DBHOST

 

Example for an Oracle database

EventServer_1=orcl,1521,MACHPROD

 

The WCC database or Reporting database can be changed using the Configuration Batch Interface.

 

wcc_config -u user_name -p password --dbplatform db_platform --dbuser db_user --dbpassword db_password --dbhost db_host --dbport db_port --dbname db_name [--dbapp application] [--dbtnsname tns_name] [- - dbtnspath tns_path]

 

 Example for an different WCC database

./wcc_config.sh -u ejmcommander -p ejmcommander --dbplatform ORACLE --dbtnsname orcl --dbtnspath /opt/CA/WorkloadCC/tnsnames.ora --dbuser WCCDBO --dbpassword xxxxxxx --dbapp WCC

 Example for an different Reporting database

./wcc_config.sh -u ejmcommander -p ejmcommander --dbplatform ORACLE --dbtnsname orcl --dbtnspath /opt/CA/WorkloadCC/tnsnames.ora --dbuser WCCDBO --dbpassword xxxxxxx  --dbapp REPORTING

 

 

Additional Information: