For Interact Event Pattern report, changing the degree of parallel execution

This degree value is configurable. Increase the degree of parallel execution for the Interact Event Pattern report aggregation process to reduce the elapse time. If the degree is set to higher value, hardware resource requirements also increase proportionally

About this task

Configure the degree at which the aggregation process runs so that the Interact Event Pattern report can render faster.

Procedure

Complete the following steps to change the degree value with which the aggregation process can run in parallel:
Depending on your database, complete the following steps to configure database jobs for degree 3:
Table 1. Commands to run to change the degree of parallel execution

This two-columned table provides information about the database type in one column, and the code to be run against the ETL database in the second column.
Database type Command to run against the ETL database
Oracle To configure the degree value as 3, run the execute SP_POPULATE_PATTERN_LOCK(3) command against the Interact ETL database.
IBM® DB2® To configure the degree value as 3, run the call SP_POPULATE_PATTERN_LOCK(3) command against the Interact ETL database.
SQLServer

After you run the default acir_jobs_sqlserver.sql script, database jobs for degree value 1 and 2 are created. The patterns with degree values 1 and 2 are aggregated in the UARI_PROCESSED_PATTERNS table.

To modify the degree to 3 for the Match All Pattern, copy the sample code for degree 1 and complete the following steps:
  1. Create the @job_name to JOB_MA_3.
  2. Create the @p_parallel_degree to value 3.

Run the following command against the Interact ETL database:

Command for Match All Pattern with degree 3
DECLARE 
@jobId BINARY(16),
@status int,
@schedule_name varchar(16),
@dbname varchar(100)
set @dbname= (SELECT DB_NAME());

EXEC msdb.dbo.sp_add_job @job_name=N'JOB_MA_3',
		 @job_id = @jobId OUTPUT;

EXEC msdb.dbo.sp_add_jobstep @job_id=@jobId, @step_name=N'first',
	@command=N'EXEC [dbo].[SP_POPULATE_PATTERN_MATCHALL]@p_parallel_degree = 3',
		@database_name=@dbname;

EXEC msdb.dbo.sp_add_jobserver @job_id=@jobId, @server_name=N'(local)';
GO

You can create the degree for the Counter Pattern and the Weighted Counter Pattern, and run the commands against the ETL database.

To modify the degree to 3 for the Counter Pattern, copy the sample code for degree 1 and complete the following steps:
  1. Create the @job_name with the name as JOB_C_3.
  2. Create the @p_parallel_degree to value 3.
To modify the degree to 3 for the Weighted Counter Pattern, copy the sample code for degree 1 and complete the following steps:
  1. Create the @job_name with the name as JOB_WC_3.
  2. Create the @p_parallel_degree to value 3.