HETERO_COMMIT configuration parameter

Use the HETERO_COMMIT configuration parameter to control whether the database server participates in heterogeneous commit transactions.

onconfig.std value
HETERO_COMMIT 0
values
1 = Enable heterogeneous commit.

0 = Disable heterogeneous commit.

takes effect
After you edit your onconfig file and restart the database server.

Usage

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

If HETERO_COMMIT is 0, a single transaction can update databases as follows:
  • One or more HCL OneDB databases and no non-HCL OneDB databases
  • One non-HCL OneDB database and no HCL OneDB databases

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