To define an alternative repository directory
Shut down Trillium DQ, including all Control Centers.
If the new repository does not yet exist, create it now using the Repository Manager.
Stop the Trillium DQ Scheduler service.
Configure as shown below:
On Windows, from the Start menu, click Trillium Software > TSS 17 > Repository Administration Command Prompt to start the Repository Application Command Prompt.
On UNIX, enter
./mtb_admin
.
When prompted, log on as the repository administrator to the repository where you want to define the alternative repository.
Note: The chosen repository must not contain any entities or projects. Also, if you choose the _control repository, it will set the alt_metabase for all repositories.Verify that an alternative repository location has not already been defined by entering the following command:
define alt_metabase
The command should return the following failure message: “No setting with name ‘alt_metabase’ found in table ‘default_settings’.”
If a value is returned, remove the current setting using instructions in Removing Alternative Repository Definition.
Configure the alternative repository directory.
At the
mtb_admin
prompt, type:expert
Define the alternative location by entering the following command
define alt_metabase [file nativename {d:\newmetabasedir
where d:\newmetabasedir is the path of the alternative location.}]
Press Enter.
Type
exit
to close the command prompt window.Restart the Scheduler and the Repository Manager.
Create entities and projects in the new repository and verify that data is being stored in the alternate location.