Control import table dictionary entries

Control whether an import can automatically change the dictionary entries for staging tables.

Set the system property to false to prevent an import from changing a staging table's dictionary entry.
Property Description
Specifies whether an import set can add new columns to the staging table (true) or not (false). Instances that contain large numbers of import sets can sometimes become unresponsive when an import adds a column because the instance must alter every row in the staging table. In some cases, the database alter table action causes an outage. Setting this property to false prevents an import set from adding columns to the staging table and produces a log message. As a workaround, administrators can manually add a column to the staging table by creating a new dictionary entry and then reimporting the import set.
  • Type: true | false
  • Default value: true
  • Location: Add to the System Properties [sys_properties] table