Connecting the master domain manager to a new database
About this task
This section applies to HCL Workload Automation master domain managers and their backups. It documents how to connect the master domain manager and backup master domain manager to a new database.
Note: This cloning procedure does not clone the following information from the source
environment:
- The preproduction plan
- The history of job runs and job statistics
- The audit records
- The state of running event rule instances. This means that any complex event rules, where part of the rule has been satisfied prior to cloning of the environment, are generated as new rules after the cloning procedure. Even if the subsequent conditions of the event rule are satisfied, the record that the first part of the rule was satisfied is no longer available, so the rule will never be completely satisfied.
Follow this procedure to export data from your previous database, import it to a new one, and connect the master domain manager and backup master domain manager to the new database.
Procedure
- Install the new database.
- Run the configureDb command to create the new database on the new target RDBMS. For more information, see Database configuration - configureDB script.
-
On the master domain manager,
extract all scheduling object definitions and global options from the previous
RDBMS running the dataexport command. For more information,
see dataexport.
where:dataexport source_dir export_dir
- source_dir
- Is the TWS_HOME directory of HCL Workload Automation.
- export_dir
- Is the directory where the export files are created.
dataexport.cmd F:\IWS10105\twsDBuser F:\IWS10105\export
-
Verify that the following files were created in
export_dir
:- acls.def
- calendars.def
- erules.def
- folders.def
- globalOpts.def
- jobs.def
Note: The record length supported by DB2® is 4095 bytes, but it decreases to 4000 bytes with Oracle. When you migrate your job definitions to Oracle, any job with task string (scripts or commands) exceeding 4000 bytes in length are not migrated. In this case, the data import utility replaces the job definition with a dummy job definition and sets the job priority to 0, guaranteeing that successors are not run.
- parms.def
- prompts.def
- rcgroups.def
- resources.def
- scheds.def
- sdoms.def
- srols.def
- topology.def
- users.def (includes encrypted user passwords)
- vartables.def
- Stop WebSphere Application Server Liberty Base on the master domain manager and backup master domain manager.
-
Reconfigure the master domain manager and backup master domain manager by performing
the following changes:
- Edit the WebSphere Application Server Liberty Base datasource.xml file, so that it points to the new RDBMS. For more information, see Changing the properties for the database.
- In the TWA_DATA_DIR/usr/servers/engineServer/resources/properties/TWSConfig.properties
file, uncomment the
com.ibm.tws.dao.rdbms.rdbmsName
line and specify the name of your RDBMS. For more information, see Changing the properties for the database. - In the TWA_DATA_DIR/broker/config/DAOCommon.properties file,
change the
com.ibm.tdwb.dao.rdbms.rdbmsName
line to specify the name of your RDBMS. - In the TWA_DATA_DIR/broker/config/CLIConfig.properties file,
change the following strings:
- com.ibm.tdwb.dao.rdbms.rdbmsName
- to specify the name of your RDBMS.
- com.ibm.tdwb.dao.rdbms.jdbcPath
- to specify the path to your JDBC connection string.
- com.ibm.tdwb.dao.rdbms.jdbcDriver
- to specify the name of the class implementing your JDBC driver.
-
Run addserverdata to add dynamic domain manager data in the
database. This command is not documented because it is an internal command. For
the purpose of this procedure, use the following syntax:
where:./addserverdata.sh -dbUsr username -dbPwd password [-importFile importFile] {[-MDM true]}
- dbUsr
- Is the database user. This parameter is required.
- dbPwd
- Is the database user password. This parameter is required.
- -importFile
- Is the file name from which the server data is to be imported into the database. This parameter is required if you use a file different from the default server.properties file, located in the same path as the addserverdata command. If you use a file other than server.properties, specify the name and path of the file.
- MDM
- Specifies whether the workstation where you run the command is the master domain manager. This parameter is required on the master domain manager and is optional on the dynamic domain manager.
- Restart WebSphere Application Server Liberty Base on the master domain manager.
- Wait for all dynamic agents to register with the master domain manager.
- Run the dataimport command to import data from your previous RBDMS. For more information, see dataimport.
-
Run the following command to align the plan with the information inserted in
the database:
Jnextplan -for 0000 -noremove
-
Run the following command to extend the plan by 24 hours:
For more information about Jnextplan, see JnextPlan.JnextPlan -to plan_end_time tz your_timezone -noremove
The master domain manager and backup master domain manager are now configured to connect to the new database and your environment is up and running.