A_DB2_ISOLATION_LEVEL configuration variable

Restriction: This topic applies only when a Database Connectors license has been installed via the Micro Focus License Management System.

Use the A_DB2_ISOLATION_LEVEL variable to set the isolation level. The default ordering of isolation levels is:

  1. SQL_TXN_READ_COMMITTED
  2. SQL_TXN_READ_UNCOMMITTED
  3. SQL_TXN_REPEATABLE_READ
  4. SQL_TXN_SERIALIZABLE

You can change the isolation level by setting this variable to an integer in the ACUFH configuration file. The settings are:

Isolation level Setting in ACUFH configuration file
SQL_TXN_READ_UNCOMMITTED    1
SQL_TXN_READ_COMMITTED 2
SQL_TXN_REPEATABLE_READ 3
SQL_TXN_SERIALIZABLE 4

For example, to set the isolation level to SQL_TXN_READ_COMMITTED, add the following entry to the ACUFH configuration file:

A_DB2_ISOLATION_LEVEL 2

If the user-set isolation level is not supported by the driver, the default method of selecting a level is used.