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
Procedure
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:
Run the following command against the Interact ETL database: Command for Match All Pattern with degree 3
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:
To modify the degree to 3 for the Weighted Counter Pattern,
copy the sample code for degree 1 and complete the following steps:
|