Defining Alternative Table Locations - trillium_discovery - trillium_quality - 17.1

Depending on your needs, you may want to install the tables to a location other than the specified default directories. If you plan to install some or all of the tables in a non-default location, you must define those alternative locations before you install the tables. (See Default Installation Locations for more information.)

Use this procedure to define an alternative location for 64-bit/UTF-8, APAC, Census, and Global (GA) tables so that Trillium repositories are able to access the tables.

To change the default table location

1. Shut down Trillium, including all Trillium clients.

2. Stop the TSS Scheduler service.

3. Create the alternative table installation directory.

   Note: On Linux, you must create a symbolic link to the alternative directory, which can be on any mounted drive.

4. Start the Trillium command line utility.

   • On Windows, select Trillium Software > Repository Administration Command Prompt.

   • On Linux, type ./mtb_admin.

5. When prompted, supply your user name, password, and repository name.

   Note: Use the _control repository name to apply the alternative location to all repositories.

6. Ensure that changes have not already been made to the table installation locations by typing the following commands, individually.

   define postal_directory
   define apac_postal_directory
   define census_directory
   define ga_directory

   The commands should each return a failure message of the form “No setting with name ‘nnn_directory’ found in table ‘default_settings’.” For example, “No setting with name ‘census_directory’ found in table ‘default settings’.”

   If a value is returned, you need to remove the current setting before defining a new one. See Removing Table Directory Definition for more information.

7. At the mtb_admin prompt, type:

   expert

8. Issue one or more of the following commands, pressing Enter after each one:

   Note: On Windows systems, the path must be specified as a UNC path, not a mapped drive.

   • For 64-bit/UTF-8 tables:

   define postal_directory [file join {d:\newpostal}]

   • For Asian/APAC tables:

      define apac_postal_directory [file join {d:\newpostal}]

   • For Census tables:

      define census_directory [file join {d:\newpostal}]

   • For Global (GA) tables:

      define ga_directory [file join {d:\newpostal\datastore}]

   where d:\newpostal is the path of the alternative directory and datastore is the required name of the sub-directory.

9. Type exit to close the command prompt window.

10. Move any installed xxCITY.ext files (where ext is either len or ben) from the default installation directory to the new, alternative directory.

    Note: These files were copied to the default directories when Trillium Quality project templates were installed. They must be in the same location as the GAV tables.

11. Remove the default directories (or leave them empty).

12. For Global (GA) Tables, there is an additional step:

    1. With a text editor, open the Global GAV table gaserver.ini file, which is located in the conf directory: .../tsq/Software/conf directory.

    2. Set the CountryDataDirectory entry to point to the alternative location of the Global (GA) table datastore\rdata directory.

    3. Set the KnowledgeBaseDirectory entry to point to the location of the Global (GA) table datastore\kbase directory.

    4. Locate the LicenseDirectory entry and point it to the Global (GA) table license directory.

       The given below shows an example of a modified gaserver.ini.

       

    5. Save and close the file.

13. Restart Trillium software and the Scheduler.

    Note: On Windows operating systems, if you installed the Global (GA) tables on a network drive, you must change the Scheduler and inetd service to run as a Windows domain account instead of a system account.

14. Install the GAV tables. See Installing on Windows and Linux.