Configuring Business Group Limit Setting - 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

In the Trillium Control Center, scheduled jobs can run consecutively, or concurrently, depending on whether you choose to run the jobs now or at later times. How jobs run, also depend on the maximumWeight parameter set in the server configuration (config.txt) file.

  • If maximumWeight is 1, scheduled jobs run consecutively in sequential order.

  • If maximumWeight is greater than 1, scheduled jobs run concurrently up to the set value. For example, if maximumWeight = 10, up to ten scheduled jobs can run concurrently.

When you analyze business rules using the Group By option and the maximumWeight parameter is greater than 1, business rule analysis runs concurrently on multiple rules at a time. This can lead to performance issues including a slow down (or hanging) of your system.

You can use the optional business_group_limit setting to restrict the concurrent analysis of business rules using the Group By option.

Note: Other types of scheduled jobs, for example, creating entities and running Trillium Quality processes, are not affected and run in parallel regardless of the business_group_limit value.

Guidelines:

By default, the business_group_limit is disabled, that is set to 0, and rule analysis jobs can run without any constraint. When business_group_limit is set to greater than 1, it allows rule analysis jobs to run concurrently. If the number of business rules using the Group By option is greater than the value set in business_group_limit, the rule analysis jobs run in consecutive order. This is desirable to avoid performance issues.

Example:

Suppose you have five business rules using the Group By option. You modify the server configuration file such that, maximunWeight = 2, and business_group_limit = 4.

Now when you schedule rule analysis of two business rules, the jobs run in sequential order. As a result, the second rule analysis job is able to obtain the resources it needs and avoid performance issues.

To set business_group_limit

  1. On the server system, stop the TSS scheduler service.

  2. Open the config.txt file for editing:

    • On Windows, file is located in : C:\Program Files\Trillium Software\MBSW\17\etc 

    • On UNIX, file is located in: UNIX: …/metabase/etc 

  3. Go to the key public section.

  4. Modify the value for the business_group_limit. For example,

    key public {   
        value max_string_size 32767   
        value utf8_length 3   
        value str_base 1   
        value business_group_limit 5  
        }
  5. Go to the key scheduler section.

  6. Modify the value of the maximumWeight parameter. For example,

    key scheduler {   
        value port [get {public ports scheduler}]   
        value timeout [expr {5*60*1000}]   
        value maximumWeight 2
    Note: Ensure the value is greater than 1, otherwise the business_group_limit will be treated as if set to 0 (or turned off).
  7. Save and close the file.

  8. Start the TSS scheduler service.