31.3 Performance Tuning Break Identification Processes

Processing time for Break Identification Processes can be reduced by modifying parallel processing parameters in the FSI_PARALLEL_PARAMETERS table.

Parallel execution-related parameters for Break Identification are seeded by the application with a process_engine_cd value of "3" in the FSI_PARALLEL_PARAMETER table.

The Break Identification process looks for the value given in the parallel query field. If the value is given as "ENABLED", the engine uses the PARALLEL_DEGREE input and sets the degree of parallelism for the execution of the queries within the Break Identification Engine.

The user or implementation team should set these values when they want to take advantage of parallel query executions. The optimal value for the PARALLEL_QUERY input depends on the environment and should be iteratively tested to arrive at the appropriate value.