HS_FDS_TRANSACTION_ISOLATION

HS_FDS_TRANSACTION_ISOLATION initialization parameter for Oracle Database Gateway for DRDA.

Property	Description
Default Value	READ_COMMITTED
Range of Values	{READ_UNCOMMITTED|READ_COMMITTED|REPEATABLE_READ|SERIALIZABLE|NONE}
Syntax	HS_FDS_ISOLATION_LEVEL={{READ_UNCOMMITTED|READ_COMMITTED|REPEATABLE_READ|SERIALIZABLE|NONE}

HS_FDS_TRANSACTION_ISOLATION specifies the isolation level that is used for the transaction that the gateway opens on the non-Oracle database.

The isolation level NONE is only valid against DB2 iSeries. It specifies level NO COMMIT. This isolation level will force an HS_TRANSACTION_MODEL of SINGLE_SITE_AUTOCOMMIT. Please refer to DB2's documentation regarding this level.

The isolation levels of READ_UNCOMMITTED, READ_COMMITTED, REPEATABLE_READ, and SERIALIZABLE are the four isolation levels defined in the SQL standard and adopted by both both ANSI and ISO/IEC. For additional information regarding them, see Oracle AI Database Concepts.

Use caution when specifying an isolation level lower than the Oracle transaction isolation level being used, as the gateway transaction will have different Preventable Read Phenomena from what will occur in the Oracle database transaction.