How to read the UARI_DELTA_REFRESH_LOG table for the Interact Event Pattern report

UARI_DELTA_REFRESH_LOG table contains the logging information for all the procedures.

When the aggregation is run with degree value 2, you see the following log messages in the table.

How to verify the status of the aggregation process

MESSAGE_LINE:

<patterntype> patterns delta refresh completed for parallel degree <degree value>
Aggregation of the patterns with degree value is started.

MESSAGE_LINE:

<patterntype> patterns delta refresh completed for parallel degree <degree value>
Aggregation of the patterns with degree value is completed.

Where patterntype is the Type of Pattern, Match All, Counter, or Weighted Counter, the degree value is the value with which patterns are processed in parallel.

Example:

MatchAll patterns delta refresh started for parallel degree 1
MatchAll patterns delta refresh completed for parallel degree 1
MatchAll patterns delta refresh started for parallel degree 2
MatchAll patterns delta refresh completed for parallel degree 2

How to verify whether the UARI_PATTERNSTATE_INFO table is refreshed

MESSAGE_LINE:

     Pattern State information refresh procedure started
       --The procedure to refresh the data in UARI_PATTERNSTATE_INFO is running.

MESSAGE_LINE:

     Pattern State information refresh procedure completed
       --The procedure to refresh the data in UARI_PATTERNSTATE_INFO is completed.

How to verify whether the lock flags are reset by the procedure SP_AGGR_RUN_STATUS

MESSAGE_LINE:

patterns lock has been reset for parallel degree <degree value>

The OBJECT column of the UARI_DELTA_REFRESH_LOG table contains the procedure name for which the lock is reset.

Where, the degree value is the value with which patterns are processed in parallel.

Example:

patterns lock has been reset for parallel degree 1

How to verify rebinding of the packages completed (for DB2 only)

MESSAGE_LINE:

Rebind of packages started
--Rebinding of the packages started

MESSAGE_LINE:

Rebinding of packages completed successfully on <datetime>
--Rebinding of the packages completed successfully on the given date.

How to verify whether the statistics are updated on the ETL tables

MESSAGE_LINE:

Table statistics update started

--Update statistics on the ETL tables is in process

MESSAGE_LINE:

Statistics on Tables UACI_ETLPATTERNSTATE UACI_ETLPATTERNSTATEITEM 
UACI_ETLPATTERNEVENTINFO and indexes have been updated successfully 
on <Datetime>

--Statistics are updated on the mentioned ETL tables on the given date.

How to verify the degree of parallel execution

MESSAGE_LINE:

Pattern aggregation processing Parallel degree is set to <degree value>

--Parallel degree with which report aggregation will run is set to 2.

Example:

Pattern aggregation processing Parallel degree is set to 2.