1. Analytical Application Infrastructure User Guide
  2. Data Management Framework
  3. Configure Dynamic Degree of Parallelism (DOP) in DQ Framework

Configure Dynamic Degree of Parallelism (DOP) in DQ Framework

This feature allows you to achieve Oracle parallelism or any setting’s change before executing DQ component. You can add scripts in the preScriptDQDC.conf file located at $FIC_DB_HOME/conf/ folder. These scripts will be executed before executing DQ task. These are generic scripts and are common for all the DCDQ tasks.

Note:

This is applicable only on Oracle based Information domain.
You can define any optimization statement inside the preScriptDQDC.conf file as stated below:
  1. Statement starting with #, will be ignored as it is considered as comments.
  2. Statement with Key Words like CREATE, TRUNCATE, DROP, SELECT, and UPDATE will be ignored.
  3. Different statements should be separated either by; or new line.
  4. Accepted/Filtered statements will be executed and can be seen in the log with execution status as SUCCESS/FAILURE.
  5. If unable to execute optimization statements or if file is not present in the respective path, log will show the message, but DCDQ will not fail. It will continue with the execution.