Changing settings repository

Changing the settings repository.

Before you begin

To perform this task you need to have the TWSWEBUIAdministrator role.
You need to have access to an installed DB2® where a database has already been created. If you need information about how to create a DB2 database, see IBM DB2 Database for Linux, UNIX, and Windows Information Center.
You must have Administrator rights on that database.

About this task

User settings such as user preferences, saved tasks, and engine connections are stored in the settings repository, which by default is a local file. However, you can decide to have your settings repository on a database for all Dynamic Workload Console operations that involve user settings.

This can be useful, for example, for scalability purposes or to have multiple Dynamic Workload Console instances sharing the same user settings.

To use a database for your settings repository, you must configure the database settings, as described in the following procedure:

Procedure

Run the wastool:
1. Specify the connection details of the DB2 database in the TDWCDatasource.properties file, located in the following path:install_dir\wastools, where install_dir is the HCL Workload Automation installation path.
2. To create the data source, submit the installTDWCDatasource command from the wastools directory (install_dir\wastools), specifying the TDWCDatasource.properties file you modified in the previous step:
  On Windows:
```
installTDWCDatasource.bat TDWCDatasource.properties
```
  On UNIX and Linux:
```
./installTDWCDatasource.sh TDWCDatasource.properties
```
Restart the Dynamic Workload Console.
Export your settings:
1. From the navigation toolbar, click System Configuration > Manage Settings.
2. Optionally, in the Manage Settings panel, click Export Settings and save the XML file in a directory of your choice. In this way you save your user settings in a local file to load them on the database, when it becomes your settings repository.
Switch repository to DB2.
1. In the same panel, click Configure settings repository > Use database as settings repository to specify that settings must be saved in the database instead of a local file.
2. In the Database connection properties section, specify the credentials required to connect to the database.
  Note: For all the details about options and fields displayed in the panels, see the online help by clicking the question mark located at the top-right corner of each panel.
3. Optionally, you can test the connection.
4. Save the new configuration.
Import your settings or initialize the database:
1. Optionally, click Import settings to import your user settings from the XML file to the database repository. During the import operation, keep the default choice, which overwrites the existing settings with the new settings. Performing this step, the database is automatically initialized.
2. If you have not performed previous step, click Configure settings repository >Initialize database .

Results

As a result, all your existing user settings relating to current Dynamic Workload Console are saved in the database, and all the operations involving user settings are run using the settings in this repository.