Information related to these aspects of background process functionality can be found in this topic:

• Evaluating BGPs
• Parallel and Multi-Threading Properties
• Understanding config.properties Settings

Prerequisites

It is expected that anyone dealing with background process queues is familiar with the BG Processes Tab topic in the Getting Started documentation here.

Additional Information

For more information regarding Background Processes and Background Process Queues, refer to the following topics:

• BG Processes States (here)
• Default Configuration for Background Process Queues (here)
• Modifying Background Process Queue Configuration (here)
• Managing Background Processes (here)
• Scheduled Process Properties (here)
• Deleting a Scheduled Background Process (here)
• BG Processes Execution Management (here)

Note: Deleting a user who is responsible for a BGP will result in errors. For more information, refer to the Working with Users topic in the System Setup documentation here.

Evaluating BGPs

Select a BGP folder (rather than an individual BGP) to display all BGPs currently in that state. Select the columns in a flipper, right-click and click Copy (or use Ctrl+C) to copy the data. Only the data visible on the screen is copied. For further evaluation, in Excel, paste the copied data using Ctrl+V and add the header row information.

Parallel and Multi-Threading Properties

In addition to integration endpoint transactional settings (refer to the Integration Endpoint Transactional Settings topic in the Data Exchange documentation here), parallel and multi-threading properties can be used manage efficient processing. The recommended priority-based BGP execution mechanism can be configured so that waiting BGPs are prioritized for execution based on the priority of the BGP and the created time. Refer to the BG Processes Execution Management topic in the System Setup documentation here.

Configuration properties allow admin users to manage system behavior for a wide range of functionality, for example, the management of background processes and web services.

Note: Ensure changes in the settings are applied with care and properly tested before promoting to production. Parallel setting and multi-threading can easily result in optimistic locking issues, which can have a negative impact on performance, rather than the desired performance gain.

The following config.properties file settings define how a legacy background process is handled:

• Size: The number of BGPs that can run at the same time in the same queue. As an example, for data profiling setting the size = 0 on one server and setting size = 1 on another server forces all data profiling to be handled by a specific server. Recommended practice is to use one server to handle background processes and another to handle ad hoc user requests, which can give users improved system responsiveness.

  Use the BackgroundProcess.Queue.[name of queue].Size=[number of allowed concurrent processes] property where the [name of queue] designation is replaced with the name of the queue for which the setting applies and the [number of allowed concurrent processes] designation determines how many concurrent background processes can run.

  A queue size of 1 means only one process can run at a time, while a queue size of 2 means two processes can run concurrently.

  For more information, refer to the Default Configuration for Background Process Queues section referenced below, the Monitoring an IIEP via Background Process topic (here), and the Monitoring an OIEP via Background Process topic (here) in the Data Exchange documentation.

• Parallel: The following BGP types support the parallel option, which makes the same BGP use multiple CPUs on the server (multi-threading) in order to finish faster:

  • Data Profiling

  • Experian Email Validation

  • List Processing

  • Match Code Generation

  • Matching and Linking

  • Match and Merge Import

  • Match and Merge Match Tuning

  • Policy Evaluation

Use the BackgroundProcess.Queue.[name of queue].Parallel=[number of CPUs] property where the [name of queue] designation is replaced with the name of the queue for which the setting applies and the [number of CPUs] designation determines how many CPUs are used.

A queue parallel of 1 means only one CPU is used for the BGP, while a queue parallel of 2 means two CPUs are used for the BGP.

Cores are the CPUs available to handle parallel processing. The CPU setting must not exceed the number of available cores. To view the number of cores on the application server, refer to the 'No of cores' parameter in the Activity tab Details section of the Admin Portal, as defined in the Activity topic in the Administration Portal documentation here.

Note: The parallel queue property's underlying implementation varies significantly based on the background process type. When starting 'X' number of jobs, you use at least 'X' times as many resources, which come from other processes and could impact performance. As such, thorough performance testing with production-level hardware and peak traffic conditions is highly recommended.

• ProcessType: This property is used to rename the default queue for a specific type of background process which allows the administrator to control the processes that run on each server.

Use the BackgroundProcess.ProcessType.[process type ID].Queue=[name of queue] property where the [process type ID] and the [name of queue] designations are replaced with the actual type ID and the actual name of the queue for which the setting applies.

For steps to change your configuration, refer to the Modifying Background Process Queue Configuration topic here.

Single Application Server and Single Queue Example

This example includes inbound integration endpoints (IIEPs) but can also be applied to any feature that uses background processes.

Consider the following config.properties settings for a single server called appserver1:

BackgroundProcess.Queue.DataProfilerParallel.Parallel=4
BackgroundProcess.Queue.DataProfilerParallel.Size=4
BackgroundProcess.Queue.In.Parallel=8
BackgroundProcess.Queue.In.Size=1

Combined with these workbench parameter settings:

• The match and merge IIEP has 'Queue for endpoint processes=IN'
• The bulk update IIEP has 'Queue for endpoint processes=IN'

Result

A configuration with these settings results in the following activity on the single server:

• A 'Match and Merge IIEP' background process will not run simultaneously with a 'Bulk Update' background process. Both use the IN queue, which has size 1, limiting it to only one (1) background process at a time.
• A 'Match and Merge IIEP' background process will use up to 8 cores due to the parallel setting of 8 for the IN queue.

Two Application Servers Example

This example includes inbound integration endpoints (IIEPs) but can also be applied to any feature that uses background processes.

In addition to appserver1 described above, add a second application server (called appserver2) with the following config.properties settings:

BackgroundProcess.Queue.DataProfilerParallel.Size=0
BackgroundProcess.Queue.In.Size=0

Result

A configuration with these settings results in the following activity on the two servers:

• appserver1 runs up to four (4) data profiling processes in parallel. Data profiling process number five (5) remains in queue until one of the first four is complete.
• appserver2 never runs 'Match and Merge IIEP' background processes nor 'Bulk Update IIEP' background processes because this server has a size of 0 for IN queue, and both of these background processes use the IN queue.
• Since all BGPs run on appserver1, high BGP load does not adversely impact users because appserver2 is reserved for actions in the user interface.

Single Application Server and Two Queues Example

This example includes inbound integration endpoints (IIEPs) but can also be applied to any feature that uses background processes.

Consider the following config.properties settings for a single server called appserver3:

BackgroundProcess.Queue.InIIEP1.Size=10
BackgroundProcess.Queue.InIIEP2.Size=20

Combined with these workbench parameter settings:

• The match and merge IIEP has 'Queue for endpoint processes=InIIEP1' with 'Transactional settings = None'
• The bulk update IIEP has 'Queue for endpoint processes=InIIEP2' with 'Transactional settings = None'

Result

A configuration with these settings results in the following activity on the server:

• appserver3 runs up to 10 match and merge processes simultaneously. Match and merge process number 11 remains in queue until one of the first 10 is complete. These are the only processes that run on the InIIEP1 queue.
• appserver3 runs up to 20 bulk update background processes simultaneously. Bulk Update process number 21 remains in queue until one of the first 20 is complete. These are the only processes that run on the InIIEP2 queue.

Understanding config.properties Settings

Configuration properties provide system administrators with options for controlling system behavior, logging, processing, storage of information on the application server(s), and many other things. Configuration properties are specified in the config.properties or sharedconfig.properties files on the application server(s). There is one config.properties file per application server so a clustered environment may have multiple config.properties files, with each containing settings local to a particular application server.

Conversely, the sharedconfig.properties file is global so there will be only one file per setup, with all settings being applicable to all application servers. Most properties are set in the sharedconfig.properties file, with the config.properties file being used only for those properties that expressly require it.

The config.properties file is read first, line-by-line, until the first 'include' statement—typically the sharedconfig.properties file as shown below.

When an 'include' statement is found, the included file is read line-by-line (and any 'include' statements in those files are also read) before reading is continued in the config.properties file. A property can exist more than once in the properties files and the last value read is the only active value. This allows properties in the config.properties that come after an 'include' statement to overwrite the same properties in the sharedconfig.properties file.

For more information on config.properties settings, refer to the Configuration topic in the Administration Portal documentation here.