Application attempts to update multiple gateway participants

If your client application attempts to update data at more than one gateway participant when HETERO_COMMIT is set to 1, the coordinator returns the following error message:
-440 Cannot update more than one non-Informix DBMS within a transaction.

If you receive this error message, rewrite the offending application so that it updates at most one gateway participant in a single distributed transaction.

Parent topic: Interpretation of heterogeneous commit error messages
Copyright© 2020 HCL Technologies Limited