Creating an Alternate Repository - trillium_discovery - trillium_quality - Latest

Trillium DQ Repository Administrator Guide

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Version
Latest
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium DQ Repository Administrator Guide
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T15:31:00.219841
The data files created by a Quality project can be very large. It is recommended that you create an alternative area for just those files. Everything except the data files remains in the existing repository server directory.
Note: You must create the alternative repository before you create any projects for that repository in the Control Center.

To define an alternative repository directory

  1. Shut down Trillium DQ, including all Control Centers.

  2. If the new repository does not yet exist, create it now using the Repository Manager.

  3. Stop the Trillium DQ Scheduler service.

  4. 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.

  5. 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.
  6. 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.

  7. Configure the alternative repository directory.

    1. At the mtb_admin prompt, type:

      expert   

    2. 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.

  8. Press Enter.

  9. Type exit to close the command prompt window.

  10. Restart the Scheduler and the Repository Manager.

  11. Create entities and projects in the new repository and verify that data is being stored in the alternate location.