How to change database server host for WCC and Autosys?
search cancel

How to change database server host for WCC and Autosys?

book

Article ID: 11483

calendar_today

Updated On:

Products

CA Workload Automation AE - Business Agents (AutoSys) CA Workload Automation AE - Scheduler (AutoSys) Workload Automation Agent

Issue/Introduction

What are the steps needed to change the database credentials on WCC / Autosys servers, 

 

 

Environment

Workload Automation AE 11.3.6

Workload Control Center 11.4

Embedded Entitlements Manager 12.5.1

Resolution

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. Stop WCC first. Then run below commands from $WCC_INSTALL_LOCATION 

 

./wcc_config.sh -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

 

NOTE: From WCC version 12.0, to switch from one database to another database, use the installer to create the schema and then use the wcc_config utility to switch the database.

Example, for default collector name WCC_COLLECTOR: 

./wcc_config.sh --dbplatform ORACLE --dbuser user_a --dbpassword my_password --dbhost localhost --dbport 1521 --dbname xe --collectorname WCC_COLLECTOR

 

If additional collectors are installed, then use the wcc_config utility with --collectorname to change the database pointed by the collector.

 

 

Additional Information

Autosys

 

https://techdocs.broadcom.com/us/en/ca-enterprise-software/intelligent-automation/workload-automation-ae-and-workload-control-center/11-3-6-SP8/administrating/ae-administration/configure-an-event-server/eventserver-1-and-eventserver-2.html


 

WCC

 

https://techdocs.broadcom.com/us/en/ca-enterprise-software/intelligent-automation/workload-automation-ae-and-workload-control-center/11-4-SP5/administrating/administer-ca-wcc/administer-the-configuration-batch-interface.html#concept.dita_834f26aa195a4f1412af52b2a8559253986a5b4b_SpecifyaDifferentDatabase

 

12.0:

https://techdocs.broadcom.com/us/en/ca-enterprise-software/intelligent-automation/autosys-workload-automation/12-0/administrating/ca-wcc-administration/administer-the-configuration-batch-interface.html#concept.dita_834f26aa195a4f1412af52b2a8559253986a5b4b_SpecifyaDifferentDatabase

https://techdocs.broadcom.com/us/en/ca-enterprise-software/intelligent-automation/autosys-workload-automation/12-0/administrating/ca-wcc-administration/administer-the-configuration-batch-interface.html#concept.dita_834f26aa195a4f1412af52b2a8559253986a5b4b_SpecifyaDifferentCollectorDatabase