この Default Option は、実行された各SQL クエリに対してデータ行程計画を生成して格納するかどうかを制御します。以下の値をとります:

Value

Description

TRUE

  • Data lineage plan is automatically generated at runtime for each executed SQL query and stored to the configuration database;
  • XML representation of the data lineage plan for SQL query can be retrieved using the SYSADMIN.getDataLineage procedure or EXPLAIN command;
  • SYSLOG.getQueryLogDataLineage procedure returns a stored lineage plan for a specific entry in the SYSLOG.QueryLogs table

FALSE

  • Data lineage plan is not autogenerated at runtime and thus is not stored;
  • XML representation of the data lineage plan for a specific query can only be obtained via the SYSADMIN.getDataLineage procedure. The EXPLAIN command returns NULL as a value for the DATA_LINEAGE_XML column;
  • SYSLOG.getQueryLogDataLineage returns NULL for the queries executed after setting this value for the ENABLE_DATA_LINEAGE option as there are no stored plans for them;
  • Default value

Example

CALL SYSADMIN.setDefaultOptionValue('ENABLE_DATA_LINEAGE', TRUE);