HS_TRANSACTION_MODEL

HS_FDS_TRANSACTION_MODEL initialization parameter for Oracle Database Gateway for DRDA.

Property	Description
Default Value	COMMIT_CONFIRM
Range of Values	COMMIT_CONFIRM, READ_ONLY, READ_ONLY_AUTOCOMMIT, SINGLE_SITE, SINGLE_SITE_AUTOCOMMIT

Specifies the type of transaction model that is used when the non-Oracle database is updated by a transaction.

The following values are possible:

• COMMIT_CONFIRM provides read and write access to the non-Oracle database and allows the gateway to be part of a distributed update. To use the commit-confirm model, the following items must be created in the non-Oracle database:
  • Transaction log table. The default table name is HS_TRANSACTION_LOG. A different name can be set using the HS_FDS_TRANSACTION_LOG parameter. The transaction log table must be granted SELECT, DELETE, and INSERT privileges set to public.
  • Recovery account. The account name is assigned with the HS_FDS_RECOVERY_ACCOUNT parameter.
  • Recovery account password. The password is assigned with the HS_FDS_RECOVERY_PWD parameter.

    COMMIT_CONFIRM does not apply to Oracle Database Gateway for ODBC. The default value for Oracle Database Gateway for ODBC is SINGLE_SITE.

• READ_ONLY provides read access to the non-Oracle database.
• READ_ONLY_AUTOCOMMIT provides read access to the non-Oracle database that do not have logging.
• SINGLE_SITE provides read and write access to the non-Oracle database. However, the gateway cannot participate in distributed updates.
• SINGLE_SITE_AUTOCOMMIT provides read and write access to the non-Oracle database that do not have logging. Any update is committed immediately, and the gateway cannot participate in distributed updates.