B.28 HS_FDS_TRANSACTION_ISOLATION
HS_FDS_TRANSACTION_ISOLATION
initialization parameter for Oracle Database Gateway for DRDA.
Property | Description |
---|---|
Default Value |
|
Range of Values |
{ |
Syntax |
|
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 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.
Parent topic: Initialization Parameters