Failed attempt to commit distributed transaction using heterogeneous commit

The database server can fail to commit a distributed transaction while it is using the heterogeneous protocol for one or more of the following reasons:
  • Communication error
  • Site failure
  • Gateway failure
  • Other unknown error
When such a failure occurs, the coordinator returns the following message:
-441    Possible inconsistent data at the target DBMS name due to 
an aborted commit.

After the database server sends this message, it rolls back all update sites that are participating in the transaction, with the possible exception of the work done at the site of the gateway participant. The gateway participant might have committed its updates if the failure occurred after the gateway participant processed the commit message. If the gateway participant committed the updates, you must manually roll back these updates.


Copyright© 2019 HCL Technologies Limited