HETERO_COMMIT

onconfig.std value

0

range of values

1 = Enable heterogeneous commit.
0 = Disable heterogeneous commit.

takes effect

When the database server is shut down and restarted

refer to

The following material:

• Heterogeneous commit protocol, in the chapter on multiphase commit protocols in the IBM Informix Administrator's Guide
• IBM Informix Enterprise Gateway Manager User Manual

The HETERO_COMMIT configuration parameter specifies whether or not the database server is prepared to participate with IBM Informix Gateway products in heterogeneous commit transactions. Setting HETERO_COMMIT to 1 allows a single transaction to update one non-Informix database (accessed with any of the Gateway products) and one or more Informix databases.

If HETERO_COMMIT is 0, a single transaction can update databases as follows:

• One or more Informix databases and no non-Informix databases
• One non-Informix database and no Informix databases

You can read data from any number of Informix and non-Informix databases, regardless of the setting of HETERO_COMMIT.