IIS-CONN-DB2-00329E Schema reconciliation failed. An extra column was found in the design schema.
Explanation
Schema reconciliation failed because an extra column was found in the design schema.An error occurred during the schema reconciliation because an extra column was found in the design schema. Typically this error occurs when a mismatch is detected between the schema in the job design (design schema) and the schema of the table in the Db2 (external schema). This results in an extra column in the design schema.
User response
Do one of the following actions:- Delete any extra columns from the job design.
- Set the Usage > Session > Schema reconciliation > Drop unmatched fields property to Yes.