What are the steps needed to change the database credentials on WCC / Autosys servers,
Workload Automation AE 11.3.6
Workload Control Center 11.4
Embedded Entitlements Manager 12.5.1
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.
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
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