CC_DB2_INTERMEDIATE_STATISTICS_MODE

Set this variable to control intermediate statistics generation on temporary or target tables.

To improve DB2 write optimization, connector generates statistics on temporary work table (TWT) and target table before the main SQL statement writing from TWT to target is executed.

Environment variable CC_DB2_INTERMEDIATE_STATISTICS_MODE can be used to select which table to generate statistics on. The supported values are:
  • TWT - generate statistics on TWT only (default)
  • TARGET - generate statistics on target table only
  • TWT_TARGET - generate statistics on both tables
  • NONE - do not generate statistics at all

If no variable is set, the statistics are generated on temporary work table only. It matches the configuration when the variable CC_DB2_INTERMEDIATE_STATISTICS_MODE is set to TWT.